Tech Stack Python Spring SQL
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 awareness of health care plan design and cost factors Work in a fast-paced, challenging 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 with expected graduation Fall 2026 or Spring 2027 Record of top academic achievement (minimum preferred GPA: 3.0/4.0) 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 Ability to work in a fast-paced consulting environment and be in-office at least three days per week (hybrid) Professional development opportunities Supportive leaders and mentorship Vibrant and inclusive culture Benefits and rewards to enhance your well-being Career growth and internal mobility opportunities Hybrid work arrangement (flexibility to work remotely and in-office) Reasonable accommodations for applicants with needs Copy Applicant Tracking System Keywords Tip: use these terms in your resume and cover letter to boost ATS matches.
Hard skills data analysis cost projections underwriting skills actuarial skills scenario modeling programming (R) programming (Python) programming (SAS) programming (SQL) spreadsheet management
Soft skills analytical skills interpersonal skills verbal communication written communication organizational skills attention to detail intellectual curiosity desire to develop new skills