Senior Associate, Data Analyst/Data Engineer

State Street Corporation; Quincy (MA); On-site; USD 70,000 - 90,000; Full time

Benefits offered by this job

401K match

Medical & life insurance

PTO & disability

Employee Assistance Program

Bonus eligibility

Tax-advantaged savings

Job summary

State Street Corporation in Massachusetts is seeking an entry-level data analyst/data engineer for the GTS Control Tower team. The role collects, transforms, and analyzes data to deliver insights and supports collaboration across analytics, governance, and engineering groups.

You will design and maintain Power BI dashboards, build semantic data models using DAX, and perform ETL with Python and Power Query. A Bachelor's degree in a related field and a portfolio with data projects are required;

Qualifications

• Online portfolio with examples exhibiting analysis skills.
• Experience with Microsoft Power BI, DAX, Power Query, M, ETL, Python, PySpark, SQL.
• Bachelor's degree in a data analytics, data science, computer science or equivalent experience.

Responsibilities

• Design, develop, and maintain Power BI dashboards and reports communicating KPIs and insights.
• Build semantic data models with relationships, calculated columns, and measures using DAX; perform ETL with Python and Power Query.
• Integrate data from SQL databases, Azure services, Excel and other systems into reliable datasets.
• Tune data models and DAX to optimize performance and user experience.
• Support governance through RLS and Power BI workspace management; collaborate with stakeholders to translate needs into analytics solutions.

Skills

Power BI

DAX

Power Query

M

ETL

Python

PySpark

SQL

Education

Bachelor's degree in data analytics, data science, computer science or equivalent experience

Tools

Azure

Job description

We are currently seeking an entry level data analyst/data engineer to help us collect, transform and extract meaning from data for the Global Technology Services (GTS) Control Tower team at State Street. The position performs a wide range of activities with experts from GTS, business intelligence, business analysis, data engineering, process engineering, governance, and data analysts to collaboratively solve a wide array of complex technical problems.

About the GTS Control Tower team

The GTS Control Tower team is an exciting and growing area of State Street with unique insight into the whole spectrum of our data, metrics, and dashboards at State Street.

This name change reflects the work we are actively doing across GTS: integrating dependency management, business analysis, process design, and governance to transform data into action and keep remediation efforts flying smoothly.

The GTS Control Tower Mission

Our core focus is on transforming data into actionable insights. Our goal is to enable GTS Leadership to accelerate progress against key strategic initiatives across GTS and to drive results.

Core Responsibilities

• Report & Dashboard Development: Design, develop, and maintain high quality, accessible interactive Power BI dashboards and reports that clearly communicate key performance indicators (KPIs) and business insights.
• Data Modeling & Transformation: Build and optimize semantic data models, including relationships, calculated columns, and measures using DAX. Perform data extraction, transformation, and loading (ETL) using Python and Power Query (M).
• Data Source Integration: Connect, consolidate, and manage data from multiple sources such as SQL databases, Azure services, Excel, and other enterprise systems into reliable, well structured datasets.
• Performance Optimization: Tune data models and DAX calculations to ensure optimal performance, scalability, and user experience.
• Security & Platform Administration: Implement and maintain row level security (RLS), manage Power BI workspaces and apps, and support capacity and governance best practices within the Power BI Service.
• Stakeholder Collaboration: Partner with business stakeholders to gather requirements, translate business needs into analytical solutions, and deliver actionable, decision ready insights.
• Documentation & Standards: Create and maintain clear documentation for data models, transformation logic, report definitions, and operational procedures to support transparency and long term maintainability.

What We Value

• Willingness to learn and develop new skills, embracing challenges and continuous improvement
• Strong work ethic, focus on achieving goals, and delivering measurable results
• Desire for creative thinking, problem-solving, and proposing new ideas to improve processes or products
• People who thrive in a collaborative team environment

Requirements

• An online portfolio with examples with nonconfidential data that demonstrates your analysis skills
• Some experience with Microsoft Power BI, DAX, Power Query, M, ETL, Python, PySpark, SQL
• A Bachelor's degree in a data analytics, data science, computer science or equivalent experience

Salary Range

Salary Range: The range quoted above applies to the role in the primary location specified. If the candidate would ultimately work outside of the primary location above, the applicable range could differ.

Benefits

Employees are eligible to participate in State Street’s comprehensive benefits program, which includes:

• 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

For a full overview, visit https://hrportal.ehr.com/statestreet/Home.

About State Street Across the globe, institutional investors rely on us to help them manage risk, respond to challenges, and drive performance and profitability. We keep our clients at the heart of everything we do, and smart, engaged employees are essential to our continued success. We are committed to fostering an environment where every employee feels valued and empowered to reach their full potential. As an essential partner in our shared success, you’ll benefit from inclusive development opportunities, flexible work-life support, paid volunteer days, and vibrant employee networks that keep you connected to what matters most. Join us in shaping the future.

As an Equal Opportunity Employer, we consider all qualified applicants for all positions without regard to race, creed, color, religion, national origin, ancestry, ethnicity, age, disability, genetic information, sex, sexual orientation, gender identity or expression, citizenship, marital status, domestic partnership or civil union status, familial status, military and veteran status, and other characteristics protected by applicable law. Discover more information on jobs at StateStreet.com/careers Read our CEO Statement

Job Application Disclosure: It is unlawful in Massachusetts to require or administer a lie detector test as a condition of employment or continued employment. An employer who violates this law shall be subject to criminal penalties and civil liability.

Across the globe, institutional investors rely on us to help them manage risk, respond to challenges, and drive performance and profitability. We keep our clients at the heart of everything we do, and smart, engaged employees are essential to our continued success. We are committed to fostering an environment where every employee feels valued and empowered to reach their full potential. As an essential partner in our shared success, you’ll benefit from inclusive development opportunities, flexible work-life support, paid volunteer days, and vibrant employee networks that keep you connected to what matters most. Join us in shaping the future.

As an Equal Opportunity Employer, we consider all qualified applicants for all positions without regard to race, creed, color, religion, national origin, ancestry, ethnicity, age, disability, genetic information, sex, sexual orientation, gender identity or expression, citizenship, marital status, domestic partnership or civil union status, familial status, military and veteran status, and other characteristics protected by applicable law. Discover more information on jobs at StateStreet.com/careers Read our CEO Statement