AVP Data Integration & ETL Analyst (Azure)

State Street

Burlington (MA)

On-site

USD 80,000 - 140,000

Full time

14 days+

Application generator

An application made for this job — a tailored resume and cover letter that speak straight to the posting.

Get past ATS filters

Job summary

State Street is seeking a Business Analyst – Data Integration and ETL to support data flows, mappings, and ETL designs for investment management data. The role collaborates with Product Owners, engineering, QA, and operations to ensure reliable, scalable data integration aligned with business needs.

A focus on ETL tools like Pentaho Kettle and Talend is required. The ideal candidate brings 4+ years of analysis experience, strong SQL skills, and ability to translate business requirements into

Qualifications

4+ years of business analysis or related experience in financial tech or data integration.
Experience with investment platforms or data integration environments preferred.
Proficient in ETL concepts and SQL, able to document mappings and transformation rules.

Responsibilities

Analyze and document requirements for data integration and ETL workflows.
Collaborate with Product Owner and engineering to define ETL design details.
Translate business needs into user stories, mappings, acceptance criteria.
Work with Pentaho Kettle, Talend, SQL to support ETL design and operations.
Assist QA in defining test scenarios and data validation for ETL workflows.
Support migration planning toward Azure cloud-based platforms.

Skills

ETL

SQL

Documentation

Stakeholder comms

Agile

Data integration

Azure cloud

Education

Bachelor's degree

Tools

Pentaho Kettle

Talend

SQL

Azure

Job description

A focus on ETL tools like Pentaho Kettle and Talend is required. The ideal candidate brings 4+ years of analysis experience, strong SQL skills, and ability to translate business requirements into

Get your free, confidential resume review.

or drag and drop your file here.