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