Analytics Engineer

About

Senior role focused on delivering analytics, dashboards, and insights using existing enterprise data. Works across SQL and AWS (Athena, RDS, Hive) to enable business decision-making through reliable and scalable reporting solutions. Not an ETL/data pipeline role.

Key Responsibilities

• Build and optimize SQL-based analytics and reporting solutions
• Analyze data using AWS services (Athena, RDS, 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/tools to reduce manual reporting effort
• Ensure data accuracy and reliability through validation and testing
• Perform testing, including:
  • Regression testing of dashboards/reports
  • Performance testing of queries
  • Unit and end-to-end (E2E) testing

Must-Have Skills

• Strong SQL (advanced queries, optimization, performance tuning)
• Experience with AWS analytics services (Athena, RDS, Hive)
• Strong background in data analysis and dashboarding
• Understanding of KPIs, metrics, and reporting logic
• Experience in data validation and testing

Good-to-Have Skills

• BI tools (QuickSight, Tableau, Power BI)
• AWS ecosystem (S3, EMR, Glue, Lambda)
• Basic Angular/frontend exposure
• Python or scripting for automation
• Experience with CI/CD and testing frameworks

Focus

• Analytics, reporting, and insights (not ETL)
• AWS-based data querying