Project briefs · Marketing & Sales

Sanofi · Summer 2027

Marketing and Sales Associate Intern, Vaccines: a project built for this posting

A 10-week summer role on Sanofi's vaccines commercial team, working on brand strategy, market research, customer segmentation and campaign ideas. Interns also run an ROI check on promotional spend and help prepare product launches.

Company
Sanofi
Posting title
2027 Summer Intern Marketing and Sales Associate, Vaccines, Morristown, NJ
Location
Morristown, NJ
Season
Summer 2027
Pay (as posted)
$35/hour
Majors named
Business, Communication, Economics, Marketing, Psychology, Life Sciences

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

What this role is really testing

Customer segmentation analysisMarket research synthesisBrand messaging developmentCampaign concept developmentROI and cost-effectiveness thinkingStructured business communicationExcel-based data modelingCommercial evaluation

The project

OTC Category Segment Scorecard: Excel-Based Prioritization Tool

A structured, formula-driven Excel workbook that scores and ranks three fictional consumer segments for an OTC health product using weighted criteria, category fit, reach, willingness to pay, competitive saturation, and media efficiency, and outputs a visual ranked summary with a one-page recommendation memo embedded as a final tab. This maps directly to the role because it demonstrates the quantitative side of segmentation and commercial evaluation that complements deck storytelling: a recruiter can open it, change a weight, and immediately see the tool respond, proving the candidate can build decision-support assets, not just describe them.

  1. Build the data layer: create three segment profile tabs (e.g., 'Caregiver Parents,' 'Active Seniors,' 'Wellness Millennials'), each populated with five scored attributes (1–5 scale), category relevance, addressable reach, price sensitivity, competitive whitespace, and digital media efficiency, sourced from brief desk research or realistic assumptions clearly labeled as such.
  2. Build the scoring engine on a 'Scorecard Summary' tab: use SUMPRODUCT formulas against a user-editable weight row so each segment receives a weighted total score; add a simple clustered bar chart that updates automatically when weights change, and use conditional formatting to highlight the top-ranked segment in green and the lowest in amber.
  3. Add a 'Recommendation Memo' tab formatted as a one-page internal brief, three short paragraphs covering the winning segment rationale, two suggested campaign angles tailored to that segment, and a plain-English note on which scoring weight assumption most changes the outcome, so the recruiter sees both the analytical tool and the business communication output in a single file.
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 Sanofi posting and generated it on 2026-10-21. 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 Sanofi?

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