Sr. Data Engineer (51249)

Index Analytics is seeking a Data Engineer to support government clients by designing, building, and optimizing scalable data pipelines and cloud-based solutions. The role modernizes legacy analytics infrastructure through data engineering, cloud solutions engineering, and DevOps practices, using AWS and Snowflake.

Responsibilities:

• Collaborate closely with stakeholders and cross‑functional, internal technical teams to gather requirements, document business rules and develop a thorough understanding of the business context and objectives
• Analyze data, create meaningful insights, and present information clearly to stakeholders
• Leverage experience with Medicare and Medicaid data to build data access and semantic layers for data products
• Develop and optimize data models, both conceptual and physical, to support analytics, reporting, and operational consumption
• Implement data quality, validation, and monitoring frameworks to ensure accuracy and reliability
• Improve end-to-end performance of data workflows
• Develop and maintain cloud-based data infrastructure using AWS services such as S3, Lambda, Glue, Step Functions, CloudWatch, SQS, DynamoDB, SageMaker and Event Bridge
• Collaborate to design secure, scalable, and cost‑optimized data solutions
• Contribute to cloud governance, security, and best practices
• Design, build, and maintain scalable, reliable ETL/ELT data pipelines using AWS and Snowflake
• Ensure data workflows are modular, testable, and properly version‑controlled
• Operationalize pipelines with monitoring, alerting, and automated recovery mechanisms
• Meet schedule deadlines and commitments with a high-level of quality of deliverables
• Collaborate with a team of cross-functional resources in an Agile delivery environment to deliver iterative value

Requirements:

• US citizen or lived in the US for 3 of the last 5 years
• Bachelor's degree or equivalent with eight (8) or more years of experience as Data Engineer or similar role
• Hands-on experience in SQL and Python is required
• Prior working knowledge of CMS enterprise repositories like IDR
• Working knowledge of Medicare Part B & Part D data and Medicaid data
• Strong proficiency in AWS services, Snowflake
• Strong proficiency in GitHub for source control, branching strategy and reviews
• Knowledge of data integration patterns, data warehousing, and modern data architecture
• Experience with object‑oriented programming and building with software engineering principles
• DevOps exposure, including CI/CD tools like Jenkins
• Strong written and verbal communication skills are required, ability to collaborate, present, and report to stakeholders on findings
• Knowledge of Agile framework, Scrum methodologies and knowledge of tools used to support them
• Prior experience with government agencies is a plus