Join Optum, a global leader dedicated to improving health outcomes through innovative technology. We are seeking a Data Engineering Consultant to develop and manage robust data pipelines, integrate complex datasets, and optimize data infrastructure. This role offers a unique opportunity to contribute to advancing health optimization on a global scale within an inclusive culture that fosters collaboration and career development.

Our mission at UnitedHealth Group is to empower healthier lives and enhance the efficiency of the healthcare system for all. We are committed to addressing health disparities and fostering equitable care, making this role pivotal in our pursuit of a healthier future.

Key responsibilities include developing and maintaining optimal data pipeline architectures for efficient data flow and processing. You will assemble large, complex datasets from various sources to meet business needs and identify opportunities for process improvement, including automation and data delivery optimization.

This role involves designing and building the necessary infrastructure for data extraction, transformation, and loading (ETL) using technologies like SQL and AWS. You will collaborate with stakeholders, including data scientists and analysts, to support their data infrastructure requirements and resolve technical challenges. Ensuring data quality through testing and system updates to accommodate evolving company needs is also crucial.

We are looking for candidates with experience in DBT Core and AI for test case generation using GitHub Copilot. A strong understanding of data security best practices, encryption, and access controls is essential.

Familiarity with the Medallion Architecture, data warehousing concepts, and programming languages such as Python or Java is required. Proficiency in Delta Lake, Data Vault methodology, data modeling, and database management systems (both relational like Microsoft SQL Server and NoSQL) is expected.

Expertise in Azure Data Factory (ADF) for orchestrating data workflows and proven experience with ETL processes and tools like DBT and its framework/packages are necessary. Knowledge of cloud platforms (Azure, AWS, GCP) and their data services is also a prerequisite.