RiseMe
Connor, Clark & Lunn Financial Group logo
Connor, Clark & Lunn Financial Group Verified
Financial Services, Asset Management

Data Analyst, Investment Data Architecture

Toronto, ONHybridFull TimeCA$85,000–CA$120,000 /yrPosted 18 days ago

Is this role right for you?

Upload your resume and get a skill-by-skill breakdown — see exactly where you match, where you're close, and what to highlight. Not a mystery percentage.

Get a tailored resume highlighting what this role needs.

Required skills

  • Investment Data Architecture
  • Investment Data Management
  • Business Analysis
  • Data Quality
  • Data Governance
  • equity
  • fixed income
  • derivatives
  • security master
  • pricing

Nice to have

  • CFA
  • FRM
  • SQL
  • Python
  • PySpark
  • Lakehouse architecture

Role summary

A Data Analyst is sought for the Investment Data Architecture (IDArch) team within the middle office of a leading Canadian asset manager. This role focuses on enabling greater value from investment data by leading Modern Data Platform (MDP) enablement, setting data standards and governance, and managing the Investment Data Management platform. Responsibilities include partnering with stakeholders to define business requirements and data products, developing data models, collaborating on data transformations, defining data quality rules, and documenting data processes. The ideal candidate will have 3-5 years of experience in investment management or financial services, with hands-on knowledge of equity, fixed income, or derivative data, and proven business analysis and data modeling skills. Familiarity with SQL, Python, and data platforms is a plus.

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 Do

  • Partner 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 Bring

  • A 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-JB1

    What We Offer At 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 work
  • Your 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 talentacquisition@cclgroup.com 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.

    Ready to apply?
    You'll be redirected to Connor, Clark & Lunn Financial Group's application page.

    Similar roles

    See how RiseMe works

    Match, tailor, and prep so you send fewer applications and land more interviews.