Data Analyst, Investment Data Architecture

Role overview

What you will do

• Translate investment and operations data needs into requirements, definitions, business rules and acceptance criteria.
• Support preparation of trusted reusable investment datasets and ongoing stewardship and lifecycle reviews.
• Develop conceptual and logical data models with business owners and technical partners.
• Define and validate transformation rules and source-to-target mappings; verify delivered data against business expectations.
• Define data-quality rules and critical data elements, and analyze data-quality exceptions and reconciliation breaks.
• Provide subject-matter support for security master, pricing, holdings and reference data across asset classes.
• Document models, mappings, flows and processes; contribute glossary, definition and lineage information.
• Contribute to strategic data projects, requirements, testing and release validation.
• Identify improvements to investment data usability, consistency and operational efficiency.

What you bring

• Degree in Finance, Commerce, Business Analysis or a related field; CFA or FRM progress is an asset.
• 3–5 years in investment management or financial services, ideally in investment data, investment operations or business analysis.
• Hands-on knowledge of equity, fixed-income or derivative data; security master, pricing or EDM platform experience is a plus.
• Ability to elicit requirements, run working sessions and document requirements and acceptance criteria.
• SQL is an asset; Python, PySpark, Lakehouse architecture and Microsoft Fabric or similar platforms are a plus.
• Data modeling exposure is an asset; understanding of data quality, ownership, governance and metadata is expected.
• Strong written and verbal communication, curiosity, attention to detail and initiative.

Compensation

• Expected base salary range is CAD 85,000–CAD 120,000; actual starting salary depends on experience, skills, qualifications and internal equity.

Benefits

• Flexible work practices, social events, volunteering and corporate social responsibility opportunities.
• Development support includes learning budgets, paid study days and professional designation support.
• Compensation and benefits include retirement savings support, wellness credits, enhanced parental leave and health benefits.