Data Analyst, Investment Data Architecture

Connor, Clark & Lunn Financial Group (CC&L); Vancouver; Hybrid; CAD 85,000 - 120,000; Full time

Benefits offered by this job

Flexible work practices

Professional development support

Competitive compensation & benefits

Job summary

Connor, Clark & Lunn Financial Group seeks a Data Analyst for the Investment Data Architecture team in Vancouver. You will translate business needs into data requirements and build trusted datasets, models, and governance artifacts to support data products across assets.

You’ll partner with stakeholders, define quality rules, document lineage, and contribute to strategic data projects. Hybrid work arrangement with in-office and remote days.

Qualifications

• Degree in Finance, Commerce, Business Analysis or related field.
• 3–5 years in investment management or financial services.
• Experience with data management concepts and data products.
• Ability to elicit requirements and translate to clear specs.

Responsibilities

• Partner with stakeholders to understand data needs and translate into requirements and rules.
• Define and prepare trusted investment datasets using agreed standards.
• Develop conceptual and logical data models with business owners and tech partners.
• Collaborate to define transformation rules and source-to-target mappings.
• Define data quality rules and analyze data quality issues.
• Document data models, mappings, flows, and lineage for governance.
• Contribute to strategic data projects with testing and release validation.
• Identify opportunities to improve usability and efficiency.

Skills

SQL

Python

Data modeling

Data governance

Communication

Education

Bachelor's degree in Finance, Commerce, Business Analysis, or related field

Tools

Lakehouse architecture

PySpark

Microsoft Fabric

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

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