CareerPlan

Business Analyst - Data Warehouse & Business Intelligence

Toronto Office, CARemoteFull-time$111k2026-10-28 → 2026-11-11
Hybrid

Core

Translate business needs into data specifications, user stories, and acceptance criteria for the Wealth Management Data Warehouse and BI solutions.

Role type

Senior Business Analyst (Data Warehouse & BI)

Builds

Data marts, ETL pipelines, and dashboards for Wealth Management clients

Domain

Financial Services / Data Warehousing

Required skills

Data warehousing concepts, ETL processes, BI tools (Business Objects, Tableau), SQL, Data modeling, Requirements analysis

Preferred skills

Wealth Management domain knowledge, Data governance frameworks

Technologies

Business Objects, Tableau, SQL, Confluence, Jira, Visio

Responsibilities

Lead discovery and articulation of business requirements for data warehouse and BI solutions; Perform data analysis including source validation, profiling, and quality assessment; Create source-to-target mappings and document transformation logic; Produce documentation for reporting logic and metric definitions; Support data validation and functional testing during QA/UAT phases.

Seniority

Senior, hands-on IC