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
Deliverable
production ML models | product features | dashboards & analysis
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, Azure cloud migration, 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; Produce clear business requirement documents, functional specifications, source-to-target mappings, and acceptance criteria; Analyze current-state ETL workflows to identify gaps and define practical improvements; Partner with QA to define test scenarios and data validation approaches; Assist implementation and operations teams in troubleshooting integration issues and supporting root-cause analysis.
Seniority
Senior, hands-on IC
