Staff Engineer I - Software Engineering

Actively Reviewing the Applications

Acentra Health

India, Tamil Nadu, Chennai Full-Time On-site

Posted 6 hours ago • Apply by June 14, 2026

Job Description

Job Summary

Job Summary and Responsibilities

We are seeking a skilled and motivated Data Engineer with 5-9 years of experience in building scalable data solutions using the AWS tech stack. The ideal candidate will have strong expertise in AWS data services, data modeling, and Amazon Redshift, with hands-on experience designing and optimizing cloud-based data warehouses and ETL/ELT pipelines.

This role requires a deep understanding of modern data architectures, performance optimization, and best practices in data engineering within AWS environments.

Key Responsibilities

Design, develop, and maintain scalable data pipelines using AWS services.
Build and optimize data warehouse solutions using Amazon Redshift.
Develop and implement data models (dimensional modeling, star/snowflake schemas) aligned with business reporting and analytics needs.
Design ETL/ELT workflows using tools such as AWS Glue, Lambda, EMR, or other AWS-native services.
Optimize Redshift performance through distribution keys, sort keys, partitioning, and workload management (WLM).
Ensure data quality, data governance, and security best practices.
Work closely with data analysts, BI teams, and stakeholders to understand data requirements.
Implement CI/CD practices for data pipelines.
Monitor, troubleshoot, and enhance data platform reliability and performance.
Support cloud migration initiatives from on-prem to AWS where applicable.

Job Requirements And Qualifications

Required Skills & Qualifications

5-9 years of experience in Data Engineering.
Strong hands-on experience with:

Amazon Redshift (RA3 nodes, Spectrum, performance tuning)
AWS S3
AWS Glue
AWS Lambda
AWS IAM
AWS CloudFormation or Terraform

Strong expertise in SQL and query optimization.
Solid experience in data modeling (OLAP, dimensional modeling, fact/dimension design).
Experience building and managing ETL/ELT pipelines.
Proficiency in Python or Scala for data processing.
Experience working with large-scale structured and semi-structured datasets.
Understanding of data partitioning, compression, indexing, and workload management in Redshift.
Familiarity with CI/CD pipelines in AWS (CodePipeline, CodeBuild, or similar tools).
Strong understanding of data governance, security, and access controls in AWS.