Back to jobs

Business Analyst – Data Integration and ETL, AVP

Reads like a Data Engineer role: pipelines and data infrastructure.

Burlington, Massachusetts, United States of America

Open 7 months, first seen by us 221 days ago
Pay
$80,000–140,000/year — pay source
Salary Range: $80,000 - $140,000 Annual 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.
Read the full posting
Work setting
Not stated
Employment
Not stated

What you’ll work on

Full posting
  • Document business and functional requirements for data integration and ETL workflows

  • Produce source-to-target mappings, transformation rules and acceptance criteria

  • Analyze current ETL workflows and define practical reliability improvements

  • Define test scenarios and data validation approaches with QA

  • Help troubleshoot integration issues and support root-cause analysis of data defects

From the employer’s posting
Research, analyze, and document business and functional requirements for data integration and ETL workflows.
Produce clear business requirement documents, functional specifications, source-to-target mappings, transformation rules, user stories, acceptance criteria, and workflow documentation.
Analyze current-state ETL workflows, identify gaps or pain points, and help define practical improvements that improve reliability, supportability, and business alignment.
Partner with QA to define test scenarios, data validation approaches, expected results, and end-to-end test coverage for ETL workflows.
Assist implementation, support, and operations teams in troubleshooting integration issues, reproducing data defects, clarifying expected behavior, and supporting root-cause analysis.

What you’ll bring

All qualifications

Core experience

  • 4+ years of business analysis, product analysis, systems analysis, or implementation/support experience within financial technology, investment management, enterprise applications, or data integration environments.
  • Bachelor’s degree in Finance, Business, Information Systems, Computer Science, Engineering, Mathematics, Data Analytics, or a related field.
  • Ability to document source-to-target mappings, transformation logic, data validation rules, exception handling, and operational support needs.
  • Strong understanding of financial services data domains such as securities, transactions, positions, accounts, reference data, market data, operations data, or reporting outputs.
  • Strong SQL knowledge, including the ability to analyze queries, understand joins, validate data, and support root-cause analysis of data issues.
  • Experience working with batch, scheduled, file-based, database-driven, and/or API-based integration workflows.

Preferred experience

  • Experience supporting investment management platforms, enterprise financial services systems, or comparable data integration environments is strongly preferred.
  • Familiarity with data warehousing, reporting dependencies, data governance, metadata, lineage, or auditability concepts is a plus.
Qualification wording
4+ years of business analysis, product analysis, systems analysis, or implementation/support experience within financial technology, investment management, enterprise applications, or data integration environments.
Bachelor’s degree in Finance, Business, Information Systems, Computer Science, Engineering, Mathematics, Data Analytics, or a related field.
Ability to document source-to-target mappings, transformation logic, data validation rules, exception handling, and operational support needs.
Strong understanding of financial services data domains such as securities, transactions, positions, accounts, reference data, market data, operations data, or reporting outputs.
Strong SQL knowledge, including the ability to analyze queries, understand joins, validate data, and support root-cause analysis of data issues.
Experience working with batch, scheduled, file-based, database-driven, and/or API-based integration workflows.
Experience supporting investment management platforms, enterprise financial services systems, or comparable data integration environments is strongly preferred.
Familiarity with data warehousing, reporting dependencies, data governance, metadata, lineage, or auditability concepts is a plus.
Education & alternatives
Education Bachelor’s degree in Finance, Business, Information Systems, Computer Science, Engineering, Mathematics, Data Analytics, or a related field. Equivalent practical experience in financial services, ETL analysis, platform support, or data integration delivery will also be considered.

About State Street

We provide investment servicing, data & analytics, investment research & trading and investment management to institutional clients.

In the employer’s words · Read in context

Apply at State Street

Posting record

Report an error

Open 7 monthsWe first saw this posting 221 days ago and it is still up. Roles open this long are often slow to fill or kept open to collect applications.

Status in our records
Live
First seen by us
Apr 15, 2026221 days ago
Recorded sightings
218
Last seen by us
Nov 21, 2026

These dates show when we found the posting. Check the employer’s website to confirm it is still accepting applications.

