AWS Data Engineer / Data Architect

Contenterra Software; Hyderabad; On-site; INR 3,500,000 - 7,000,000; Full time

Job summary

Contenterra Software in Hyderabad is seeking an experienced AWS Data Engineer/Architect to design and implement scalable data pipelines and data models on AWS, handling ingestion through analytics-ready datasets.

The role emphasizes hands-on Glue, S3, Redshift/Athena, and data governance, with collaboration across BI and data science teams. A strong emphasis on SCD1/2, PII masking, and multi-region integration is required.

Qualifications

• 8+ years in data engineering with hands-on AWS experience (Glue, S3, Redshift/Athena, Lake Formation).
• Proven expertise in AWS Glue (PySpark/Python).
• Strong grasp of dimensional modeling (fact/dimension, star schema).
• Hands-on experience with SCD1 & SCD2 implementation.
• Experience with PII masking/anonymization.
• Experience in data quality management (validation, reconciliation, monitoring).
• Excellent ability to explain technical decisions to stakeholders.

Responsibilities

• Build and maintain data lake pipelines on AWS using Medallion (Bronze-Silver-Gold) architecture.
• Develop ETL/ELT pipelines using AWS Glue (Glue Jobs, Crawlers, Catalog).
• Consolidate multi-region/multi-source data into common dimensions.
• Ensure data quality through validation, reconciliation, and monitoring.
• Collaborate with BI and Data Science teams on shared datasets.

Skills

AWS Data Engineering

Glue PySpark Python

S3

Redshift Athene?

Lake Formation

Dimensional Modeling

SCD1/SCD2

PII Masking & Governance

Data Quality

Communication

Tools

AWS Glue

PySpark

Airflow / MWAA

Step Functions

Job description

Job Description: AWS Data Engineer / Data Architect

Experience: 8+ years

Location:Hyderabad

Employment Type: Full-Time

About the Role

We're hiring a hands-on AWS Data Engineer/Architect to build scalable data pipelines and models on AWS from raw ingestion to business-ready datasets powering reporting and analytics.

Key Responsibilities

• Build and maintain data lake pipelines on AWS using Medallion (Bronze-Silver-Gold) architecture
• Develop ETL/ELT pipelines using AWS Glue (Glue Jobs, Crawlers, Catalog)
• Design dimensional data models (fact/dimension tables, star schema)
• Implement SCD1/SCD2 logic for historical data tracking
• Apply PII masking and data governance in collaboration with compliance teams
• Consolidate multi-region/multi-source data into common dimensions
• Ensure data quality through validation, reconciliation, and monitoring
• Collaborate with BI and Data Science teams on shared datasets

Required Skills

• 8+ years in data engineering, with strong hands-on AWS experience (Glue, S3, Redshift/Athena, Lake Formation)
• Proven expertise in AWS Glue (PySpark/Python)
• Strong grasp of dimensional modeling (fact/dimension, star schema)
• Hands-on experience with SCD1 & SCD2 implementation
• Experience with PII masking/anonymization
• Experience in data quality management (validation, reconciliation, monitoring)
• Strong communication skills to explain technical decisions to stakeholders

Good to Have

• HR/workforce analytics experience
• Orchestration tools (Airflow/MWAA, Step Functions)
• Experience scaling data platforms across multiple countries/regions

Thank you!