Data Business Analyst - Toronto
Location
toronto, on
Job Type
Full-time
Category
Other-General
Posted
June 05, 2026
Location: Toronto, Day 1 Onsite - with 3 days at office.
Role / Skill: Data Business Analyst
Responsibilities
- Design and maintain physical and logical data models for Capital Markets domains, including trade execution, portfolio positions, market data (ticks/pricing), and risk metrics.
- Translate complex financial hierarchies (e.g., fund-of-funds, multi-asset class structures) into optimized Databricks structures.
- Ensure data models support temporal requirements, such as Point‑in‑Time (PIT) analysis and “As‑Of” financial reporting.
- Lead the creation of comprehensive Source‑to‑Target Mapping (STM) documents detailing the journey from legacy financial systems and external providers (Bloomberg, Reuters, Aladdin) to ADLS Gen2.
- Define transformation logic, business rules, and data enrichment steps within STM to guide Data Engineering squads.
- Map data lineage to ensure full traceability for regulatory comp...