Project briefs · Health & Life Sciences

The Cigna Group · Summer 2027 (starts May 24, 2027)

Risk & Underwriting Intern: a project built for this posting

A summer internship in Cigna's health insurance risk and underwriting group, helping assess and price employer health plans. It suits risk management, finance and math students with three years of study completed.

Build this project for free →

Free, any major, no coding needed. Your project for this posting: Healthcare Group Underwriting Risk Scorecard.

Company
The Cigna Group
Posting title
Risk & Underwriting Summer Internship Program
Location
Franklin, TN (also Scottsdale, AZ)
Season
Summer 2027 (starts May 24, 2027)
Pay (as posted)
$24 per hour (as posted)
Majors named
Risk Management, Insurance, Business, Economics, Finance, Mathematics

Checked open on the employer's careers site on 2026-11-18. Read the full posting ↗

What this role is really testing

Risk assessment and summarizationExcel data cleaning and analysisUnderwriting logic and pricing reasoningStructured written communicationData visualization for business decisionsProcess documentation and decision frameworksQuantitative reasoning applied to real scenarios

The project

Healthcare Group Underwriting Risk Scorecard

A one-page Excel workbook that ingests fictional small-group employer data, scores each account across weighted risk factors (claims history, group size, industry, age distribution), and outputs a color-coded underwriting recommendation with a plain-English summary memo. This maps directly to the role because it demonstrates exactly what the team will ask an intern to do: organize case inputs, apply quantitative judgment, and communicate a risk position clearly.

  1. Build the data layer: create a table of 8-10 fictional employer accounts with columns for group size, average member age, industry code, prior claims ratio, and tenure; use Excel data validation and dropdowns to enforce clean inputs and add a second sheet that defines the scoring rules for each factor with explicit numeric weights that sum to 100.
  2. Build the scoring engine: use VLOOKUP or INDEX/MATCH to pull each account's raw factor values into a scoring sheet, apply the weighted formula to produce a composite risk score per account, then use conditional formatting to automatically flag accounts as Preferred, Standard, or Refer to Underwriter based on score thresholds, and add a simple bar chart ranking all accounts by score.
  3. Write a one-paragraph underwriting memo directly inside the workbook on a third sheet that identifies the two highest-risk accounts from your output, states the specific factors driving their scores, and recommends next steps a senior underwriter should take, using bullet points and plain business language that a non-technical reader can act on in under 60 seconds.
Build this project for free →

Free account. Provieo walks you through it and turns it into a page with a link you can put on your application. This posting comes with you.

Questions

Do I need to know how to code?

No. For roles like this one, Provieo builds the project as a live case-study page: slides, tables and findings you fill in. You bring the thinking.

Where did this project come from?

Provieo read the The Cigna Group posting and generated it on 2026-11-18. If you paste the same posting yourself you may get a different project, so two applicants don't show up with the same one.

Is Provieo connected to The Cigna Group?

No. This is an independent project idea based on a public posting. It does not guarantee an interview.