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...