Actuarial Analyst

UnitedHealth Group•Eden Prairie, MN

About The Position

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 inclusion, talented peers, comprehensive benefits and career development opportunities. Come make an impact on the communities we serve as you help us advance health optimization on a global scale. Join us to start Caring. Connecting. Growing together. Primary Responsibilities: Research, analyze and interpret quantitative data results by applying knowledge of data analysis, critical-thinking and healthcare experience/expertise Perform data quality checks and useability analyses Develop actuarial models for evaluating and projecting healthcare cost trends; perform data mining and analysis to identify key trends and drivers Assist in preparation of medical expense and revenue forecasts Develop SQL queries, building Excel based actuarial models and apply varying actuarial techniques to solve specific business needs Maintain and expand current statistical models used to measure business results Maintain actuarial reserve and revenue models; assist in development of assumptions and preparation of monthly estimates Assist in completion of annual financial client reconciliation processes Structure analytical results in a succinct and organized manner Establish trusting professional relationships with actuarial team and internal business leaders Maintain alignment of expectations and priorities 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.

Requirements

Actuarial exam track, having passed 1 or more Actuarial exams
Experience working in a corporate environment including experience collecting, analyzing and summarizing qualitative/quantitative data
Expertise working with formulas, calculations, charts, graphs in MS Excel

Nice To Haves

Work or intern experience working in health care industry, Actuarial industry or another associated field
Experience building Excel based actuarial models
Experience with coding languages such as SQL (Structured Query Language), SAS (Statistical Analysis System) and/or VBA (Visual Basic for Applications)
Experience in data mining and data transformation/manipulation
Experience with predictive modeling and statistical analysis
Demonstrated advanced analytical skills with ability to analyze and interpret data through complex analysis
Proven solid communication skills (verbal and written)

Responsibilities

Research, analyze and interpret quantitative data results by applying knowledge of data analysis, critical-thinking and healthcare experience/expertise
Perform data quality checks and useability analyses
Develop actuarial models for evaluating and projecting healthcare cost trends; perform data mining and analysis to identify key trends and drivers
Assist in preparation of medical expense and revenue forecasts
Develop SQL queries, building Excel based actuarial models and apply varying actuarial techniques to solve specific business needs
Maintain and expand current statistical models used to measure business results
Maintain actuarial reserve and revenue models; assist in development of assumptions and preparation of monthly estimates
Assist in completion of annual financial client reconciliation processes
Structure analytical results in a succinct and organized manner
Establish trusting professional relationships with actuarial team and internal business leaders
Maintain alignment of expectations and priorities