Senior Data Engineer

UnitedHealth Group; Dublin; Hybrid; Confidential; Full time

Job summary

UnitedHealth Group is seeking a Senior Data Engineer in Ireland to design and implement complex data pipelines. You will work with Snowflake, Airflow, Azure, and related technologies to deliver scalable data solutions for analytics and reporting.

The role involves collaborating with data, architecture, and business teams to ensure data quality and integrity while enabling advanced analytics and AI/ML initiatives in a hybrid Dublin/Letterkenny setup.

Qualifications

• Bachelor's degree in a related field.
• Hands-on experience as a Data Engineer.
• Strong SQL skills including window functions.
• Knowledge of data warehousing, data architecture, and data masking.
• Proficiency in Python.
• Experience building data pipelines with Snowflake and complex SQL.
• Experience CI/CD with Git and GitHub Actions.
• Familiarity with relational and non-relational databases.

Responsibilities

• Integrate data from multiple on-prem and cloud sources to build a unified data foundation.
• Develop data transformation routines for cleaning, normalization, and aggregation.
• Implement data de-identification/data masking per company standards.
• Create monitoring tools to automate error handling and ensure data integrity.
• Use Great Expectations or Soda to ensure data quality across lifecycles.
• Build data pipelines with Airflow and Snowflake as primary tools.
• Design SQL stored procedures to fulfill use-cases.
• Create logical/physical data models to maintain data integrity.
• Develop CI/CD pipelines using Git/GitHub Actions.

Skills

SQL

Python

Snowflake

Airflow

Azure

CI/CD

Git & GitHub Actions

Data modeling

Education

Bachelor's degree in Computer Science or related field

Tools

Snowflake

Airflow

Azure

Docker

Kubernetes

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 diversity and inclusion, talented peers, comprehensive benefits and career development opportunities. Come make an impact on the communities we serve as you help us advance health equity on a global scale. Join us to start Caring. Connecting. Growing together.

UHC Payment Integrity (PI) in partnership with Optum PI, Optum Analytics and the UHG CDO office are in the process of building a scalable data intel and performance delivery solution that will provide the necessary data insights, management controls and business intelligence to more effectively run the business and modernize data to drive growth and enhanced Provider experiences.

This effort will result in a scalable solution offering four key capabilities that include but are not limited to, a secure single source of truth PI claims data repository, interactive data visualization capabilities (financial, operational, experience), integrated early alert and management remediation controls and an advanced data center that enables the use of advanced analytics and leveraging AI/ML to modernize data.

About the role:

As a Senior Data Engineer, you will be responsible for the development of complex data sources and pipelines into our data platform (i.e. Snowflake) along with other data applications (i.e. Azure, Airflow, etc.) and automation.

The Senior Data Engineer will work closely with the data, Architecture, Business Analyst, Data Stewards to integrate and align requirements, specifications and constraints of each element of the requirement. They will also need to help identify gaps in resources, technology, or capabilities required, and work with the data engineering team to identify and implement solutions where appropriate.

Careers with Optum offer flexible work arrangements and individuals who live and work in the Republic of Ireland will have the opportunity to split their monthly work hours between our Dublin or Letterkenny office and telecommuting from a home-based office in a hybrid work model.

What you will do:

• Integrate data from multiple on prem and cloud sources and systems. Handle data ingestion, transformation, and consolidation to create a unified and reliable data foundation for analysis and reporting
• Develop data transformation routines to clean, normalize, and aggregate data. Apply data processing techniques to handle complex data structures, handle missing or inconsistent data, and prepare the data for analysis, reporting, or machine learning tasks
• Implement data de-identification/data masking in line with company standards
• Develop monitoring tools to automate error handling mechanisms to ensure data integrity and system reliability
• Utilize data quality tools like Great Expectations or Soda to ensure the accuracy, reliability, and integrity of data throughout its lifecycle
• Create, maintain & monitor data pipelines using Airflow & Snowflake as primary tools
• Understand data requirements and design optimal SQL stored procs to fulfil the use-cases
• Creating logical & physical data models to ensure data integrity is maintained
• CI CD pipeline creation & automation using GIT & GIT Actions

You will be rewarded and recognized for your performance in an environment that will challenge you and give you clear direction on what it takes to succeed in your role, as well as providing development for other roles you may be interested in.

What you will bring:

• Bachelor's degree or higher in Database Management, Information Technology, Computer Science, or a related field
• Proven hands-on experience as a Data Engineer
• Demonstrated proficiency in SQL, including experience utilizing window functions and advanced SQL capabilities
• Demonstrated knowledge of data modeling techniques, data warehousing principles, data architecture, data masking, and implementation methodologies
• Demonstrated solid proficiency in Python
• Proven hands-on experience developing data pipelines and building ETL, ELT, and data integration solutions using Snowflake and complex SQL queries
• Proven experience utilizing programming languages such as Python, Scala, Java, or similar technologies
• Proven experience developing CI/CD pipelines using Git, GitHub Actions, or similar version control and automation technologies
• Proven experience working with relational and non-relational database technologies
• Demonstrated solid communication skills

Other useful skills & experience include:

• Demonstrated knowledge of the U.S. health insurance industry, particularly in claims adjudication and Payment Integrity
• Proven solid experience in Data Engineering
• Proven experience orchestrating data workflows using Airflow, Docker, and Kubernetes for data ingestion, processing, and transformation
• Demonstrated familiarity with Azure services, including Blob Storage, Functions, Azure Data Factory, Service Principals, Containers, and Key Vault
• Proven experience working within Agile and Scrum delivery environments and collaborating with high-performing teams

Please note you must currently be eligible to work and remain indefinitely without any restrictions in the country to which you are making an application. Proof will be required to support your application.

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.

Diversity creates a healthier atmosphere: Optum is an Equal Employment Opportunity employer and all qualified applicants will receive consideration for employment without regard to gender, civil status, family status, sexual orientation, disability, religion, age, race, and membership of the Traveller community, or any other characteristic protected by law. Optum is a drug-free workplace.

#BBMEMEA