Analytics Engineer (AWS)

STATERA; Dubai; On-site; AED 180,000 - 280,000; Full time

Job summary

STATERA is seeking an experienced Analytics Engineer (AWS) to design scalable analytics solutions within the AWS ecosystem. You will work on a data and analytics project, building analytics data models, star schemas, and incremental data structures.

You will develop complex SQL queries, establish semantic layers and KPIs, and create executive dashboards in Tableau to empower self-service BI and data-driven decisions. Dubai-based with experience in AWS stack is preferred.

Qualifications

• Proven experience with AWS analytics stack and data modeling.
• Advanced SQL skills and Python (pandas, boto3) experience.
• Experience building enterprise dashboards with Tableau.
• Knowledge of data governance and security best practices.

Responsibilities

• Query and transform large-scale datasets using AWS tools.
• Design and maintain scalable analytical data models.
• Build Star Schemas, SCD tables and incremental data models.
• Develop optimized SQL queries, views, and window functions.
• Define semantic layers, KPIs, metrics, and metadata mappings.
• Create data stories and dashboards for executives.
• Support self-service BI and data-driven decision-making.

Skills

AWS Data Stack

SQL

Python (pandas/boto3)

Data Modeling

Star Schema/SCD

Parquet/ORC formats

AWS IAM

Tableau

Analytical thinking

Tools

AWS Redshift

AWS Athena

AWS S3

AWS Glue

Tableau

Parquet/ORC

Job description

We are looking for an experienced Analytics Engineer (AWS) to join a data & analytics project and contribute to the design of scalable analytics solutions within the AWS ecosystem.

Key Responsibilities

• Query and transform large-scale datasets using Amazon Athena, Redshift, S3 and AWS Glue Data Catalog
• Design and maintain scalable analytical data models
• Build Star Schemas, SCD tables and incremental data models
• Develop complex and optimized SQL queries, views, CTEs and window functions
• Optimize analytical workloads through partition pruning, query tuning and schema optimization
• Define semantic layers, KPIs, metrics and metadata mappings
• Create data stories, executive dashboards and drill-through analytics
• Support self-service BI and data-driven decision-making

Required Skills

• Strong hands-on experience with AWS Data Stack: Redshift, Athena, S3, Glue
• Advanced SQL skills
• 2+ years of hands-on Python experience, especially pandas and boto3
• Strong understanding of Data Modeling
• Experience with Star Schema, SCD and incremental data models
• Knowledge of Parquet / ORC columnar formats
• Experience with AWS IAM and data-access controls
• Proven experience developing enterprise dashboards with Tableau
• Strong analytical and problem-solving skills

Nice to Have

• AWS Step Functions for ETL orchestration
• AWS Data Exports
• Cloud cost & usage analytics
• IoT / machine diagnostic telemetry analytics
• AI-driven analytics and insights
• AWS Certified Data Analytics or AWS Certified Cloud Practitioner

Key Technologies