Position: Senior AWS Data Engineer
Location: Indianapolis, IN (Hybrid)
Duration: Long-Term Contract
Job Description
We are seeking an experienced Senior AWS Data Engineer with strong hands-on expertise in AWS data engineering, healthcare data projects, and performance optimization. The ideal candidate will have extensive experience building and optimizing scalable data pipelines using AWS Glue, PySpark, Python, SQL, and Apache Airflow.
Mandatory Skills
· Strong experience in AWS Data Engineering.
· Hands-on expertise in AWS Glue, PySpark, and Apache Airflow.
· Healthcare domain / healthcare data project experience.
· Advanced SQL and Python programming.
· Apache Spark and distributed data processing.
· AWS services: S3, Glue, Redshift, Athena, and Lambda.
· Data lakes, lakehouse architecture, data warehouses, and dimensional modeling.
Key Responsibilities
· Design, develop, and maintain scalable AWS-based ETL/ELT data pipelines.
· Optimize complex SQL queries and PySpark/Spark workloads.
· Troubleshoot performance bottlenecks, data skew, shuffle operations, and memory utilization.
· Optimize AWS Glue, Amazon Redshift, and Amazon Athena workloads.
· Implement data quality checks, automated testing, monitoring, and error-handling mechanisms.
· Perform root-cause analysis and production support.
· Improve data pipeline performance, scalability, reliability, and cost efficiency.
· Collaborate with business and technical stakeholders to deliver reliable data solutions.
· Mentor engineers and promote coding best practices.
Good to Have
· Apache Kafka / Amazon Kinesis.
· Amazon Bedrock, Generative AI, LLMs, embeddings, and vector databases.
· Excel/CSV ingestion and schema evolution.
· Git, CI/CD, and automated testing.
Alchemy: Transforming Your Professional Vision into Reality
Since our inception in 2013, Alchemy has been dedicated to reshaping organizational performance through innovative IT services. With a vision to empower businesses seeking a transformative edge, we’ve positioned ourselves at the forefront of digitization and software modernization.
Our name reflects our mission: to transmute technology into gold-standard solutions for our esteemed clients. We proudly serve a diverse range of sectors, including IT and ITES, BFSI, Telecom and Media, Automotive, Manufacturing, Energy, Oil and Gas, Real Estate, Retail, Healthcare, and more.
With a global footprint spanning the USA, India, Europe, Canada, Singapore, Japan, and parts of Central and West Africa, we harness a unique blend of competencies, frameworks, and cutting-edge technologies. Together, we drive growth and innovation across industries, helping organizations turn their visions into reality.
Alchemy – Connecting Talent with Opportunities (Diversity, Equity and Inclusion)