Senior Data Engineer

Optum; Eden Prairie (MN); On-site; USD 91,700 - 163,700; Full time

Benefits offered by this job

Comprehensive benefits package

Equity stock purchase program

401k contribution

Job summary

UnitedHealth Group, Eden Prairie, seeks a Senior Data Engineer to build and optimize data pipelines across Snowflake and Azure, focusing on data quality, masking, and scalable architectures. You'll collaborate with data teams to deliver reliable data foundations for analysis and reporting, employing Airflow, SQL, and modern DevOps practices.

The role requires hands-on experience with Snowflake, Python/Scala/Java, and CI/CD pipelines, along with strong communication and Agile collaboration.

Qualifications

• Bachelor's degree in Computer Science or a related field
• Hands-on experience developing data pipelines in Snowflake and writing complex SQL queries
• Proven hands-on experience as a Data Engineer
• Experience with CI/CD pipelines using Git and Git Actions
• Experience building ETL/ELT data pipelines
• Experience with open-source platforms and languages such as Scala, Python, Java, and Linux
• Experience with relational and non-relational databases
• Experience with Agile/Scrum projects with high-performing teams
• Knowledge of data modeling techniques including star schema, dimensional models, and Data Vault
• Knowledge of data warehousing principles, architecture, and implementation
• Solid knowledge of Python
• In-depth knowledge of Snowflake architecture, features, and best practices
• Good understanding of access control, data masking, and row access policies
• Exposure to DevOps methodology
• Proficiency in SQL including window functions and advanced features

Responsibilities

• Integrate data from multiple on-premises and cloud sources and systems to create a unified data foundation
• Develop data transformation routines to clean, normalize, and aggregate data
• Implement data de-identification and data masking per standards
• Monitor data pipelines and data systems to detect and resolve issues
• Develop monitoring tools and automate error-handling for data integrity
• Use data quality tools like Great Expectations or Soda
• Create and maintain data pipelines using Airflow and Snowflake
• Develop SQL stored procedures for complex transformations
• Understand data requirements and design optimal pipelines for business use cases
• Create logical and physical data models to maintain data integrity
• Support CI/CD pipeline creation using Git and Git Actions
• Tune and optimize data processes

Skills

SQL

Data analysis

Communication

Problem solving

Agile/Scrum

Education

Bachelor's degree in Computer Science or related field

Bachelor's or higher in Database Management / IT / CS

Tools

Snowflake

Azure

Airflow

Git Actions

Databricks

Python

SQL stored procedures

Linux

Job description

At UnitedHealthcare, we're simplifying the health care experience, creating healthier communities and removing barriers to quality care. The work you do here impacts the lives of millions of people for the better. Come build the health care system of tomorrow, making it more responsive, affordable and optimized. Ready to make a difference? Join us to start Caring. Connecting. Growing together

As a Senior Data Engineer, you will be responsible for developing complex data sources and pipelines within our data platform, including Snowflake, Azure, Airflow, and related automation tools.

You will work closely with Data, Architecture, Business Analysts, and Data Stewards to align requirements, specifications, and constraints across solutions. This role also helps identify gaps in resources, technology, or capabilities and partners with the data engineering team to implement effective solutions with a solid focus on customer usability.

Primary Responsibilities:

• Integrate data from multiple on-premises and cloud sources and systems, handling 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, including handling complex data structures and missing or inconsistent data
• Implement data de-identification and data masking in line with company standards
• Monitor data pipelines and data systems to detect and resolve issues promptly
• Develop monitoring tools and automate error-handling mechanisms to ensure data integrity and system reliability
• Use data quality tools such as Great Expectations or Soda to support the accuracy, reliability, and integrity of data throughout its lifecycle
• Create and maintain data pipelines using Airflow and Snowflake as primary tools
• Develop SQL stored procedures to perform complex transformations
• Understand data requirements and design optimal pipelines to fulfill business use cases
• Create logical and physical data models to maintain data integrity
• Support CI/CD pipeline creation and automation using Git and Git Actions
• Tune and optimize data processes

You’ll 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 provide development for other roles you may be interested in.

Required Qualifications:

• Bachelor's degree in Computer Science or a related field
• Hands-on experience developing data pipelines in Snowflake and writing complex SQL queries
• Proven hands-on experience as a Data Engineer
• Experience with CI/CD pipelines using Git and Git Actions
• Experience building ETL/ELT data pipelines
• Experience with related open-source platforms and languages such as Scala, Python, Java, and Linux
• Experience with relational and non-relational databases
• Experience working on Agile/Scrum projects with high-performing teams
• Knowledge of data modeling techniques, including star schema, dimensional models, and Data Vault
• Knowledge of data warehousing principles, architecture, and implementation
• Knowledge of mesh compliance is desirable but not essential
• Solid knowledge of Python
• In-depth knowledge of Snowflake architecture, features, and best practices
• Good understanding of access control, data masking, and row access policies
• Exposure to DevOps methodology
• Proficiency in SQL, including window functions and advanced features
• Proven solid written and verbal communication skills
• Proven solid analytical and problem-solving skills applied to large data sets

Preferred Qualifications:

• Bachelor's degree or higher in Database Management, Information Technology, Computer Science, or a related field
• Experience in Data Engineering
• Experience orchestrating data tasks in Airflow to run on Kubernetes for data ingestion, processing, and cleaning
• Experience with Databricks
• Familiarity with Azure services such as Blob Storage, Functions, Azure Data Factory, Service Principal, Containers, and Key Vault
• Expertise in designing and implementing data pipelines to process high volumes of data
• Motivated self-starter who excels at managing tasks independently and takes ownership
• Proven ability to create Docker images for applications to run on Kubernetes

Pay is based on several factors including but not limited to local labor markets, education, work experience, certifications, etc. In addition to your salary, we offer benefits such as, a comprehensive benefits package, incentive and recognition programs, equity stock purchase and 401k contribution (all benefits are subject to eligibility requirements). No matter where or when you begin a career with us, you’ll find a far-reaching choice of benefits and incentives. The salary for this role will range from $91,700 to$163,700 annually based on full-time employment. We comply with all minimum wage laws as applicable.

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.

UnitedHealth Group is an Equal Employment Opportunity employer under applicable law and qualified applicants will receive consideration for employment without regard to race, national origin, religion, age, color, sex, sexual orientation, gender identity, disability, or protected veteran status, or any other characteristic protected by local, state, or federal laws, rules, or regulations.

UnitedHealth Group is a drug-free workplace. Candidates are required to pass a drug test before beginning employment.

Helping all candidates find great careers is our goal. The information you provide here is secure and confidential.