QA Engineer - Tech Lead

Job Description:

We are currently seeking a QA Engineer to help us validate the data and analytical reporting solutions 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:

ETL / Data Pipeline Testing:

Validate end-to-end ETL/ELT pipelines built using Azure/Microsoft Fabric platforms.

Validate data movement across source, staging (Bronze/Silver), and consumption (Gold) layers.

Ensure correctness of data transformations, aggregations, and business rules.

Execute data reconciliation testing between systems.

Validate data completeness, duplicates, null values, and integrity checks

Report / Dashboard Testing (Power BI / Analytics Layer): Perform end-to-end validation of reports and dashboards built on semantic models (Power BI) Validate for: Data accuracy and consistency with backend sources KPI calculations, business logic, measures, and aggregations Filters, slicers, drill-downs, and user interactions Perform functional and UI validation of dashboards Ensure data consistency between semantic layer and reports 3

Test Planning & Execution: Create, maintain, and execute: Test plans, Test cases and test scripts Automation scripts (where applicable) Participate in STLC phases including requirement analysis, test design, execution, and closure Prepare test data and validate test scenarios.

Defect Management & Reporting: Identify, log, track, and manage defects using tools such as JIRA, HP ALM, RTC Collaborate with development teams for resolution and retesting Communicate testing progress, risks, and results to stakeholders

Agile & Collaboration: Participate actively in Agile ceremonies:: Sprint planning, Daily stand-ups, Sprint reviews and retrospectives Work closely with Data Engineers and Business teams for requirement clarity and validation.

What We Value: A strong willingness to learn, adapt, and continuously improve in a fast‑evolving data ecosystem. Ownership mindset with a focus on delivering high‑quality, measurable outcomes. Analytical thinking and problem‑solving skills with the ability to propose innovative and scalable solutions. Collaboration and effective communication within cross‑functional teams.

Requirements:

4 to 7 years of experience in QA / Testing roles.

Strong understanding of ETL / Data Warehouse testing and data validation.

Strong SQL expertise.

High attention to detail with focus on data quality and accuracy.

Mandatory skills:

SQL (Advanced querying, analytical functions)

ETL / Data validation testing

Test management tools (JIRA / HP ALM / RTC)

STLC process understanding

Good to Have:

Exposure to Microsoft Azure and cloud data platforms

Python

Understanding of Financial Services / Banking domain is highly desirable

Preferred Qualifications:

Experience testing data pipelines and reporting solutions end-to-end Exposure to Microsoft Power BI / analytics platforms.

Ability to identify data quality issues proactively

QA Certifications like ISTQB

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