Government Data Analyst
Marsh McLennan
SpringSQL
Actuarial Summer Intern, Health Consulting
Marsh McLennan
full-time
Posted on:
Origin: • 🇺🇸 United States • California, Colorado
Visit company websiteJob Level
Entry Level
Tech Stack
PythonSpringSQL
About the role
- Perform responsibilities comparable to full-time analysts with support from experienced colleagues
- Complete comprehensive analysis of health care data using spreadsheet and database management software
- Assist in the development of client communications, proposals, reports, spreadsheets, and presentations
- Perform basic cost projections using client cost and enrollment data with Mercer’s valuation model
- Price medical & prescription drug plan designs using proprietary Mercer tools
- Assist in the development of customized pricing through alternate scenario modeling of plan designs, programs and/or employee contributions
- Develop basic underwriting and actuarial skills and build awareness of health care plan design and cost factors
- Work in a fast-paced, challenging and dynamic consulting environment with colleagues across all organizational levels
Requirements
- Progress towards a bachelor’s degree in actuarial science, math, statistics, economics, engineering or other related fields
- Status as a currently enrolled student; expected graduation in Fall 2026 or Spring 2027
- Record of top academic achievement (minimum preferred GPA: 3.0/4.0)
- A commitment to achieving a Society of Actuaries (SOA) designation
- Legal work authorization in the U.S. on a permanent and ongoing basis without the need for sponsorship now or in the future
- Strong analytical skills, both quantitative and qualitative
- Working knowledge of Microsoft Office—Word, Excel, and PowerPoint
- Advanced programming skills are a plus (e.g. R, Python, SAS and SQL)
- Knowledge of data analysis, project management, and presentation design
- Excellent interpersonal, verbal, and written communication skills
- Intellectual curiosity and desire to develop new skills
- Superior organizational skills and strong attention to detail
- Must be based in Mercer’s San Francisco, Los Angeles, Irvine, or Denver offices and work at least three days a week in the office
