Senior Software Developer Engineer

JOB SUMMARY
Deliver analytics, dashboards, and insights using enterprise data. The role emphasizes SQL and AWS services to enable reliable and scalable reporting, KPI definition, and testing. The focus is analytics and reporting rather than ETL or pipeline development. The engineer will question assumptions, improve reporting efficiency, and drive better data-driven decisions.

Key Responsibilities
- Build and optimize SQL-based analytics and reporting solutions.
- Analyze data using AWS services including Athena, RDS, and Hive.
- Develop and maintain dashboards and KPI reports.
- Define and refine business metrics and KPIs with stakeholders.
- Improve analytics efficiency through reusable queries and views.
- Build lightweight automation and tools to reduce manual reporting effort.
- Ensure data accuracy and reliability through validation and testing.
- Perform regression testing of dashboards and reports.
- Conduct performance testing of queries.
- Execute unit and end-to-end testing.

Required Qualifications
- Strong SQL with advanced queries, optimization, and performance tuning.
- Experience with AWS analytics services such as Athena, RDS, and Hive.
- Background in data analysis and dashboarding.
- Understanding of KPIs, metrics, and reporting logic.
- Experience in data validation and testing.

Preferred Qualifications
- BI tools such as QuickSight, Tableau, or Power BI.
- AWS ecosystem exposure including S3, EMR, Glue, or Lambda.
- Basic Angular or frontend exposure.
- Python or scripting for automation.
- Experience with CI/CD and testing frameworks.