Actuarial Analyst

Ultipro; Madison, Northern (WI, KY); Hybrid; USD 63,000 - 94,000; Full time

Benefits offered by this job

Medical

Dental

Vision

PTO

Holidays

Volunteer time off

401K

Caregiver services

Job summary

Medica in Madison, WI seeks an Actuarial Analyst to support forecasting, pricing, and model development in an onsite setting. The role emphasizes data quality, collaboration, and learning through hands-on projects.

You will perform analyses, prepare inputs, and document methodologies, while advancing actuarial knowledge and contributing to team goals. SOA exam progress and Excel proficiency are essential.

Qualifications

• Bachelor’s degree in Actuarial Science, Mathematics, Statistics, Economics, Finance, or related field.
• Successful completion of 1 SOA exam.
• Strong analytical, problem-solving, and communication skills.
• Proficiency with Microsoft Excel; experience with SQL, SAS, R, or Python is a plus.

Responsibilities

• Conduct actuarial analyses and forecasting using established tools.
• Assist with pricing analyses and monitor financial outcomes.
• Build and maintain actuarial models and tools.
• Document methodologies and maintain organized workpapers.

Skills

Analytical skills

Problem-solving

Critical thinking

Excel

SQL

SAS

R

Python

Communication

Teamwork

Independence

Education

Bachelor's degree in Actuarial Science/Math/Statistics/Finance

Tools

SQL

SAS

R

Python

Job description

Key Accountabilities

• Conduct Actuarial Analyses & Forecasting
  • Perform basic actuarial analyses using established tools, templates, and assumptions
  • Compile and review historical experience data for completeness and consistency
  • Support actuarial financial evaluations by preparing inputs and preliminary results
  • Document methodologies and work steps to ensure transparency and reviewability
• Assist with pricing analyses by preparing data and performing calculations
• Produce standard monitoring reports to track experience and financial outcomes
• Compare actual results to expectations and flag variances for further review
• Support rate development activities under supervision of senior staff
• Build & Maintain Actuarial Models & Tools
  • Update and run existing actuarial models following defined instructions
  • Validate data inputs and outputs to ensure accuracy and internal consistency
  • Perform routine model maintenance and quality checks
  • Document model processes and assumptions in accordance with actuarial standards
• Assist with probability analyses and scenario testing using predefined parameters
• Compile results that illustrate potential cost and utilization impacts
• Prepare charts and summaries that explain analytical findings
• Incorporate feedback to refine assumptions and outputs
• Respond to basic questions about data and analyses
• Partner with team members to complete projects and meet deadlines
• Maintain organized workpapers and version control
• Build actuarial knowledge through feedback and on-the-job learning

Required Qualifications

• Bachelor’s degree in Actuarial Science, Mathematics, Statistics, Economics, Finance, or related field
• Successful completion of 1 Society of Actuaries (SOA) exams

Preferred Qualifications

• Strong analytical, problem-solving, and critical-thinking skills
• Proficiency with Microsoft Excel; experience with SQL, SAS, R, or Python is a plus
• Excellent written and verbal communication skills
• Ability to work independently and as part of a collaborative team

This position is an Office role, which requires an employee to work onsite, on average, 3 days per week. We are open to candidates located near one of the following office locations: Madison, WI.

The full salary grade for this position is $62,700-$107,500. While the full salary grade is provided, the typical hiring salary range for this role is expected to be between $62,700 - $94,080 . Annual salary range placement will depend on a variety of factors including, but not limited to, education, work experience, applicable certifications and/or licensure, the position’s scope and responsibility, internal pay equity and external market salary data.

In addition to compensation, Medica offers a generous total rewards package that includes:

• competitive medical
• dental
• vision
• PTO
• Holidays
• paid volunteer time off
• 401K contributions
• caregiver services
• many other benefits to support our employees.

The compensation and benefits information is provided as of the date of this posting. Medica’s compensation and benefits are subject to change at any time, with or without notice, subject to applicable law.

Eligibility to work in the US: Medica does not offer work visa sponsorship for this role. All candidates must be legally authorized to work in the United States at the time of application. Employment is contingent on verification of identity and eligibility to work in the United States.

We are an Equal Opportunity employer, where all qualified candidates receive consideration for employment indiscriminate of race, religion, ethnicity, national origin, citizenship, gender, gender identity, sexual orientation, age, veteran status, disability, genetic information, or any other protected characteristic.

Equal Opportunity Employer/Protected Veterans/Individuals with Disabilities
This employer is required to notify all applicants of their rights pursuant to federal employment laws.For further information, please review the Know Your Rights notice from the Department of Labor.