Business Analyst – Data Integration and ETL, AVP

State Street • Burlington, MA

11d • $80,000 - $140,000

About The Position

The Business Analyst, AVP supports data integration and ETL capabilities by understanding business needs, documenting requirements, and helping improve existing and new ETL designs. The role works with the Product Owner, business stakeholders, engineering, QA, implementation, operations, and support teams to ensure data flows are clearly defined, supportable, and aligned with operational needs.

The position supports integrations using tools such as Pentaho Kettle and Talend, covering source-to-target mapping, data transformation rules, validation, exception handling, and production support considerations. It also supports migration planning and analysis as data integration and ETL capabilities evolve toward Azure cloud-based platforms. The successful candidate bridges business users, Product Owners, and technical teams, translating requirements into user stories, functional specifications, mapping documents, acceptance criteria, and delivery-ready documentation.

Requirements

• At least 4 years of business analysis, product analysis, systems analysis, or implementation/support experience in financial technology, investment management, enterprise applications, or data integration environments.
• Working knowledge of ETL concepts and tools, especially Pentaho Kettle and/or Talend; similar ETL or data integration platform experience 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 analyzing queries, understanding joins, validating data, and supporting 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 reconciling conflicting data, identifying gaps, validating assumptions, and working 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.
• Comfort 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.
• Bachelor’s degree in Finance, Business, Information Systems, Computer Science, Engineering, Mathematics, Data Analytics, or a related field, or equivalent practical experience in financial services, ETL analysis, platform support, or data integration delivery.

Nice To Haves

• Experience supporting investment management platforms, enterprise financial services systems, or comparable data integration environments.
• Familiarity with data warehousing, reporting dependencies, data governance, metadata, lineage, or auditability concepts.
• 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, especially for ETL migration, reporting, or data integration use cases.

Responsibilities

• Research, analyze, and document business and functional requirements for data integration and ETL workflows.
• Work with the Product Owner to understand priorities, clarify scope, and support design decisions for existing ETL processes and new enhancements.
• Support platform-related data flows, including inbound feeds, outbound data distribution, transformations, validations, and downstream consumption.
• Produce business requirement documents, functional specifications, source-to-target mappings, transformation rules, user stories, acceptance criteria, and workflow documentation.
• Partner with engineering teams using 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 improvements to reliability, supportability, and business alignment.
• Participate in design discussions for enhancements to existing ETL jobs and new ETL workflows supporting 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 with 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 scope, requirements, risks, dependencies, decisions, trade-offs, and delivery progress to stakeholders.

Benefits

• Retirement savings plan (401K) with company match.
• Insurance coverage including basic life, medical, dental, vision, long-term disability, and optional additional coverages.
• Paid time off, including vacation, sick leave, short-term disability, and family care responsibilities.
• Employee Assistance Program.
• Incentive compensation, including eligibility for annual performance-based awards, with exclusions for certain sales roles subject to sales incentive plans.
• Eligibility for certain tax-advantaged savings plans.
• Flexible Work Program and flexible work-life support.
• Development programs and educational support.
• Paid volunteer days, matching gift programs, and access to employee networks.

What This Job Offers

• Job Type: Full-time
• Career Level: Mid Level