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.
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
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.
- 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.
- 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.
- 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.
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.