Sr Data Engineer - Remote

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 equitable. Ready to make a difference? Join us and start doing your life's best work.(sm)

UHC Analytics and Engagement Solutions (AES), is a team within UnitedHealthcare Consumer Experience that drives business results through the management and use of consumer engagement technology and data-driven insights. Our vision is to use data and insights to design, orchestrate and maximize experiences that matter to consumers, clients, and health care professionals, resulting in enterprise strategic growth as well as a brand that people love. To support this vision, one of our goals is to evolve our analytic and data environments to improve speed of decisioning and to support higher velocity use cases.

We are looking for someone who is passionate about complex data structures and problem-solving skills and someone who wants to come along for the ride and grow with us to support building a new analytics warehouse in cloud and implement efficient and robust ETL/ELT processes. You will build data pipelines to ingest the data from heterogeneous sources into our system Hadoop/Azure/Snowflake. You should have excellent business and communication skills and be able to work with business owners to understand their data requirements and help them make data-related decisions using your data knowledge and experience.

The job might also require you to learn new tools and technologies fast, and you should have in-depth database concepts, ETL concepts, solid data querying, and debugging skills. You will help to build and support efficient and stable data pipelines which can be easily maintained in the future using Azure Data Factory and Snowflake. You will also be responsible of automating the data pipeline using cloud-based tools, testing, and clearly documenting the implementations.

You’ll enjoy the flexibility to work remotely * from anywhere within the U.S. as you take on some tough challenges.

Primary Responsibilities:

• Engage in all phases of the development life cycle to lead the design, development and implementation of data interfaces supporting enterprise operations, reporting and analytics
• Interact with technical and non-technical customers to understand requirements and implement relevant data solutions
• Proactively and continuously identify, evaluate and recommend integration and delivery process improvements
• Assist in the overall architecture of the analytics warehouse Design, and proactively provide inputs in designing, implementing, and automating the data flows
• Developing ETL pipelines and data flows in and out of the data warehouse using a combination of Azure Data Factory and Snowflake toolsets
• Developing idempotent ETL process design so that interrupted, incomplete, or failed processes can be rerun without errors using ADF dataflows and Pipelines
• Ability to work in Snowflake Virtual Warehouses as needed in Snowflake and automate data pipelines using Snowpipe for tedious ETL problems
• Capturing changes in data dimensions and maintaining versions of them using Stream sets in snowflake and scheduling them using Tasks
• Optimize every step of the data movement not only limited to source and during travel but also when it's at rest in the database for accelerated responses
• Must have the ability to build a highly efficient orchestrator that can schedule jobs, execute workflows, perform Data quality checks, and coordinate dependencies among tasks
• Testing of ETL system code, data design, and pipelines and data flows. Root cause analysis on all processes and resolving production issues are also a part of the process and routine tests on databases and data flow and pipeline testing
• Documenting the implementations, and test cases as well as for building deployment documents needed for CI/CD

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:

• 3+ years of experience in data warehousing concepts, ETL concepts, and working with ETL/Data quality tools on any ETL platform
• 3+ years of experience in writing complex SQL/Python queries, and performance tuning
• 1+ years of experience with Microsoft Azure cloud services and data warehouse environment
• 1+ years of experience with building, deploying, and troubleshooting data extraction and loading pipelines (ETL) using Azure Data Factory (ADF)
• 1+ years of experience with Adobe CJA (consumer journey analytics)
• 1+ years analyzing and executing data profiles

Preferred Qualifications:

• Azure or Snowflake Certification in database and data engineer roles
• 1+ years of experience developing a data solution on Snowflake Data Warehouse using snowflake continuous data pipelines with Snowpipe, Streams and Tasks
• 1+ years of experience working with databricks
• 1+ years of experience working with healthcare data
• Experience is working with offshore teams (India etc.)

Careers with UnitedHealthcare. Work with a Fortune 5 organization that’s serving millions of people as we transform health care with bold ideas. Bring your energy for driving change for the better. Help us improve health access and outcomes for everyone, as we work to advance health equity, connecting people with the care they need to feel their best. As an industry leader, our commitment to improving lives is second to none.

California, Colorado, Connecticut, Nevada, New York, Rhode Island, or Washington Residents Only: The salary range for California, Colorado, Connecticut, Nevada, New York, Rhode Island or Washington residents is $85,000 to $167,300. Pay is based on several factors including but not limited to education, work experience, certifications, etc. In addition to your salary, UnitedHealth Group offers 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 UnitedHealth Group, you’ll find a far-reaching choice of benefits and incentives.

*All employees working remotely will be required to adhere to UnitedHealth Group’s Telecommuter Policy

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: UnitedHealth Group is an Equal Employment Opportunity/Affirmative Action employer and all qualified applicants will receive consideration for employment without regard to race, color, religion, sex, age, national origin, protected veteran status, disability status, sexual orientation, gender identity or expression, marital status, genetic information, or any other characteristic protected by law.

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