Data Engineering Consultant

Role Overview Optum India, a global leader in health technology and care delivery, is looking for an experienced Data Engineering Consultant to join its Chennai team. In this role, you will play a pivotal part in building and maintaining robust data pipelines and management solutions that directly improve health outcomes for millions of people worldwide. You will work at the intersection of healthcare and data engineering, contributing to a mission-driven organization that values inclusion, innovation, and continuous growth. Key Responsibilities - Support the complete data engineering lifecycle including research, proof of concepts, design, development, testing, deployment, and ongoing maintenance of data management solutions - Lead data acquisition initiatives to collect and ingest data from structured and semi-structured source systems into client data warehouses and analytics platforms across healthcare domains - Apply ETL and ELT methodologies to process complex relational and dimensional data for loading DataMarts and reporting aggregates - Detect and resolve data quality issues by identifying root causes, implementing fixes, and managing data audits to ensure data integrity - Implement and maintain data integration workflows that improve efficiency, reliability, and overall data value - Collaborate with the analytics organization to recommend improvements to data systems and platform architecture - Prepare high-level and detailed technical design documents following best practices for data ingestion, transformation, and movement - Use DevOps tools for code versioning and deployment, and leverage pipeline monitoring tools to detect data integrity issues proactively - Drive technical debt reduction, process improvements, and continuous optimization of data solutions - Ensure all solutions meet business requirements for security, scalability, and reliability while maintaining data governance and transparency Required Qualifications - Bachelor's degree in Information Technology, Engineering, Computer Science, Mathematics, Analytics, or a related discipline - 5 or more years of combined experience in data engineering including ingestion, normalization, transformation, aggregation, and storage - 5 or more years of hands-on experience with relational, dimensional, or non-relational data storage systems - 5 or more years of experience designing ETL and ELT solutions using tools such as Informatica, DataStage, SSIS, PL/SQL, or T-SQL - 5 or more years of experience managing data assets using SQL, Python, Scala, VB.NET, or similar languages - 3 or more years of experience with Microsoft Azure Cloud, Azure Data Factory, Databricks, Spark, Scala, Python, ADO, and GitHub with expert-level SQL skills - 3 or more years of experience working with healthcare data or supporting healthcare organizations Why Join Us At Optum India, you will be part of a purpose-led global organization where your work directly impacts health outcomes and community wellbeing. Enjoy a culture built on inclusion, career development opportunities, and comprehensive benefits as you help advance health optimization on a global scale.

- 5+ years experience in data engineering, ingestion, transformation, and storage - 5+ years experience with relational, dimensional, or non-relational database systems - 5+ years experience designing ETL/ELT solutions using Informatica, DataStage, SSIS, PL/SQL, or T-SQL - 5+ years experience with SQL, Python, Scala, or VB.NET for data asset management - 3+ years experience with Microsoft Azure Cloud, Azure Data Factory, Databricks, Spark, ADO, and GitHub - 3+ years experience working with healthcare data or healthcare organizations - Advanced SQL skills - Bachelor's degree in IT, Engineering, Computer Science, or related field

- Comprehensive health and wellness benefits - Career development and growth opportunities - Inclusive and diverse work culture - Opportunity to work on global-scale healthcare impact projects