Data Engineer

NS Partners; Vancouver; Hybrid; CAD 120,000 - 130,000; Full time

Job summary

A leading asset management firm is seeking a Data Engineer in Vancouver to design and build data pipelines for AI integration. This role involves developing robust processes for integrating structured and unstructured data, implementing data governance measures, and ensuring AI systems are reliable and secure. Ideal candidates will have strong SQL and Python skills with cloud platform experience. The position operates on a hybrid model with competitive compensation including an annual performance bonus.

Qualifications

• 2+ years' experience building resilient, scalable data pipelines.
• Strong skills in SQL, Python, and orchestration frameworks.
• Experience with cloud platforms and integration with AI/ML services.

Responsibilities

• Develop scalable ETL/ELT processes for data integration.
• Implement controls for security, privacy, compliance, and bias mitigation.
• Enrich datasets with semantic context and metadata.

Skills

SQL

Python

Airflow

Prefect

Dagster

Tools

Azure

AWS

Microsoft Fabric

Job description

Interested in joining one of Canada's top performing asset managers? We are looking for a Data Engineer for an existing vacancy in our IT department, Connor, Clark & Lunn Financial Group (CC&LFG) is building an Data Integration & AI Enablement Team to accelerate the responsible adoption of AI across the organization. The Data Engineer will design, build, and manage the pipelines, governance controls, and semantic context that power enterprise-wide AI and analytics. At CC&LFG, you will help lay the foundation for agentic AI in financial services — designing the data, governance, and orchestration systems that make AI reliable, explainable, and enterprise-ready. You’ll work on cutting‑edge AI pipelines, enabling the business to move from AI‑assisted insights to AI‑driven autonomous workflows. This role goes beyond integration: it ensures data is optimized for autonomous and agentic AI systems that can plan, act, and adapt dynamically within guardrails. You will create the trusted foundation on which AI agents, copilots, and orchestration frameworks securely operate. Our offices currently operate on a hybrid model with three days in office.

What You Will Do

Design & Build Pipelines

• Develop scalable ETL/ELT processes to integrate structured, semi-structured, and unstructured data from diverse systems (applications, APIs, databases).
• Enable real‑time and event‑driven data flows to support autonomous agent decision‑making.

Safeguard Data & Governance

• Implement robust controls for security, privacy, compliance, and bias mitigation.
• Establish observability and audit trails for agentic AI pipelines, ensuring transparency and accountability.

Enable AI & Agentic Readiness

• Enrich datasets with semantic context and metadata to power LLM ingestion, RAG pipelines, embeddings, and multi‑agent collaboration.
• Build connectors and APIs that allow agentic AI systems to dynamically query, retrieve, and act on enterprise data.
• Support workflow orchestration across AI agents and business systems.

Operationalize Agentic AI

• Develop feedback loops and monitoring systems to detect drift, hallucinations, or risk in autonomous AI actions.
• Document integration processes, orchestration patterns, and governance standards to ensure reuse and cross‑team adoption.
• Drive alignment between technical infrastructure and business value realization from agentic AI.

What You Bring

• 2+ years’ experience building resilient, scalable data pipelines for structured and unstructured datasets.
• Strong skills in SQL, Python, orchestration frameworks (Airflow, Prefect, Dagster) and modern data transformation tools.
• Experience with cloud platforms (Azure, AWS, Microsoft Fabric) and integration with AI/ML services.
• Experience in data modeling, semantic enrichment, embeddings, and vector databases for LLM/RAG pipelines.
• Understanding of agentic AI concepts: workflow orchestration, autonomous decision‑making, human‑in‑the‑loop design, and safety guardrails.
• Knowledge of data governance practices including AI ethics, security, privacy, compliance, and auditability.
• Ability to collaborate with engineers, AI product teams, and business leaders to make enterprise data agent‑ready.

The salary range for this position is $120,000 - $130,000. The salary range provided reflects the base salary range for this position as required by legislation. In addition, there is an annual performance bonus which contributes to the total compensation for this position. Further questions may be directed to the HR team during the interview process.

About Connor, Clark & Lunn Financial Group

At Connor, Clark & Lunn Financial Group, we understand the value of opportunity – for our clients and our team. Independent and employee‑owned, we partner with investment professionals to grow successful asset management businesses, giving them the space to innovate and truly make an impact.

With more than 40 years of history and offices across Canada and in the US, the UK and India, CC&L Financial Group and our multi‑boutique family of affiliate firms collectively manage over CAD$179 billion in assets, providing a diverse range of traditional and alternative investment products and solutions to institutional, high‑net‑worth and retail clients.

For a closer look at how you can build your career with us, we invite you to explore cclgroup.com.

CC&L Financial Group is committed to creating a diverse and inclusive environment and is proud to be an equal opportunity employer. All qualified applicants will receive consideration for employment without regard to gender, ethnicity, religion, sexual orientation or expression, disability, or age.

To apply for this position, please submit your resume and cover letter as one PDF. Your application will be reviewed by a member of the hiring team – AI is not used in the screening, assessment or selection of applications at this time.

We thank all applicants in advance for their interest, but only those candidates shortlisted for interviews will be contacted. No telephone calls or recruitment agencies will be accepted.