Data Engineering Consultant

Optum India; Hyderabad; On-site; INR 2,500,000 - 4,000,000; Full time

Job summary

Optum India in Hyderabad is seeking a data engineer to design and maintain data pipelines, integrating large datasets from diverse sources to support business insights. You will work on ETL processes, implement medallion architecture, and ensure data quality and security across cloud platforms.

The role requires hands-on experience with DBT, Delta Lake, SQL, Python/Java, and cloud services (Azure/AWS/GCP). You will collaborate with data scientists and analysts to enable scalable data solutions.

Qualifications

• Experience with DBT Core and AI-driven test case prep using GitHub Copilot.
• Knowledge of data security best practices, encryption, and access controls.
• Familiarity with the medallion data architecture (Bronze, Silver, Gold).
• Healthcare domain knowledge is beneficial for data governance.

Responsibilities

• Developing Data Pipelines: Creating and maintaining optimal data pipeline architectures to ensure efficient data flow and processing
• Data Integration: Assembling large, complex data sets from various sources to meet business requirements
• Process Improvement: Automating manual processes and optimizing data delivery
• Infrastructure Building: Designing and building ETL infrastructure using technologies like DBT and Delta Lake
• SQL and AWS Collaboration: Supporting data infrastructure needs and resolving data-related issues
• Data Quality: Running tests to identify and fix errors and adapt to changes

Skills

DBT Core

AI experience

Data security

Medallion architecture

Python

Java

Delta Lake

Data warehousing

Cloud computing

Data Vault

Data modeling

Relational/NoSQL DBMS

Azure Data Factory

ETL (DBT)

Tools

DBT

DBT framework/packages

Job description

Optum is a global organization that delivers care, aided by technology to help millions of people live healthier lives. The work you do with our team will directly improve health outcomes by connecting people with the care, pharmacy benefits, data and resources they need to feel their best. Here, you will find a culture guided by inclusion, talented peers, comprehensive benefits and career development opportunities. Come make an impact on the communities we serve as you help us advance health optimization on a global scale. Join us to start Caring. Connecting. Growing together.

Primary Responsibilities

• Developing Data Pipelines: Creating and maintaining optimal data pipeline architectures to ensure efficient data flow and processing
• Data Integration: Assembling large, complex data sets from various sources to meet business requirements
• Process Improvement: Identifying and implementing internal process improvements, such as automating manual processes and optimizing data delivery
• Infrastructure Building: Designing and building the infrastructure required for data extraction, transformation, and loading (ETL) using technologies like
• SQL and AWS Collaboration: Working with stakeholders, including data scientists, analysts, and executives, to support their data infrastructure needs and resolve data-related technical issues
• Data Quality: Running tests to isolate errors and updating systems to accommodate changes in company needs.
• Comply with all applicable Company policies, procedures, and business directives, changes including those relating to work location, team assignments, work schedules, and flexible work arrangements

Required Qualifications

• Experience with DBT Core
• AI experience to generate and prepare test cases using GitHub Copilot
• Data Security: Knowledge of data security best practices, encryption, and access controls
• Medallion Architecture: Knowledge of the medallion architecture, which organizes data layers (Bronze, Silver, Gold) in a lakehouse
• Health care domain knowledge
• Programming Languages: Familiarity with languages like Python or Java for data analysis and application development
• Delta Lake: Familiarity with Delta Lake, an open-table format that combines data lake flexibility with ACID transactions
• Data Warehousing: Understanding of data warehousing concepts, including data storage, retrieval, and optimization
• Cloud Computing: Understanding of cloud platforms (e.g., Azure, AWS, GCP) and their data services
• Data Vault: Understanding of the Data Vault methodology for scalable and flexible data warehousing
• Data Modeling: Proficiency in creating logical and physical data models to represent business requirements and system architecture
• Database Management Systems (DBMS): Proficiency in relational databases (e.g., Microsoft SQL Server) and NoSQL databases
• Azure Data Factory (ADF): Proficiency in using ADF for orchestrating data workflows, data movement, and transformation
• ETL (Extract-Transform-Load): Proven expertise in ETL processes and tools like DBT (Data Build Tool) and DBT framework/packages

At UnitedHealth Group, our mission is to help people live healthier lives and make the health system work better for everyone. We believe everyone-of every race, gender, sexuality, age, location and income-deserves the opportunity to live their healthiest life. Today, however, there are still far too many barriers to good health which are disproportionately experienced by people of color, historically marginalized groups and those with lower incomes. We are committed to mitigating our impact on the environment and enabling and delivering equitable care that addresses health disparities and improves health outcomes - an enterprise priority reflected in our mission.