Business Analyst – Data Integration and ETL
Core
Business Analyst supporting data integration and ETL capabilities, focusing on understanding business needs, documenting requirements, and improving ETL designs for investment management workflows.
Role type
Senior Business Analyst (Data Integration/ETL)
Builds
Data integration workflows, ETL processes, and cloud-based data platforms (Azure)
Domain
Financial services / Investment management / Data Engineering
Required skills
Business analysis, ETL concepts, SQL, Financial data domains, Requirements documentation, User story creation, Data validation, Agile delivery, Stakeholder communication
Preferred skills
Investment management platforms, Pentaho Kettle, Talend, Cloud migration (Azure), Snowflake, SQL Server, Oracle, Data warehousing, Data governance
Technologies
Pentaho Kettle, Talend, SQL, Azure, Snowflake, SQL Server, Oracle
Responsibilities
Research and document business/functional requirements for ETL workflows; Partner with engineering to translate needs into ETL design details; Analyze current-state workflows and define improvements; Produce mapping documents, transformation rules, and acceptance criteria; Support QA in defining test scenarios and data validation; Troubleshoot integration issues and support root-cause analysis; Collaborate with globally distributed teams in Agile environments.
Seniority
Senior, hands-on IC