Analytics Engineer (AWS)

Analytics Engineer (AWS)

Location: UAE

Job Summary

We are looking for an experienced Analytics Engineer to build scalable data models, develop analytics solutions, and deliver business insights using AWS data services. The ideal candidate will have strong SQL, Tableau, Python, and AWS data platform experience.

Key Responsibilities

Data Modeling & Analytics

• Design and maintain scalable data models for reporting and analytics.
• Query and transform large datasets using AWS services including Redshift, Athena, S3, and Glue.
• Develop optimized SQL queries, views, and datasets for analytical reporting.
• Build and maintain star schemas, SCDs, and incremental data models.

BI & Reporting

• Develop interactive dashboards and reports using Tableau.
• Create semantic layers, metric definitions, and business-friendly datasets.
• Deliver executive-level reporting and operational performance insights.
• Support self-service analytics capabilities across the business.

Data Engineering & Cloud Integration

• Develop and maintain ETL pipelines using Python.
• Work with AWS data services to manage data ingestion, transformation, and reporting.
• Ensure data accuracy, performance, and governance across analytics platforms.

Collaboration & Support

• Work closely with business stakeholders to understand reporting requirements.
• Translate business needs into scalable analytics solutions.
• Support ongoing enhancements and optimization of analytics platforms.

Experience

• 3+ years of experience in Analytics Engineering, BI, Data Analytics, or Data Engineering.
• Strong experience developing Tableau dashboards and reports.
• Minimum 2+ years of hands-on Python experience (Pandas, Boto3).
• Experience working with large-scale enterprise datasets.

Technical Skills

• Advanced SQL including:
• Window Functions
• Query Optimization
• Performance Tuning
• Partitioning Strategies
• Strong understanding of:
• Data Modeling
• Star Schema Design
• Slowly Changing Dimensions (SCD)
• Columnar Data Formats (Parquet, ORC)
• Hands-on experience with:
• Amazon Redshift
• Amazon Athena
• Amazon S3
• AWS Glue
• AWS IAM

Nice to Have

• AWS Step Functions experience.
• Experience with AWS Data Exports and Cost & Usage Reporting.
• Knowledge of IoT or device telemetry analytics.
• Tableau or AWS certifications.