Senior Data Integration Engineer

Connor, Clark & Lunn Financial Group Ltd.; Toronto; Hybrid; CAD 140,000 - 160,000; Full time

Benefits offered by this job

Health benefits

Flexible work

Paid study days

Professional designations

Job summary

Connor, Clark & Lunn Financial Group is seeking a Senior Data Integration Engineer to design, build and govern pipelines that power enterprise-wide AI and analytics. You will enable real-time data flows for autonomous AI decision-making, while enforcing security, privacy, and bias controls.

The role emphasizes semantic enrichment, embeddings, and integration with AI/ML services, plus designing governance and auditability across pipelines. Hybrid in-office model applies.

Qualifications

• Proven experience building resilient, scalable data pipelines for structured and unstructured datasets.
• Strong SQL and Python skills with experience in orchestration frameworks.
• Familiarity with cloud platforms (Azure, AWS, Microsoft Fabric) and AI/ML data integration.
• Expertise in data modeling, semantic enrichment, embeddings, and vector databases for LLM/RAG pipelines.
• Understanding of agentic AI concepts: orchestration, autonomous decisions, human-in-the-loop, safety guardrails.
• Knowledge of data governance practices including AI ethics, security and privacy.

Responsibilities

• Design and build scalable ETL/ELT pipelines to integrate data from diverse systems.
• Enable real-time and event-driven data flows to support autonomous agent decision-making.
• Implement robust controls for security, privacy, compliance, and bias mitigation.
• Establish observability and audit trails for AI pipelines to ensure transparency.
• Enrich datasets with semantic context and metadata for LLM ingestion and RAG pipelines.
• Build connectors and APIs for agentic AI to query, retrieve, and act on data; support orchestration.
• Develop monitoring and feedback loops to detect drift or risk in autonomous AI actions.
• Document integration patterns and governance standards for reuse across teams.
• Collaborate with AI Solutions Engineers and business stakeholders to embed data into workflows.

Skills

SQL

Python

Data pipelines

Data integration

Agentic AI concepts

Data governance

AI ethics

Collaboration with engineers

Tools

Airflow

Prefect

Dagster

Azure

AWS

Microsoft Fabric

Job description

Interested in joining one of Canada’s top performing asset managers? We are looking for a Senior Data Integration Engineer for an existing vacancy in our IT department, 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. 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. 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.

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

The salary range for this position is $140,000 - $160,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.

#LI-hybrid #LI-KC1

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.