Analytics Engineer (AWS)
STATERA · Dubai, United Arab Emirates
Apply & track with Apply EdgeAnalytics Engineer (AWS)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 ResponsibilitiesQuery and transform large-scale datasets using Amazon Athena, Redshift, S3 and AWS Glue Data CatalogDesign and maintain scalable analytical data modelsBuild Star Schemas, SCD tables and incremental data modelsDevelop complex and optimized SQL queries, views, CTEs and window functionsOptimize analytical workloads through partition pruning, query tuning and schema optimizationDevelop ETL/data transformation pipelines using Python (pandas, boto3)Develop and maintain enterprise Tableau dashboardsDefine semantic layers, KPIs, metrics and metadata mappingsCreate data stories, executive dashboards and drill-through analyticsSupport self-service BI and data-driven decision-makingRequired SkillsStrong hands-on experience with AWS Data Stack: Redshift, Athena, S3, GlueAdvanced SQL skills2+ years of hands-on Python experience, especially pandas and boto3Strong understanding of Data ModelingExperience with Star Schema, SCD and incremental data modelsKnowledge of Parquet / ORC columnar formatsExperience with AWS IAM and data-access controlsProven experience developing enterprise dashboards with TableauStrong analytical and problem-solving skillsNice to HaveAWS Step Functions for ETL orchestrationAWS Data ExportsCloud cost & usage analyticsIoT / machine diagnostic telemetry analyticsAI-driven analytics and insightsTableau Desktop Certified ProfessionalAWS Certified Data Analytics or AWS Certified Cloud PractitionerKey TechnologiesAWS | Redshift | Athena | S3 | Glue | IAM | SQL | Python | pandas | boto3 | Tableau | ETL | Data Modeling | Star Schema | SCD | Parquet | ORC