How this job compares

Pay

Lower than most similar jobs

$80K–$140K against $127K–$189K, the middle half of what similar US postings state.

From 2,448 postings in the last year. Stated ranges, not salaries paid.

Time since we first saw it

Day 221

Up longer than most. Similar jobs usually come down between day 6 and day 56.

Well past State Street’s usual: its jobs come down by about day 31.

From 14,766 similar postings that came down, and 380 of State Street’s. Coming down is not always a hire.

State Street is hiring

125 open jobs

Open jobs by the week we first saw them, last 12 weeks.

  • Data Engineer hiring is steady
  • Takes jobs down at a usual pace
  • 2% of open jobs were reposted
Hiring record

See how this role fits your experience

Add your resume and we’ll mark which of these tools you already use, and point out anything in the posting that could rule you out.

  • SQL
  • Azure
  • Oracle
  • Pentaho
  • Snowflake
  • SQL Server
  • Talend
Where the posting names them
- Produce clear business requirement documents, functional specifications, source-to-target mappings, transformation rules, user stories, acceptance criteria, and workflow documentation. - Partner with engineering teams working with Pentaho Kettle, Talend, SQL, and related integration tools to translate business needs into implementable ETL design details. - Analyze current-state ETL workflows, identify gaps or pain points, and help define practical improvements that improve reliability, supportability, and business alignment.
- Strong understanding of financial services data domains such as securities, transactions, positions, accounts, reference data, market data, operations data, or reporting outputs. - Strong SQL knowledge, including the ability to analyze queries, understand joins, validate data, and support root-cause analysis of data issues. - Experience working with batch, scheduled, file-based, database-driven, and/or API-based integration workflows.
- Some experience with cloud computing platforms, preferably Microsoft Azure, including cloud migration analysis, cloud-based data platforms, storage, integration services, or operational considerations. - Exposure to Snowflake, SQL Server, Oracle, Azure data services, or other cloud/data platforms is helpful, especially where these platforms support ETL migration, reporting, or data integration use cases. Education
The Business Analyst, AVP will support data integration and ETL capabilities, with a focus on understanding business needs, documenting requirements, and helping improve existing and new ETL designs. This role will work closely with the Product Owner, business stakeholders, engineering, QA, and support teams to ensure data flows are well-defined, supportable, and aligned with operational needs. The role will focus on supporting integrations using ETL tools such as Pentaho Kettle and Talend, including source-to-target mapping, data transformation rules, validation, exception handling, and production support considerations. The candidate will also support migration planning and analysis as the data integration and ETL capabilities evolve toward Azure cloud-based platforms. The ideal candidate will have 4+ years of business analysis experience, strong analytical and documentation skills, and the ability to bridge business users, Product Owners, and technical teams. The candidate should be comfortable working with financial data workflows and translating requirements into user stories, functional specifications, mapping documents, acceptance criteria, and delivery-ready documentation.
- Familiarity with data warehousing, reporting dependencies, data governance, metadata, lineage, or auditability concepts is a plus. - Some experience with cloud computing platforms, preferably Microsoft Azure, including cloud migration analysis, cloud-based data platforms, storage, integration services, or operational considerations. - Exposure to Snowflake, SQL Server, Oracle, Azure data services, or other cloud/data platforms is helpful, especially where these platforms support ETL migration, reporting, or data integration use cases.
- Experience supporting investment management platforms, enterprise financial services systems, or comparable data integration environments is strongly preferred. - Working knowledge of ETL concepts and tools, especially Pentaho Kettle and/or Talend; experience with similar ETL or data integration platforms is also valuable. - Ability to document source-to-target mappings, transformation logic, data validation rules, exception handling, and operational support needs.

Your next step

Complete your application on statestreet.wd1.myworkdayjobs.com. The employer’s form will show what is required.

Applying through Phenom

  • Phenom runs the employer’s careers site, but the application itself usually runs on another system, often Workday or Taleo. The advice for that system applies once you click Apply.

Already applied? Track this application

Job description

View original posting ↗

Business Analyst – Data Integration and ETL, AVP


Summary 

