Business Analyst, Data Integration and ETL

State Street

Confirmed live yesterday High trust

Quick summary

Work type
On-site
Location
Burlington, MA
Salary
$80,000–$140,000 / yr
Posted
44 days ago
Freshness
Confirmed live yesterday
Closes
Oct 5, 2026

Market check

Salary context

Below market

How this pay compares to similar roles

Similar $142k
This role $110k
$69k most similar roles pay here $179k

This role pays less than 80% of similar roles. Most pay $116,396–$167,950 — the shaded band above. At the midpoint, this role pays about $110k versus about $142k for comparable roles.

Based on 240 similar postings.

Employer

About State Street

State Street Corporation is one of the world''s largest custodian banks and asset managers, providing investment servicing, investment management, and investment research to institutional investors. Industry: Financial Services & Asset Custody

State Street currently has 176 open roles on FindRole.

Listed pay typically runs $120,000–$202,500 across 172 roles with salary data.

Most-posted roles

View all roles at State Street

At a glance

TL;DR · Business Analyst, Data Integration and ETL

The Business Analyst, AVP supports data integration and ETL capabilities by translating business needs into functional specifications, user stories, and source-to-target mappings. Working closely with Product Owners, engineering teams, and QA, the role involves analyzing current workflows to identify gaps and designing improvements for both existing processes and new enhancements. The position focuses on supporting investment management business processes through data flows involving inbound feeds, transformations, and validations. Key technical requirements include proficiency in SQL, Pentaho Kettle, and Talend, along with experience in Azure cloud-based platforms like Snowflake or SQL Server. Candidates must navigate complex financial data domains including securities, transactions, and market data. The role ensures operational readiness by defining test scenarios and troubleshooting integration issues while managing documentation for various stakeholders within an Agile delivery environment to ensure reliable data distribution.

What does a Business Analyst earn?

Median $119050 from 32 postings across 11 companies.

See salary data

What you'll do

  • Research, analyze, and document business and functional requirements for data integration and ETL workflows.
  • Create source-to-target mappings, transformation rules, user stories, and acceptance criteria for technical teams.
  • Translate complex business needs into implementable design details for engineers using Pentaho Kettle and Talend.
  • Analyze current ETL workflows to identify gaps and define improvements for reliability and supportability.
  • Define test scenarios and data validation approaches in partnership with the QA team.
  • Troubleshoot integration issues, reproduce data defects, and perform root-cause analysis for support teams.
  • Support migration planning and analysis as data capabilities transition toward Azure cloud platforms.

What we're looking for

  • Bachelor’s degree in Finance, Business, Information Systems, Computer Science, Engineering, Mathematics, Data Analytics, or a related field.
  • 4+ years of experience in business analysis, product analysis, systems analysis, or implementation/support within financial technology or data integration environments.
  • Working knowledge of ETL concepts and tools, specifically Pentaho Kettle and Talend.
  • Strong SQL knowledge to analyze queries, validate data, and support root-cause analysis of data issues.
  • Ability to document source-to-target mappings, transformation logic, and functional specifications for technical teams.
  • Experience with financial services data domains such as securities, transactions, positions, and market data.
  • Proficiency in Agile methodologies including backlog refinement, user story writing, and sprint planning.
  • Familiarity with cloud platforms like Microsoft Azure and data tools like Snowflake or SQL Server.

More like this

Similar roles

Business Systems Analyst

Adobe

San Jose, CA 3 days ago $115,500$167,250
ERP CRM HRIS Cloud Platforms Identity Management data-migration process-mapping User Stories change-management project-tracking
3+ yrs exp

Business Data Analyst

AbbVie

Helsinki, Uusimaa, Finland 79 days ago
SQL Power BI DAX Power Query Veeva CRM Salesforce SFMC ETL Data Warehousing Quiver Contour Data Governance Market Research Data Analytics Automation
2+ yrs exp Hybrid

Business Analyst

CIBC

IL 15 days ago $70,000$90,000
Agile Waterfall JIRA Confluence Visio MS Office Suite UAT Test Management Requirements Gathering Data Mining Machine Learning Statistical Analysis Metrics Analysis Business Analysis Project Management
3+ yrs exp Hybrid

Business Analyst

Cardinal Health

65 days ago $80,900$115,500
JIRA Confluence SharePoint Visio Lucid chart Excel PowerPoint Agile EDI APIs ERP Warehouse Management Systems data/reporting
4+ yrs exp Hybrid