Project briefs · Operations, Consulting & HR
Nationwide · Summer 2027
State Product Analyst Intern (Personal Lines): a project built for this posting
A 12-week internship on Nationwide's personal lines product team, analyzing state-level data on pricing, underwriting and claims to support product decisions. It suits business, economics and risk management majors who like turning data into recommendations.
Free, any major, no coding needed. Your project for this posting: Auto Insurance Loss Ratio Dashboard & Recommendation Memo.
- Company
- Nationwide
- Posting title
- Summer 2027 State Product Analyst Intern - Personal Lines
- Location
- Des Moines, IA or Columbus, OH (hybrid)
- Season
- Summer 2027
- Majors named
- Business, Economics, Finance, Risk Management, Mathematics
Checked open on the employer's careers site on 2026-11-18. Read the full posting ↗
What this role is really testing
The project
Auto Insurance Loss Ratio Dashboard & Recommendation Memo
Using a publicly available or self-constructed sample dataset, build an Excel or Google Sheets dashboard that tracks loss ratios, premium volume, and claims frequency across fictional territories or agent segments, then write a one-page memo recommending a pricing or underwriting action based on what the data shows. This directly mirrors the role's core loop: gather data from multiple sources, analyze it with spreadsheet tools, select the right visual format, and communicate a recommendation to a business partner.
- Create a structured dataset in Excel or Google Sheets with at least 20 rows representing fictional agents or territories, each with columns for Written Premium, Earned Premium, Incurred Losses, Claim Count, and State, then calculate derived metrics (Loss Ratio = Incurred Losses / Earned Premium, Frequency = Claim Count / Earned Premium) using formulas, and add a second tab that pulls in a secondary 'market benchmark' loss ratio you define manually to simulate an external data source.
- Build a dashboard tab with three clearly labeled charts, a bar chart ranking territories by loss ratio, a scatter plot comparing premium volume to loss ratio to spot outliers, and a line or column chart showing claim frequency versus the benchmark, using conditional formatting to flag any territory where loss ratio exceeds 70%, and include a summary statistics table (average, min, max, standard deviation) so a reader can absorb the story in under 30 seconds.
- Write a one-page Word or Google Docs memo addressed to a fictional Product Manager that states the analytical question, describes your data sources and one key assumption, identifies the two highest-risk territories from your dashboard with specific numbers, and closes with a concrete recommended action (e.g., rate increase percentage or underwriting restriction) supported by the data, keeping the memo to 250 words or fewer to demonstrate ability to communicate analysis concisely.
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 Nationwide posting and generated it on 2026-11-11. 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 Nationwide?
No. This is an independent project idea based on a public posting. It does not guarantee an interview.