Shape source-to-target data mapping and warehouse designs as a Data Business Analyst in Toronto, working hybrid with two office days preferred.

With 8-10 years of experience, this position supports data warehousing, ETL processes, and legacy system analysis. You will gather requirements, profile data, document business rules, and prepare models for L2 and L3 processing. Collaboration spans project business analysts, solution architects, data scientists, and IT teams.

Key Responsibilities

Determine operational objectives from business functions and requirements

Prepare data models, mapping documents, and technical designs

Extract undocumented business rules by reviewing legacy code

Review key-cutting processes and obtain schema owner approval

Monitor project progress and recommend corrective actions

Requirements

Eight to ten years of skilled experience

Strong PL/SQL and T-SQL development and optimization skills

Data modelling experience using industry-standard tools and MS Visio

Knowledge of data warehousing concepts, ETL, and mappings

Experience leading requirements sessions and stakeholder workshops

Bring data modelling, SQL, ETL, and stakeholder analysis capabilities to complex Toronto data warehouse programs.

📌 Data Warehousing Business Analyst Toronto (Winnipeg)
🏢 Astra North Infoteck
📍 Winnipeg