Advisory Consultant -R/ Python+Healthcare Analytics

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 the Advisory Consultant you will join an elite team committed to changing health care through outstanding service and valuable products. You’ll use innovative tools including the largest database of health care information in the world.  You will help develop complex actuarial products and support actuarial teams in day-to-day reporting and analyses. If you want to be challenged by working on complex and diverse analytical projects, this is the opportunity for you.

Primary Responsibilities:

• Develop complex algorithms and convert complex mathematical calculations to code
• Understand the capabilities of the products and associated reporting tools and work towards enhancing new and existing functionalities
• Collaborate and communicate effectively with broader product teams
• Participate in and support release processes for team products
• Participate in client relationships and communications
• Assist with project scheduling and coordination of tasks
• Execute creative problem solving and critical thinking on the job
• Maintain a high degree of accuracy along with attention to detail, excellent oral and written communication skills, solid interpersonal skills, and the ability to always meet deadlines
• Take accountability for work within a fast paced, exciting environment and learn from challenges as they arise
• 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:

• Bachelor’s degree (STEM field) or equivalent experience
• Intermediate/Expert level of experience with coding (at least one of R, Python) and SQL
• Experience in developing complex algorithms and converting complex mathematical calculations to code
• Experience of developing applications/ dashboards with Python Flask/Dash/Streamlit or R-shiny
• Good understanding of using data tables in R or pandas data frames in Python and perform transformations, joins, aggregations and summarize results
• Good understanding of OOPs concepts, multiprocessing and modular programming
• Good understanding of machine learning models and developing stages of ML pipelines
• Demonstrated ability to communicate effectively, including written and verbal forms of communication
• Demonstrated ability to learn quickly and use computer software tools effectively
• Demonstrated ability to work proactively and collaboratively on all assignments with various teams both internal and external to Optum
• Proven analytical, organizational, and problem-solving skills
• Proven to be eager to learn about and work on a variety of different projects/assignments
• Proven flexibility to handle changing priorities/requirements/deadlines

Preferred Qualifications:

• Business analyst and/or customer facing experience
• Experience working in a consultancy, actuarial or healthcare field
• Experience with Github repositories and actions
• Experience with automating tasks
• Expertise working with formulas, calculations, charts, graphs in MS Excel

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.