The Business Analyst, AVP will support data integration and ETL capabilities, with a focus on understanding business needs, documenting requirements, and helping improve existing and new ETL designs. This role will work closely with the Product Owner, business stakeholders, engineering, QA, and support teams to ensure data flows are well-defined, supportable, and aligned with operational needs. 


The role will focus on supporting integrations using ETL tools such as Pentaho Kettle and Talend, including source-to-target mapping, data transformation rules, validation, exception handling, and production support considerations. The candidate will also support migration planning and analysis as the data integration and ETL capabilities evolve toward Azure cloud-based platforms. 


The ideal candidate will have 4+ years of business analysis experience, strong analytical and documentation skills, and the ability to bridge business users, Product Owners, and technical teams. The candidate should be comfortable working with financial data workflows and translating requirements into user stories, functional specifications, mapping documents, acceptance criteria, and delivery-ready documentation. 

 

Responsibilities 

  • Research, analyze, and document business and functional requirements for data integration and ETL workflows. 
  • Work closely with the Product Owner to understand priorities, clarify scope, and support design decisions for both existing ETL processes and new ETL enhancements. 
  • Support platform-related data flows, including inbound feeds, outbound data distribution, transformations, validations, and downstream consumption. 
  • Produce clear business requirement documents, functional specifications, source-to-target mappings, transformation rules, user stories, acceptance criteria, and workflow documentation. 
  • Partner with engineering teams working with Pentaho Kettle, Talend, SQL, and related integration tools to translate business needs into implementable ETL design details. 
  • Analyze current-state ETL workflows, identify gaps or pain points, and help define practical improvements that improve reliability, supportability, and business alignment. 
  • Participate in design discussions for enhancements to existing ETL jobs as well as new ETL workflows needed to support investment management business processes. 
  • Partner with QA to define test scenarios, data validation approaches, expected results, and end-to-end test coverage for ETL workflows. 
  • Assist implementation, support, and operations teams in troubleshooting integration issues, reproducing data defects, clarifying expected behavior, and supporting root-cause analysis. 
  • Ensure documentation is accurate, complete, and usable by Product Owners, engineering, QA, operations, implementation, and support teams. 
  • Communicate clearly with stakeholders regarding scope, requirements, risks, dependencies, decisions, trade-offs, and delivery progress. 

 

Requirements 

  • 4+ years of business analysis, product analysis, systems analysis, or implementation/support experience within financial technology, investment management, enterprise applications, or data integration environments. 
  • Experience supporting investment management platforms, enterprise financial services systems, or comparable data integration environments is strongly preferred. 
  • Working knowledge of ETL concepts and tools, especially Pentaho Kettle and/or Talend; experience with similar ETL or data integration platforms is also valuable. 
  • Ability to document source-to-target mappings, transformation logic, data validation rules, exception handling, and operational support needs. 
  • Strong understanding of financial services data domains such as securities, transactions, positions, accounts, reference data, market data, operations data, or reporting outputs. 
  • Strong SQL knowledge, including the ability to analyze queries, understand joins, validate data, and support root-cause analysis of data issues. 
  • Experience working with batch, scheduled, file-based, database-driven, and/or API-based integration workflows. 
  • Ability to translate business needs into clear requirements, functional specifications, user stories, acceptance criteria, mapping documents, and delivery-ready documentation. 
  • Strong analytical skills, including the ability to reconcile conflicting data, identify gaps, validate assumptions, and work through complex business and technical scenarios. 
  • Excellent communication and interpersonal skills, including the ability to facilitate discussions across business, Product Owner, engineering, QA, operations, and support teams. 
  • Experience supporting testing, UAT, defect triage, data validation, production issue analysis, and operational readiness activities. 
  • Comfortable working in Agile delivery teams, including backlog refinement, story writing, sprint planning, demos, and prioritization discussions. 
  • Ability to independently ramp up on complex workflows, ask thoughtful questions, drive clarity, and help teams move requirements from discovery through delivery. 
  • Ability to work effectively with globally distributed teams and stakeholders across multiple functional areas. 
  • Familiarity with data warehousing, reporting dependencies, data governance, metadata, lineage, or auditability concepts is a plus. 
  • Some experience with cloud computing platforms, preferably Microsoft Azure, including cloud migration analysis, cloud-based data platforms, storage, integration services, or operational considerations. 
  • Exposure to Snowflake, SQL Server, Oracle, Azure data services, or other cloud/data platforms is helpful, especially where these platforms support ETL migration, reporting, or data integration use cases. 

 

