AWS Data Engineer

Job Title: AWS Data Engineer

Location : Fort Mill, SC or New York City, NY (Hybrid)

Job Summary

We are seeking a highly skilled AWS Data Engineer to design, develop, and optimize large-scale data pipelines and ETL workflows on AWS. The ideal candidate will have strong expertise in AWS cloud-native data services, data modeling, and pipeline orchestration, with hands-on experience building robust and scalable data solutions for enterprise environments.

Key Responsibilities

• Design, develop, and maintain ETL pipelines using AWS Glue, Glue Studio, and Glue Catalog .
• Ingest, transform, and load large datasets from structured and unstructured sources into AWS data lakes/warehouses.
• Work with S3, Redshift, Athena, Lambda, and Step Functions for data storage, query, and orchestration.
• Build and optimize PySpark/Scala scripts within AWS Glue for complex transformations.
• Implement data quality checks, lineage, and monitoring across pipelines.
• Collaborate with business analysts, data scientists, and product teams to deliver reliable data solutions.
• Ensure compliance with data security, governance, and regulatory requirements (BFSI preferred).
• Troubleshoot production issues and optimize pipeline performance.

Required Qualifications

• 12+ years of experience in Data Engineering , with at least 5+ years on AWS cloud data services .
• Strong expertise in AWS Glue, S3, Redshift, Athena, Lambda, Step Functions, CloudWatch .
• Proficiency in PySpark, Python, SQL for ETL and data transformations.
• Experience in data modeling (star, snowflake, dimensional models) and performance tuning.
• Hands-on experience with data lake/data warehouse architecture and implementation.
• Strong problem-solving skills and ability to work in Agile/Scrum environments.

Preferred Qualifications

• Experience in BFSI / Wealth Management domain .
• AWS Certified Data Analytics – Specialty or AWS Solutions Architect certification.
• Familiarity with CI/CD pipelines for data engineering (CodePipeline, Jenkins, GitHub Actions).
• Knowledge of BI/Visualization tools like Tableau, Power BI, QuickSight .