Search by job, company or skills

O

Actuarial Modelling with VBA Macros

new job description bg glownew job description bg glownew job description bg svg
  • Posted 20 hours ago
  • Be among the first 10 applicants
Early Applicant

Job Description

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:

  • Maintain and enhance actuarial forecast models used for healthcare financial forecasting, ensuring accuracy and alignment with business expectations
  • Analyze and interpret key drivers of healthcare trends, translating them into reliable projections of expected revenue and costs
  • Support cross-business actuarial analytics across Commercial, Medicare, and Medicaid lines of business by developing consistent and robust modeling approaches
  • Conduct comprehensive data extractions and in-depth analyses, leveraging technical skills in VBA, Excel, SAS, and SQL
  • Identify and explore new analytical opportunities, collaborating with key stakeholders to enhance modeling capabilities and analytical methodologies
  • Develop high-quality documentation and deliverables, including written communications, persuasive presentations, and impactful analytical summaries tailored to stakeholder needs
  • 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 in Mathematics, Statistics, Science, Engineering, or a related technical discipline from an accredited college/university
  • 7+ years of relevant work experience in the Financial or Insurance domain
  • 3+ years of experience working with healthcare claims and/or pharmacy claims, including understanding of costs, expected claims, diagnosis codes, procedure codes, and pharmacy terminology
  • Solid expertise in MS Excel and VBA
  • Proficiency in one or more analytical or modeling tools such as R, SAS, SQL, Python, Power BI
  • Proven ability to communicate complex information clearly and concisely to stakeholders at all levels
  • Proven ability to manage multiple responsibilities simultaneously, effectively progressing several projects or workstreams in parallel


Preferred Qualification:

  • On the actuarial exam track, having passed 5 or more actuarial exams from IFoA, IAI, or SOA

More Info

About Company

Optum, Inc. is an American pharmacy benefit manager and health care provider. It is a subsidiary of UnitedHealth Group since 2011. UHG formed Optum by merging its existing pharmacy and care delivery services into the single Optum brand, comprising three main businesses: OptumHealth, OptumInsight and OptumRx.In 2017, Optum accounted for 44 percent of UnitedHealth Group's profits and as of 2019, Optum's revenues have surpassed $100 billion.Also in early 2019, Optum gained significant media attention regarding a trade secrets lawsuit that the company filed against former executive David William Smith, after Smith left Optum to join Haven, the joint healthcare venture of Amazon, JPMorgan Chase, and Berkshire Hathaway.

Job ID: 143971903