Advisory Services Consultant – Power BI, Big Data and Azure

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 design, develop, implement, test, deploy, monitor, and maintain the delivery of high-performance Power BI data models and reporting environments. This position would need to be responsible for designing the data models, building the transformations in DBT, automating the data updating workflows, creating the measures, developing complex reports and assuring high performance.

Primary Responsibilities:

• Designing and productionizing BI data models using DBT
• Working with Azure Databricks notebooks using Python & Spark
• Developing reporting capabilities to meet business requirements
• Designing KPIs, developing dashboard visualizations and complex reports, which involves custom controls and custom expressions using bars, lines and pies, maps, scatter plots
• Developing advanced measures and features within Power BI
• Optimizing and tuning performance of data models to meet business requirements
• Maintaining model documentation and providing business users with training and education
• Managing entire lifecycle of Power BI report development
• 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 experience in business intelligence, database design, data modeling and data warehousing projects
• 5+ years of experience developing enterprise solutions in Power BI
• 4+ years of experience working with Azure, Databricks, DBT, Python + Spark, SQL
• Experience analyzing and building models using health care claims data
• Hands-on experience in utilizing and implementing DAX functions and measures including aggregation, counting, logical and date functions for efficient data visualization
• Experience using features of Power BI such as Q&A, Key Influencers, R and Python, etc
• Experience managing the cloud environment and moving data from PBIX to development and to production
• Experience building direct query models in Power BI
• Significant experience building high quality dashboards
• Experience with CICD tools such as Jenkins, GitHub, Maven etc.
• Deep knowledge on Power Query Parameters, Query Lists, Tables, Records and having expertise in cleansing and transforming data with Power Query Editor
• Proven highly proficient in Python and SQL with significant experience working on Azure services
• Proven excellent communication skills

Preferred Qualifications:

• Undergraduate degree in STEM field
• Snowflake experience
• Databricks experience
• Experience using dbt to build data models
• Prior work as an actuary or with actuaries
• Knowledge of health care concepts – benefits, pricing, underwriting, stop loss reinsurance, reserves etc.

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.