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