We are looking for a Senior Data Engineer to design, build, and maintain data pipelines across our health plan technology platform, spanning AWS-native data services and existing SQL Server/SSIS ETL processes. This role sits alongside the other engineering teams in this application landscape (software engineering, Data/BI & Integration, DevOps, and Edifecs EDI), and carries dual responsibility: keeping current SQL Server/SSIS workloads reliable, and helping migrate and modernize them onto AWS-native pipelines.

‍

Key Responsibilities

Design, build, and maintain ETL/ELT pipelines using AWSGlue, Lambda, and Step Functions to ingest, transform, and load data acrossAWS-based data platforms (S3, Redshift, Athena)
Maintain, enhance, and troubleshoot existing SQLServer-based ETL processes built in SSIS, including packages, control flows,data flows, and error handling
Write and optimize complex T-SQL queries, storedprocedures, and views supporting reporting and downstream applications




Support ongoing migration and modernization of legacySQL Server/SSIS ETL workloads to AWS-native data pipelines
Design and maintain data models (dimensional/starschema) supporting analytics and reporting use cases
Use AWS Database Migration Service (DMS) and relatedtools to support data migration from on-premises SQL Server to AWS
Implement data quality checks, validation, andmonitoring across ETL pipelines
Optimize pipeline performance, reliability, and costacross both AWS-native and SQL Server/SSIS workloads
Partner with BI, integration, and application teams(including the Power BI and Edifecs/EDI teams within this applicationlandscape) to ensure data availability and consistency across systems
Document data flows, pipeline architecture, and datamodels to support internal knowledge sharing
Troubleshoot and resolve production data pipelineissues, including root-cause analysis
Mentor junior engineers on data engineering and ETL/ELTbest practices

‍

Required Qualifications

Bachelor's degree

📌 Senior Data Engineer (Hyderabad)
🏢 Simplify AlphaTM
📍 Hyderabad