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.

As a Healthcare ETL Analyst, you will play a crucial role in transforming raw data into actionable insights that drive business decisions and strategies. Your responsibilities will include data collection, analysis, interpretation, and transformation, helping stakeholders understand complex datasets to make informed choices and optimize performance

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

Primary Responsibilities:

The Healthcare ETL Analyst will execute data pipelines, analyze transformed data to validate its completeness and gather insight to impact business decisions. They will be responsible for timely delivery of data to downstream partners, managing multiple tickets simultaneously and addressing roadblocks associated with ETL process. Additionally, the analyst will handle ad hoc analysis request-related data surrounding Medical Record retrieval to assist in determining the location of medical charts.

• Collect, clean, and preprocess data from various sources to ensure accuracy and consistency

• Identify and address data quality issues, outliers, and missing values

• Complete Data Ingestion and QA process in accordance with Service Level Agreements

• Manage Multiple tickets for data ingestion simultaneously

• Perform exploratory data analysis to uncover trends, patterns, and relationships within datasets

• Oversee ingestion pipelines and troubleshoots errors related to data. Resolve errors using approved data cleaning techniques

• Translate complex data analysis into clear and actionable insights for stakeholders

• Collaborate with cross-functional teams to identify opportunities for process optimization and strategic decision-making

• Develops and maintains solid relationships with all internal and external stakeholders

• Document analysis methodologies, assumptions, and findings for future reference and replication

• Requires an individual to maintain the ability to work in an environment with PHI / PII data

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:

• 2+ years of experience managing healthcare data ingestion platforms

• 2+ years working experience writing intermediate to advanced SQL (joining many tables, SQL functions, CTE's)

• 1+ years of experience working with tools like Snowflake, Jupiter, or Airflow

• Experience working with Python (Ability to read and understand Python scripts and ability to make adjustments to scripts)

• Knowledge of Data Analysis and Data Quality best practices

• Proficient in Excel (v-look ups, pivot tables)

• Proven excellent verbal and written communication skills, including ability to effectively communicate with internal and external customers

• Proven ability and willingness to work occasional weekend and/or evening work

Preferred Qualifications :

• Understanding of Data Pipelines, database structures and ETL practices

• Knowledge of Healthcare data including member, claims, and provider data

• Knowledge of industry standards and practices related to Medical Record Retrieval

• Knowledge of Data Quality best practices

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

The salary range for this role is $71,600 to $140,600 annually based on full-time employment. Pay is based on several factors including but not limited to local labor markets, education, work experience, certifications, etc. UnitedHealth Group complies with all minimum wage laws as applicable. 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.

Application Deadline: This will be posted for a minimum of 2 business days or until a sufficient candidate pool has been collected. Job posting may come down early due to volume of applicants.

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.