Business Analyst - Data Integration and ETL, AVP
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 technology / Investment management
Required skills
Business analysis, ETL concepts, SQL, financial data domains, requirements documentation, stakeholder communication, Agile delivery, data validation, root-cause analysis
Preferred skills
Investment management platforms, Pentaho Kettle, Talend, cloud migration analysis, Azure, Snowflake, SQL Server, Oracle, data warehousing, data governance
Technologies
Pentaho Kettle, Talend, SQL, Azure, Snowflake, SQL Server, Oracle
Responsibilities
Research, analyze, and document business and functional requirements for data integration and ETL workflows; Partner with engineering teams to translate business needs into implementable ETL design details; Analyze current-state ETL workflows to identify gaps and define improvements; Produce clear business requirement documents, functional specifications, source-to-target mappings, and acceptance criteria; Support QA in defining test scenarios and data validation approaches; Assist implementation teams in troubleshooting integration issues and root-cause analysis.
Seniority
Senior, hands-on IC