Project briefs · Finance & Accounting

State Street · Summer 2027

US Wealth Summer Intern: a project built for this posting

An internship on State Street Investment Management's US Wealth team, helping with sales effectiveness and distribution projects across broker-dealer, RIA and other channels. It fits business and finance students interested in how asset managers sell to wealth advisors.

Build this project for free →

Free, any major, no coding needed. Your project for this posting: Wealth Manager Segmentation & ETF Opportunity Dashboard.

Company
State Street
Posting title
State Street Investment Management - US Wealth - 2027 Summer Internship
Location
Boston, MA
Season
Summer 2027
Pay (as posted)
$41,600 - $65,000 annual range (as posted)
Majors named
Finance, Economics, Business, Marketing

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

What this role is really testing

Financial advisor segmentation and analysisData-driven insight generationBusiness intelligence and trend identificationPowerPoint presentation and storytellingExcel-based data modelingMarket research and competitive positioningSales enablement communication

The project

Wealth Manager Segmentation & ETF Opportunity Dashboard

A one-page Excel workbook with an embedded chart dashboard that segments a mock universe of 30 financial advisors by AUM tier, product affinity, and engagement score, then surfaces the top 10 highest-opportunity targets for a hypothetical State Street ETF pitch. This maps directly to the role's core asks around advisor segmentation, data enrichment, and identifying growth opportunities through business intelligence.

  1. Build a structured Excel table of 30 fictional advisors with columns for Advisor Name, Firm, AUM Tier (Small/Mid/Large), Primary Product Focus (Equities/Fixed Income/Multi-Asset), Last Engagement Date, and a calculated Opportunity Score formula that weights AUM tier (40%), product fit with ETFs (40%), and recency of engagement (20%), use IF and VLOOKUP or XLOOKUP to automate the scoring so a recruiter can see real formula logic.
  2. Create a second sheet with three pivot-chart visualizations: a bar chart ranking the top 10 advisors by Opportunity Score, a pie chart breaking down the advisor universe by AUM tier, and a clustered column chart showing average Opportunity Score by product focus, format all charts with a consistent color scheme, axis labels, and a bolded title so the dashboard reads cleanly at a glance.
  3. Add a third sheet titled 'Account Planning Brief' styled as a mini PowerPoint-in-Excel using merged cells, borders, and text boxes: include a one-paragraph executive summary of which advisor segment represents the biggest ETF growth opportunity, two specific outreach recommendations tied to the data, and a 'Next Best Action' row for the top three scoring advisors, this mirrors the presentation and actionable-insight deliverables listed explicitly in the job description.
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 State Street 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 State Street?

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