Join Optum, a global leader dedicated to improving health outcomes through innovative technology. We are seeking a skilled Data Engineering Consultant to build, test, and deploy enterprise data products for Optum Insight. This role offers a fantastic opportunity to leverage your data engineering expertise in a supportive, inclusive environment with excellent career development prospects.

Your work will directly contribute to advancing health optimization globally. Be part of a culture that emphasizes Caring, Connecting, and Growing together as you make a significant impact on the communities we serve.

In this hands-on role, you will translate architectural designs into robust, scalable data products. You will develop and maintain data pipelines across bronze, silver, and gold layers using modern medallion architecture principles.

Key responsibilities include: - Building and maintaining enterprise data products according to specifications. - Developing complex SQL and PySpark transformations. - Implementing ETL/ELT pipelines for data ingestion and transformation. - Optimizing SQL, Spark jobs, and storage structures for performance and reliability. - Performing unit and integration testing, including data reconciliation and quality validation. - Troubleshooting data pipeline failures and performance issues. - Collaborating with Data Architects, Product Owners, and other engineers.

We are looking for a versatile engineering generalist with strong foundational data engineering skills. A Bachelor's degree in a relevant field or equivalent experience is required, along with 3-5 years of hands-on experience in data engineering, data warehousing, or software engineering.

Essential technical skills include: - Proficiency in SQL and PySpark. - Hands-on experience with Databricks or similar cloud data platforms. - Experience building production data pipelines and datasets. - Familiarity with Microsoft Azure or comparable cloud infrastructure. - Understanding of medallion architecture and data lake/lakehouse concepts. - Experience with Git for source control and modern development practices. - Strong debugging, analytical, and problem-solving abilities.