Actuarial Intern

40000 Sanford Health Plan; Wisconsin; Hybrid; USD 47,279,000 - 52,404,000; Full time

Job summary

Sanford Health seeks an Actuarial Intern to support health insurance analyses, pricing, reserving, and forecasting under guidance of senior actuaries.

You'll compile data, update models, prepare exhibits, and present insights to partners across Finance, Underwriting and Product. Strong Excel skills and exposure to SQL/SAS/Python are preferred; candidate currently pursuing actuarial studies and credentials.

Qualifications

• Experience using Microsoft Excel for data analysis required.
• Exposure to data, programming, visualization, or analytical tools such as SQL, SAS, Python, VBA, Power BI, or similar tools is preferred.
• Interest in the actuarial profession required.
• Currently pursuing a bachelor’s or master’s degree in actuarial science, mathematics, statistics, data science, economics, finance, computer science, or another quantitative field required.
• Currently pursuing an actuarial credential through the Society of Actuaries.
• Completion of at least one actuarial examination is preferred but not required.

Responsibilities

• Assist in actuarial analyses involving pricing, reserving, forecasting, and data validation.
• Compile, reconcile, validate, and analyze health plan data and reports.
• Develop and maintain actuarial models, dashboards, and rating tools under supervision.
• Prepare clear exhibits and presentations communicating findings to technical and nontechnical audiences.
• Collaborate with Finance, Underwriting, Product, Sales, Network, and Operations to answer business questions.

Skills

Analytical Thinking

Accuracy & Detail

Accountability

Collaboration

Effective Communications

Teamwork

Education

Actuarial Science Degree

Actuarial Credential Pursuit

Actuarial Exams (completed)

Tools

SQL

SAS

Python

VBA

Power BI

Job description

Sanford Health, the largest rural health system in the United States, is dedicated to transforming the health care experience and providing access to world-class health care in America’s heartland.

Work Shift: 8 Hours - Day Shifts (United States of America) Scheduled Weekly Hours: 0 Compensation: Starting Rate: $16.50 Union Position: No Department Details

Summary Contribute to Sanford operations and processes while obtaining first hand experiences that align with the mission, vision, and values of the organization. Job Description Work collaboratively with organization leadership, enhancing knowledge and skills and improving the delivery of quality healthcare. Assist in the completion of projects and administrative duties while developing skills related to the assigned function and/or location. Attend training and development opportunities, learning about various processes and functions within the organization.

Qualifications

The Actuarial Intern supports health insurance analyses involving medical claims, premium, enrollment, pricing, reserving, forecasting, and financial performance. Working alongside experienced actuarial professionals, the intern compiles and validates data, updates analytical models, investigates emerging results, and communicates findings to actuarial and business partners. The internship provides practical exposure to actuarial methods, health plan operations, cross-functional collaboration, and the use of analysis to support business decisions.

• Support actuarial analyses involving pricing, reserving, forecasting, medical cost trends, product performance, provider reimbursement, or other assigned business needs.
• Compile, reconcile, validate, and analyze claims, premium, enrollment, benefit, provider, and other health plan data. Evaluate data sources for reasonableness, completeness, reliability, and fitness for the analysis being performed.
• Assist with maintaining and updating actuarial models, reports, dashboards, rating tools, and other analytical processes. Apply established actuarial methods and document assumptions, calculations, limitations, and results.
• Investigate emerging experience and unexpected results. Identify relevant trends, patterns, and data issues and work with actuarial staff to evaluate their potential business impact.
• Prepare clear exhibits, charts, summaries, and presentations that communicate analytical findings to technical and nontechnical audiences.
• Collaborate with actuarial colleagues and business partners in areas such as Finance, Underwriting, Product, Sales, Network, and Operations to understand business questions and support informed decisions.
• Gain exposure to regulatory and compliance activities that may include rate filings, bids, audits, or other documentation required for health plan products and programs.
• Complete one or more defined actuarial projects and present methods, findings, and recommendations to actuarial leaders and business partners.
• Perform other duties and actuarial analyses as assigned, within the scope of an internship role.
• Obtain, compile, and validate data used in health actuarial analyses.
• Apply established formulas, methods, and analytical tools under the guidance of actuarial staff.
• Evaluate information for limitations in reliability, completeness, or usability.
• Identify relationships, trends, and factors that may affect analytical results.
• Develop accurate reports, exhibits, graphs, charts, tables, and presentations.
• Communicate methods, assumptions, results, and limitations clearly in writing and verbally.
• Maintain appropriate documentation and protect confidential business, member, and financial information.
• Use standard office, data, query, programming, and analytical applications necessary to perform assigned work.
• Collaborate effectively, ask questions, incorporate feedback, and complete assignments within established timelines.

