Join the GTS Control Tower team at State Street, an exciting and growing area focused on turning data into action. In this onsite role in Quincy, MA, you will help design dashboards, build reliable data models, and deliver decision-ready insights for GTS leadership while collaborating with stakeholders across the business.
What you’ll do
- Design, develop, and maintain high-quality, accessible Power BI dashboards and reports that communicate KPIs and business insights.
- Build and optimize semantic data models, including relationships, calculated columns, and measures using DAX.
- Perform ETL and data transformations using Python and Power Query (M).
- Connect and consolidate data from multiple sources such as SQL databases, Azure, Excel, and other enterprise systems to create dependable, well-structured datasets.
- Tune data models and DAX to support performance, scalability, and a strong user experience.
- Implement and maintain row level security (RLS), and manage Power BI workspaces and apps while supporting capacity and governance practices within the Power BI Service.
- Work with business stakeholders to gather requirements, translate business needs into analytical solutions, and deliver actionable insights.
- Create and maintain clear documentation for data models, transformation logic, report definitions, and operational procedures.
What you’ll bring
- An online portfolio featuring examples (using nonconfidential data) that demonstrate analysis skills.
- Some experience with Microsoft Power BI, DAX, Power Query, M, ETL, Python, PySpark, and SQL.
- A Bachelor’s degree in a data analytics, data science, computer science, or equivalent experience.
Tools you’ll use
Power BI, DAX, Power Query, M, ETL, Python, PySpark, SQL, Azure, Excel, Row level security (RLS), Power BI Service
How the team delivers impact
The GTS Control Tower mission is focused on transforming data into actionable insights. The team aims to enable GTS Leadership to accelerate progress against key strategic initiatives across GTS and drive measurable results, including work related to dependency management, business analysis, process design, and governance.
Benefits
- 401(k) retirement savings plan with company match
- Insurance: basic life, medical, dental, vision, long-term disability, plus other optional additional coverages
- Paid time off: vacation, sick leave, short-term disability, and family care responsibilities
- Employee Assistance Program access
- Incentive compensation: eligibility for annual performance-based awards (excluding certain sales roles subject to sales incentive plans)
- Eligibility for certain tax advantaged savings plans
What State Street values
- Willingness to learn, develop new skills, and embrace challenges with continuous improvement
- Strong work ethic focused on achieving goals and delivering measurable results
- Desire for creative thinking, problem-solving, and proposing ideas to improve processes or products
- Ability to thrive in a collaborative team environment
