Senior Associate, Data Analyst/Data Engineer

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

Job summary

State Street is hiring an entry-level Power BI Analytics Developer to join the Global Technology Services Control Tower. You will design dashboards, build data models, and perform ETL to turn data into actionable insights.

The role emphasizes collaboration with stakeholders, developing scalable data solutions, and maintaining documentation while learning a broad tech stack including DAX, Python, SQL, and Azure.

Qualifications

• Portfolio with examples using nonconfidential data demonstrating analysis skills.
• Some experience with Microsoft Power BI, DAX, Power Query, M, ETL, Python, PySpark, and SQL.
• Bachelor's degree in data analytics, data science, computer science, or equivalent.

Responsibilities

• Design, develop, and maintain interactive Power BI dashboards and reports communicating KPIs and insights.
• Build semantic data models with relationships, calculated columns, and measures using DAX.
• Perform ETL using Python and Power Query (M).
• Consolidate data from SQL databases, Azure, Excel, and other sources into reliable datasets.
• Tune data models and DAX for performance and user experience.
• Implement and manage Row Level Security (RLS) and govern Power BI workspaces and apps.
• Collaborate with stakeholders to translate needs into analytical solutions and deliver insights.
• Document data models, transformation logic, report definitions, and procedures.

Skills

Power BI

DAX

Power Query

M

Python

SQL

PySpark

ETL

Education

Bachelor's degree in data analytics / data science / CS

Tools

Azure

Excel

RLS

Job description

This entry-level position supports the Global Technology Services (GTS) Control Tower team at State Street. The role focuses on delivering reporting and analytics by designing Power BI dashboards, building data models, and performing ETL and data transformations to turn data into actionable insights.

Key Responsibilities

• Design, develop, and maintain high quality, accessible interactive Power BI dashboards and reports that clearly communicate KPIs and business insights.
• 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).
• Connect, consolidate, and manage data from multiple sources including SQL databases, Azure services, Excel, and other enterprise systems into reliable, well structured datasets.
• Tune data models and DAX calculations to support optimal performance, scalability, and user experience.
• 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.
• Partner with business stakeholders to gather requirements, translate business needs into analytical solutions, and deliver decision ready insights.
• Create and maintain clear documentation covering data models, transformation logic, report definitions, and operational procedures for transparency and long term maintainability.

Required Qualifications

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

Technology Stack

• Power BI
• DAX
• Power Query (M)
• ETL
• Python
• PySpark
• SQL
• Azure
• Excel
• Row level security (RLS)
• Power BI Service

Benefits

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

About the GTS Control Tower Team

The GTS Control Tower team is an exciting and growing area within State Street, providing unique insight across the full spectrum of the company’s data, metrics, and dashboards. The work includes integrating dependency management, business analysis, process design, and governance to transform data into action and support remediation efforts.

GTS Control Tower Mission

The team’s core focus is transforming data into actionable insights. The goal is to help GTS Leadership accelerate progress against key strategic initiatives across GTS and drive results.

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.
• Collaboration and the ability to thrive in a collaborative team environment.