Data Engineering Consultant

Role Overview Optum is seeking an experienced Data Engineering Consultant to join its growing data and analytics team in Hyderabad. This is a high-impact hybrid role designed for seasoned data professionals with deep expertise in ETL/ELT architecture, cloud-based data platforms, and healthcare data ecosystems. The ideal candidate will bring strong technical proficiency in Azure, Databricks, Spark, and industry-standard data integration tools, and will play a pivotal role in building scalable, reliable data solutions that drive clinical and business intelligence across healthcare domains. This position actively welcomes applications from women candidates, including those returning to the workforce. Key Responsibilities The Data Engineering Consultant will oversee and participate in the complete data engineering lifecycle — from research and proof-of-concept through design, development, testing, deployment, and ongoing maintenance of enterprise data management solutions. You will lead data acquisition initiatives, ingesting structured and semi-structured data from multiple source systems to populate client data warehouses and enable analytics across healthcare domains. You will architect and implement robust ETL/ELT pipelines for loading DataMarts and reporting aggregates using both relational and dimensional data models. A key part of the role involves identifying and resolving data quality issues at the root level, conducting data audits, and maintaining data integrity standards. You will collaborate closely with the broader analytics organization to recommend architectural improvements to data platforms and support the rollout of modern data frameworks that power advanced analytics and business intelligence reporting. Additionally, you will prepare high-level and detailed technical design documents, leverage DevOps tooling for version control and deployment, and use pipeline monitoring tools to proactively detect and address data integrity issues before they surface in production. Ongoing contribution to technical debt reduction, documentation standards, and data governance practices is also expected. Required Qualifications See requirements section below. Why Join Us Optum, a part of UnitedHealth Group, is one of the world's leading health services and innovation companies. Working here means contributing to meaningful outcomes that improve lives at scale. You will collaborate with some of the brightest minds in data engineering and healthcare technology, working on complex, real-world data challenges with cutting-edge cloud infrastructure. Optum is committed to building a diverse and inclusive workforce, and this role is part of that mission.

Bachelor's degree in Information Technology, Engineering, Computer Science, Mathematics, Analytics, or a related discipline 5 or more years of hands-on experience in data engineering covering ingestion, normalization, transformation, aggregation, structuring, and storage 5 or more years of experience working 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 and querying data assets using SQL, Python, Scala, VB.NET, or equivalent languages 3 or more years of experience with Microsoft Azure Cloud services including Azure Data Factory, Azure Databricks, Spark, Scala or Python, and Azure DevOps 3 or more years of experience working with healthcare data or supporting data needs of healthcare organisations Demonstrated ability to eliminate unnecessary complexity and reduce system interdependencies Experience preparing technical design documentation and supporting high-quality data governance practices Familiarity with DevOps practices for code versioning and deployment pipelines Ability to troubleshoot production data issues using diagnostic and monitoring tools

Hybrid work model offering flexibility between home and office Opportunity to work on large-scale healthcare data platforms with real-world impact Inclusive hiring practices welcoming women candidates and career returners Collaborative environment with access to cutting-edge cloud and data technologies Career growth opportunities within a globally recognised healthcare technology organisation