Experience using Microsoft Excel for data analysis required. Coursework, academic projects, employment, or internship experience involving data compilation, validation, analysis, modeling, reporting, or presentation is preferred.

Exposure to one or more data, programming, visualization, or analytical tools such as SQL, SAS, Python, VBA, Power BI, or similar tools is preferred.

Demonstrated analytical thinking, attention to detail, problem solving, collaboration, intellectual curiosity, and written and verbal communication skills are preferred.

Interest in the actuarial profession required.

The Actuarial intern schedule may vary dependent on time of year. The ideal candidate will be able to work full time during summer and breaks and part time during the school year.

Currently pursuing a bachelor’s or master’s degree in actuarial science, mathematics, statistics, data science, economics, finance, computer science, or another quantitative field required.

Currently pursuing an actuarial credential through the Society of Actuaries.

Completion of at least one actuarial examination is preferred but not required.

CORE COMPENTENCIES:

• Accountability Understanding of the importance of being accountable and ability to focus on those activities that have the greatest impact on meeting work commitments.
• Accuracy and Attention to Detail Understanding of the necessity and value of accuracy and attention to detail; ability to process information with high levels of accuracy.
• Analytical Thinking Knowledge of techniques and tools that promote effective analysis and the ability to determine the root cause of organizational problems and create alternative solutions that resolve the problems in the best interest of the business.
• Collaborating Knowledge of collaborative techniques and ability to promote a culture of information sharing and working together to solve business problems and meet business goals.
• Effective Communications Understanding of effective communication concepts, tools and techniques; ability to effectively transmit, receive, and accurately interpret ideas, information, and needs through the application of appropriate communication behaviors.
• Teamwork Knowledge of the necessity and value of teamwork; experience with and ability to participate effectively as part of a team.

Sanford is an EEO/AA Employer M/F/Disability/Vet.

If you are an individual with a disability and would like to request an accommodation for help with your online application, please call 1-877-949-5678 or send an email to [e-mail].

The Sanford organization owns and manages multiple distinct brands, including Sanford Health, Marshfield Clinic, and Good Samaritan, as well as Lewis Drug, Sanford Health Equip, Solutions by Sanford, Great Shots, and Blue Rock Bar & Grill.

Sanford Health, the largest rural health system in the United States, is dedicated to transforming the health care experience and providing access to world-class health care in America’s heartland.

Headquartered in Sioux Falls, South Dakota, the organization has 53,000 employees and serves over 2 million patients and nearly 425,000 health plan members across the upper Midwest including South Dakota, North Dakota, Minnesota, Wyoming, Iowa, Wisconsin and the Upper Peninsula of Michigan.

The integrated nonprofit health system includes a network of 56 hospitals, 288 clinic locations, 147 senior care communities, 4,000 physicians and advanced practice providers and nearly 1,500 active clinical trials and studies.

The organization’s transformational virtual care initiative brings patients closer to care with access to 78 specialties.

Learn more about Sanford Health’s commitment to shaping the future of rural health care across the lifespan at sanfordhealth.org or Sanford Health News.

Good Samaritan, one of the nation’s largest nonprofit providers of senior care and services, is committed to transforming the aging experience through innovation, compassion and personalized care.

As part of Sanford Health, an integrated nonprofit health system headquartered in Sioux Falls, South Dakota, Good Samaritan serves 10,000 seniors and offers access to a full continuum of care, including 94 rehabilitation and skilled nursing centers, 56 assisted living and memory care facilities, 44 independent living locations and 37 home health and hospice agencies.

The senior care provider delivers services across the upper Midwest, with 70% of residents living in rural communities.

Learn more about Good Samaritan’s mission and commitment to delivering high quality senior care in rural America at good-sam.com.