State Street→
State Street - Alpha Data Services Control… at State Street · Quincy
InternshipOn-siteFull-timeQuincy, MA$42k–$65k/yr
Skills
sqldata managementcloud platformsbi toolsanalytical skillscontinuous improvementself-motivated
Job Description
Summary: State Street is a global leader in investment management services, and they are seeking an intern for their Alpha Data Services Control Framework. The role involves developing and maintaining data validation logic, supporting migration of controls, and partnering with various teams to enhance operational processes.
Responsibilities:
- Develop, enhance, and maintain data validation logic within the Enterprise Control Framework, including controls transitioning to a new strategic platform
- Support the migration of existing controls, ensuring functional parity, improved performance, and adherence to updated platform standards
- Perform control rationalization activities, including:
- Assessing the original business purpose and risk addressed by existing controls
- Evaluating whether controls remain necessary, redundant, or obsolete
- Reviewing control logic, thresholds, and documentation for clarity, effectiveness, and efficiency
- Partner with Operational and Product teams to redesign or retire controls where appropriate, applying continuous improvement principles
- Participate in business requirement elaboration and functional design sessions to understand operational workflows, data flows, and source systems
- Assist Operational teams in building and maintaining checklists, alerts, and event-monitoring workflows within the Control Framework platform
- Conduct interviews, develop user stories, and perform workflow and impact analysis
- Contribute to the definition of reporting and monitoring solutions that enable Operations to make timely, risk-informed decisions
- Perform business user acceptance testing and validation of control outcomes
- Provide production support and troubleshooting for existing controls, workflows, and dashboards
- Deliver demos, walkthroughs, and training sessions for stakeholders on new or enhanced controls and platform capabilities
Required Qualifications:
- Bachelor's degree or Masters in Business, Accounting, Finance, MIS, Information Technology, or a related field
- Strong SQL skills with experience developing, querying, and troubleshooting complex logic
- Experience querying data on cloud platforms (AWS, Azure, Snowflake)
- Exposure to data management concepts, including data quality, lineage, reconciliation, or ETL processes
- Demonstrated analytical and problem-solving skills with strong attention to detail
- Ability to independently investigate issues, gather supporting evidence, and articulate findings clearly
- Self-motivated, organized, and able to manage multiple priorities in a time-driven environment
Preferred Qualifications:
- Familiarity with LEAN, Six Sigma, or continuous improvement methodologies strongly preferred
- Prior experience with BI or reporting tools (e.g., Spotfire, Tableau, Looker, Information Builders) a plus
- Database management or ETL development experience a plus
- Asset management or investment operations experience a plus
Required Skills: SQL, Data management
Important Skills: Cloud platforms, BI tools
Nice-to-Have Skills: Analytical skills, Continuous improvement, Self-motivated
Internship Start Date: Start in 2026 Summer
Benefits: Our retirement savings plan (401K) with company match, Insurance coverage including basic life, medical, dental, vision, long-term disability, and other optional additional coverages, Paid-time off including vacation, sick leave, short term disability, and family care responsibilities, Access to our Employee Assistance Program, Incentive compensation including eligibility for annual performance-based awards (excluding certain sales roles subject to sales incentive plans), Eligibility for certain tax advantaged savings plans, Inclusive development opportunities, Flexible work-life support, Paid volunteer days, Vibrant employee networks that keep you connected to what matters most
Benefits
Our retirement savings plan (401K) with company match
Insurance coverage including basic life, medical, dental, vision, long-term disability, and other optional additional coverages
Paid-time off including vacation, sick leave, short term disability, and family care responsibilities
Access to our Employee Assistance Program
Incentive compensation including eligibility for annual performance-based awards (excluding certain sales roles subject to sales incentive plans)
Eligibility for certain tax advantaged savings plans
Inclusive development opportunities
Flexible work-life support
Paid volunteer days
Vibrant employee networks that keep you connected to what matters most