Data Analyst, Investment Data Architecture

Connor, Clark & Lunn group; Toronto; Hybrid; CAD 85,000 - 120,000; Full time

Benefits offered by this job

Competitive compensation

Retirement savings

Wellness credits

Enhanced parental leave

Health benefits

Job summary

Connor, Clark & Lunn Financial Group is seeking a Data Analyst for the Investment Data Architecture team in a hybrid Toronto-based role. You will translate stakeholder needs into data definitions and acceptance criteria, helping build trusted investment datasets and data products.

You will develop conceptual and logical data models with business and technical partners, define data quality rules, and validate data transformations.

Qualifications

• Degree in Finance, Commerce, Business Analysis or related field.
• Progress toward CFA/FRM is an asset.
• 3–5 years of experience in investment management or financial services.
• Hands-on knowledge of equity, fixed income, or derivatives data.
• Experience with Security Master, Pricing, or EDM platforms is a plus.
• SQL is an asset; familiarity with Python, PySpark, Lakehouse architecture, Microsoft Fabric or similar data platforms is a plus.

Responsibilities

• Partner with investment and operations stakeholders to understand data needs and translate them into requirements, data definitions, and acceptance criteria.
• Define and prepare trusted investment datasets (data products) using standards and stewardship.
• Develop conceptual and logical investment data models with business and technical partners.
• Collaborate with data engineers to define data transformation rules and source-to-target mappings.
• Define data quality rules and analyze data-quality exceptions and reconciliation breaks.
• Serve as SME on security master, pricing, holdings and reference data across asset classes.
• Document data models, mappings, data flows and lineage information.
• Contribute to strategic data projects with requirements, testing, and release validation.

Skills

SQL

Python

PySpark

Lakehouse

Microsoft Fabric

Education

Finance/Commerce/Business Analysis degree

CFA/FRM designation in progress

Tools

Data Modeling tools

ETL/ETL tools

Job description

Interested in joining one of Canada's top-performing asset managers? We are looking for a Data Analyst for an existing vacancy in our Investment Data Architecture (IDArch) team. Our team resides within the middle office and enables the organization to get more value from its investment data. We lead Modern Data Platform (MDP) enablement for the investment data domain, set the standards and governance that help business teams own and build trusted data products, and act as primary owners of the Investment Data Management platform, including security master, pricing master, and market reference data. We place high value on maintaining an entrepreneurial spirit and creating a culture where each of us has opportunities to succeed. This is a fantastic opportunity to be part of a dynamic strategic team whose scope and influence are growing enterprise-wide. Our offices currently operate on a hybrid model with a combination of in office and remote working days throughout the week.What You Will DoPartner with investment and operations stakeholders to understand their data needs, and translate them into clear business requirements, data definitions, business rules, and acceptance criteria for the technical team.Support business data owners in defining and preparing trusted, reusable investment datasets (data products) through intake, definition and readiness using agreed standards, and contribute to ongoing stewardship and lifecycle reviews.Develop conceptual and logical investment data models with business owners and technical partners and explain them clearly to technical and non-technical stakeholders.Collaborate with data engineers and business teams to define and validate business transformation rules and source-to-target mappings and confirm that delivered data meets business expectations.Work with data owners and stewards to define data quality rules and critical data elements and analyze data-quality exceptions and reconciliation breaks.Act as a subject-matter resource on security master, pricing, holdings and reference data across equity, fixed income, and derivatives, ensuring consistency across systems.Document data models, mappings, data flows and business processes, and contribute business glossary terms, data definitions and lineage information to support transparency and governance.Contribute to strategic data projects – including requirements, testing, and release validation – in collaboration with operations, engineering, and senior management.Identify opportunities to improve investment data usability, consistency and operational efficiency.What You BringA degree in Finance, Commerce, Business Analysis, or a related field. Progress toward a designation such as the CFA or FRM is an asset.3–5 years of experience 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; experience with security master, pricing, or an Enterprise Data Management (EDM) platform is a plus.Proven ability to elicit requirements, run working sessions, and turn ambiguous business needs into clear, documented requirements and acceptance criteria.SQL is an asset; familiarity with Python, PySpark, Lakehouse architecture, Microsoft Fabric or similar data platforms is a plus.Exposure to conceptual or logical data modeling, or experience defining data entities, relationships and business rules, is an asset.Understanding of data quality, data ownership, data governance and metadata concepts.Excellent written and verbal communication skills, with the ability to explain data concepts to business users and business needs to technical teams.A curious, detail-oriented self-starter who takes initiative and delivers outcomes with measurable results.The expected base salary range for this position is $85,000–$120,000. The midpoint represents our general market target for a fully qualified and experienced individual performing the role. Actual starting salary may fall below or above the midpoint depending on the candidate's relevant experience, skills and qualifications, as well as internal equity considerations. Further questions may be directed to the HR team during the interview process.#LI-HYBRID #LI-JB1What We OfferAt Connor, Clark & Lunn Financial Group, we're \"invested in our greatest asset, you\". Our shared goals reflect what matters most to our people:Your community: we foster belonging through collaboration, inclusion and flexibility. Enjoy social events, volunteering and a strong commitment to corporate social responsibility. Our flexible work practices are designed to support work-life balance and provide employees with flexibility in where and how they workYour growth: we prioritize your development with meaningful work, continuous learning budgets, paid study days and support for professional designations.Recognizing you: your contributions are rewarded with competitive total compensation, retirement savings support, wellness credits, enhanced parental leave, and comprehensive health benefits.For a closer look at how you can build your career with us, we invite you to explore cclgroup.com.We are committed to providing an inclusive, accessible recruitment and selection process. We welcome and encourage applications from people with disabilities. Accommodations are available on request for candidates taking part in all aspects of the recruitment and selection process. Please contact [e-mail] if you require accommodation.AI may be used to support certain stages of our screening & recruitment process. These tools support, but do not replace, human judgment and decision-making.