Senior Data Integration Engineer

CC&L Infrastructure; Vancouver; On-site; CAD 150,000; Full time

Job summary

A financial services company in Vancouver is seeking a Senior Data Integration Engineer to design and implement scalable data pipelines and governance systems for AI integration. This role involves optimizing data for autonomous AI systems, ensuring compliance, and collaborating across teams. The successful candidate will have strong skills in SQL and Python, and familiarity with cloud platforms. This position offers a competitive salary of $150,000 along with an annual performance bonus.

Qualifications

• Proven experience building resilient, scalable data pipelines for structured and unstructured datasets.
• Strong skills in SQL, Python, orchestration frameworks.

Responsibilities

• Develop scalable ETL / ELT processes to integrate diverse data from systems.
• Implement controls for security, privacy, compliance, and bias mitigation.
• Build connectors and APIs for AI systems to query and act on enterprise data.

Skills

SQL

Python

Airflow

Prefect

Dagster

Azure

AWS

Data modeling

AI Ethics

Tools

Jenkins

REST

SOAP

Systems Engineering

Service-Oriented Architecture

Java

XML

JSON

Scripting

SFTP

Job description

Overview

Senior Data Integration Engineer

Connor Clark & Lunn Financial Group

Location: Vancouver BC

About the Role

Connor Clark & Lunn Financial Group (CC&LFG) is building an AI Enablement Team to accelerate the responsible adoption of AI across the organization. The Senior Data Integration Engineer will design, build and manage the pipelines, governance controls, and semantic context that power enterprise-wide AI and analytics.

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.

What You’ll 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.
• Ensure guardrails (policy enforcement, escalation paths, human-in-the-loop design) are integrated into pipelines and workflows.

Streamline Knowledge Sharing

• Document integration processes, orchestration patterns and governance standards to ensure reuse and cross-team adoption.
• Provide blueprints for how AI agents interact with structured enterprise data.

Collaborate Across Teams

• Partner with AI Solutions Engineers, governance leads and business stakeholders to embed data integration into AI-driven workflows.
• Drive alignment between technical infrastructure and business value realization from agentic AI.

What You Bring

• Proven 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.
• Familiarity with cloud platforms (Azure, AWS, Microsoft Fabric) and integration with AI / ML services.
• Expertise 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.

Why Join Us

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.

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

About Connor Clark & Lunn Financial Group

At CC&L 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 $155 billion in client assets, providing a diverse range of traditional and alternative investment products and solutions to institutional, high-net-worth and retail clients.

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.

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.

Employment Details

• Hybrid

Required Experience :

Senior IC

Key Skills

APIs, Jenkins, REST, Python, SOAP, Systems Engineering, Service-Oriented Architecture, Java, XML, JSON, Scripting, SFTP

Employment Type :

Full Time

Experience :

years

Vacancy :

J-18808-Ljbffr