Education 

Bachelor’s degree in Finance, Business, Information Systems, Computer Science, Engineering, Mathematics, Data Analytics, or a related field. 

Equivalent practical experience in financial services, ETL analysis, platform support, or data integration delivery will also be considered. 

About State Street


What we do. State Street is one of the largest custodian banks, asset managers and asset intelligence companies in the world. From technology to product innovation, we’re making our mark on the financial services industry. For more than two centuries, we’ve been helping our clients safeguard and steward the investments of millions of people. We provide investment servicing, data & analytics, investment research & trading and investment management to institutional clients.


Work, Live and Grow. We make all efforts to create a great work environment. Our benefits packages are competitive and comprehensive. Details vary in location, but you may expect generous medical care, insurance and savings plans among other perks. You’ll have access to flexible Work Program to help you match your needs. And our wealth of development programs and educational support will help you reach your full potential.


Inclusion, Diversity and Social Responsibility. We truly believe our employees’ diverse backgrounds, experiences and perspective are a powerful contributor to creating an inclusive environment where everyone can thrive and reach their maximum potential while adding value to both our organization and our clients. We warmly welcome candidates of diverse origin, background, ability, age, sexual orientation, gender identity and personality. Another fundamental value at State Street is active engagement with our communities around the world, both as a partner and a leader. You will have tools to help balance your professional and personal life, paid volunteer days, matching gift programs and access to employee networks that help you stay connected to what matters to you.


State Street is an equal opportunity and affirmative action employer.


Discover more at StateStreet.com/careers

Salary Range:

$80,000 - $140,000 Annual

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.

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); and, 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.

About State Street

People
About 52,000 in 2025, down 2% from the year before.Annual report (SEC Form 10-K)
Company
Listed as STT.

Demand for Data Engineer roles

New Data Engineer postings at the employers we follow are up 13% over the last 6 weeks compared with the 6 before.

Weekly new Data Engineer postings at the same employers, from the week of August 17 to the week of November 9. The fewest in a week was 845, the most 1,344, and the latest week had 1,007.
August 17Last week

Each bar is one week of new postings. The darkest bars are the last 6 weeks.

Counted from the hiring pages we’ve followed for at least five weeks, so employers we add don’t look like growth. Updated weekly.

About the role

We file this job under Data Engineer, by the work the posting describes.

Data engineers build and run the pipelines that copy data out of apps and outside services into a warehouse or lake, and fix them when a source changes or a load fails.

Expect SQL, Python, a cloud platform, a scheduler such as Airflow, and often tools for large data such as Spark or Kafka.

An analytics engineer works one step later, turning the raw data a data engineer lands into clean tables people can query.

US government figures for database architects

Median yearly pay, May 2025
$139,500
Expected change, 2025 to 2035
9.4% more jobsagainst 3.5% for all jobs

The government has no code for data engineers, so these figures are for the closest group, database architects, which includes data integration and data warehousing specialists.

Source: US Bureau of Labor Statistics, Occupational Employment and Wage Statistics (May 2025) and Employment Projections (2025 to 2035). Occupation code 15-1243.

Source details

View original posting ↗

Source notes

Source excerpts

Selected passages from the saved posting. Check the full description for conditions and exceptions.

Pay
Salary Range: $80,000 - $140,000 Annual 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.
Location & working pattern

Burlington, Massachusetts, United States of America

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. 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); and, eligibility for certain tax advantaged savings plans. For a full overview, visit https://hrportal.ehr.com/statestreet/Home.
Work authorization
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

Find answers in the posting

AI
How answers work

AI selects complete passages from this posting. Check them for conditions and exceptions.

Uses this posting and your question. No profile needed.