Advisory Consultant- Python/PySpark,DWH, Metrics

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 healtach 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.

This position will report to the head of the Actuarial Date Warehouse Business Intelligence.

The ADW is a cloud data and analytics environment where client data are ingested, conformed, cleansed, and then enriched to support advanced actuarial and data science analytics. This BI environment includes Databricks, DBT, MS Fabrics and Power BI.

This position will design, develop, implement, test, deploy, monitor, and maintain the delivery of data enrichments and reporting models to support actuarial reporting and analytics.

Primary Responsibilities:

• Work with BI team to build and deploy healthcare data enrichments
• Design high performance reporting models using DBT that will be deployed in Power BI
• Design and develop Azure Databricks jobs using Python and Spark
• Develop and maintain CI/CD processes using Jenkins, GitHub, Maven
• Support monthly and quarterly production activities
• Maintain high quality documentation of data definitions, transformations, and processes to ensure data governance and security
• Identifies solutions to non-standard requests and problems
• Support and maintain the self-service BI warehouse
• Work with business owners to add new enrichments and to design and implement new reporting models
• Comply with the terms and conditions of the employment contract, company policies and procedures, and any and all directives (such as, but not limited to, transfer and/or re-assignment to different work locations, change in teams and/or work shifts, policies in regards to flexibility of work benefits and/or work environment, alternative work arrangements, and other decisions that may arise due to the changing business environment). The Company may adopt, vary or rescind these policies and directives in its absolute discretion and without any limitation (implied or otherwise) on its ability to do so

Required Qualifications:

• Undergraduate degree or equivalent experience
• 7+ years of overall experience in Data and Analytics engineering
• 5+ years of experience writing code in developing Big Data solutions using Spark and Python
• 5+ years of experience working with Azure, Databricks, and DBT
• 4+ years of experience working with medical and RX claims, eligibility tables and provider data
• Experience working with MS Fabric and Power BI
• Solid experience with CICD tools such as Jenkins, GitHub, Maven etc
• Experience designing and deploying reporting data models
• In-depth understanding of Azure architecture and ability to come up with efficient design and solutions
• Proven highly proficient in Python and SQL
• Proven excellent communication skills

Preferred Qualifications:

• Undergraduate degree in STEM field
• Snowflake experience
• Power BI development experience
• Experience working as an actuary or with actuaries
• Knowledge of health care concepts - benefits, pricing, underwriting, stop loss reinsurance, reserves etc.

#GEN

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.