Data Analyst, Investment Data Architecture
Role Overview
Data Analyst vacancy on the Investment Data Architecture team within the middle office.
The team enables investment-data use, supports Modern Data Platform enablement, establishes standards and governance, and owns investment data management platforms including security master, pricing master, and market reference data.
The team operates on a hybrid model with in-office and remote workdays.
Key Skills for This Role
Full Job Posting
Role overview
Data Analyst vacancy on the Investment Data Architecture team within the middle office.
The team enables investment-data use, supports Modern Data Platform enablement, establishes standards and governance, and owns investment data management platforms including security master, pricing master, and market reference data.
The team operates on a hybrid model with in-office and remote workdays.
What you will do
- Translate investment and operations stakeholders' data needs into business requirements, definitions, rules, and acceptance criteria.
- Help business data owners define and prepare trusted, reusable investment data products and support stewardship and lifecycle reviews.
- Develop investment data models and explain them to technical and non-technical stakeholders.
- Define and validate transformation rules and source-to-target mappings; confirm delivered data meets business expectations.
- Define data quality rules and critical data elements; investigate quality exceptions and reconciliation breaks.
- Advise on security master, pricing, holdings, and reference data across equities, fixed income, and derivatives.
- Document models, mappings, flows, processes, glossary terms, definitions, and lineage.
- Support strategic data projects through requirements, testing, and release validation; identify improvements to usability, consistency, and efficiency.
What you bring
- Degree in Finance, Commerce, Business Analysis, or a related field.
- 3–5 years in investment management or financial services, ideally in investment data management, investment operations, or business analysis.
- Hands-on knowledge of equity, fixed-income, or derivative data is required.
- Ability to elicit requirements, facilitate working sessions, and document requirements and acceptance criteria.
- Understanding of data quality, ownership, governance, and metadata concepts.
- Strong written and verbal communication skills; curious, detail-oriented, self-starting, and focused on measurable outcomes.
- CFA or FRM progress is an asset. Security master, pricing, or EDM platform experience is a plus.
- SQL is an asset; Python, PySpark, Lakehouse architecture, Microsoft Fabric, similar platforms, and conceptual or logical data modeling are listed as assets or pluses.
Base salary
- Expected base salary range is $85,000–$120,000; actual starting salary may vary with experience, skills, qualifications, and internal equity.
Benefits and development
- The employer describes flexible work practices, professional development budgets, paid study days, designation support, retirement savings support, wellness credits, parental leave, and health benefits.
Apply for this job in 1 click
Skip the repetitive application forms
Install the Base Career Chrome Extension and autofill job applications across major job boards with your profile.
Trusted by over 500,000 job seekers on Base Career
More from this employer
More jobs at Connor, Clark & Lunn Financial Group
Senior Analyst, Client Reporting Development Team
Toronto, CAN
The employer is seeking a Senior Analyst to develop and maintain client reporting solutions, guide system design, and support operational teams. The role requires hands-on experience developing or maintaining code-based
Senior Analyst, Client Reporting Development Team
Vancouver, CAN
CC&L is seeking a Senior Analyst to develop, maintain, and improve its client reporting solutions and workflows. Candidates need three to four years of related experience, an undergraduate degree, and hands-on experience
Compliance Specialist
Toronto, CAN
Connor, Clark & Lunn Financial Group is seeking a Compliance Specialist to support its Private Capital Compliance team and provide regulatory guidance. The role covers filings, client and employee reviews, compliance con
Data Analyst, Investment Data Architecture
Vancouver, CAN
Connor, Clark & Lunn is seeking a Data Analyst for its Investment Data Architecture team to define, model, govern and improve investment data products. Candidates need 3–5 years in investment management or financial serv
Analyst, Business Process Engineering, Investment Data Architecture
Vancouver, CAN
The Investment Data Architecture team seeks an analyst with 3+ years of relevant experience to improve investment data processes and support trusted data products. You will map workflows, identify risks and improvement o
Analyst, Sales & Client Enablement - 12 Month Contract
Toronto, CAN
CC&L Financial Group is seeking a detail-oriented analyst to automate sales and client materials using Seismic. The role builds and tests dynamic documents and templates, and requires strong PowerPoint, Word, Excel, stru
Senior Analyst, Client Reporting Development Team
Vancouver, CAN
Senior Analyst, Client Reporting Development Team
Toronto, CAN
Senior Analyst, Client Reporting Development Team
Vancouver, CAN
Intern, Investment Analytics Engagement
Vancouver, CAN
Compliance Specialist
Toronto, CAN
Data Analyst, Investment Data Architecture
Vancouver, CAN
Analyst, Business Process Engineering, Investment Data Architecture
Vancouver, CAN
Analyst, Sales & Client Enablement - 12 Month Contract
Toronto, CAN