AI Data and Integration Engineer

First National Financial LP; Toronto; On-site; CAD 95,000 - 130,000; Full time

Benefits offered by this job

Benefits program

Training programs

Modern office environment

Job summary

First National Financial LP is hiring an AI Data and Integration Engineer to own end-to-end data and integration delivery for AI-enabled mortgage workflows. You will design, build, test, and operate data and integration components across Merlin, SQL Server sources, document stores, and enterprise services.

The role emphasizes secure APIs, data governance, and batch/real-time pipelines using Databricks and Azure.

Qualifications

• Bachelor’s degree or equivalent in computer science or related field.
• 5+ years in data/integration/software/cloud engineering roles.
• Strong hands-on experience with Python, SQL, APIs, ETL/ELT pipelines, data modeling, testing, Git, CI/CD, cloud services, production support.
• Experience with Azure, Databricks, Delta Lake, Unity Catalog, Lakeflow or orchestration tools, SQL Server, API Management, Key Vault, Entra ID, and infrastructure automation preferred.
• Experience designing data contracts, mappings, canonical models, event-driven interfaces, lineage, data quality controls, and integration with legacy interfaces.
• Ability to build resilient, scalable, secure integrations with observability and cost considerations.

Responsibilities

• Design, build, test, and operate data and integration components for AI-enabled mortgage workflows.
• Own end-to-end integration accountability across Merlin, SQL Server sources, repositories, and services.
• Translate requirements into source-to-target mappings and data contracts with cross-functional teams.
• Build and maintain governed batch and near real-time pipelines using Databricks and Azure.
• Develop and maintain secure APIs and event integrations with modern tooling and CI/CD.
• Implement data quality, privacy, and governance controls across data pipelines.
• Support AI engineers with reliable interfaces, diagnose failures, and improve pipelines.

Skills

Python

SQL

APIs

ETL/ELT

Data modeling

CI/CD

Cloud services

Databricks

Azure

Data governance

Education

Bachelor’s degree in computer science, software engineering, data engineering, information systems or a related discipline

Tools

Databricks

Azure

Delta Lake

Unity Catalog

Lakeflow

SQL Server

Azure Service Bus

API Management

Key Vault

Job description

Reporting To

Assistant Vice President IT, Application Development

We are hiring an AI Data and Integration Engineer, Application Development!

Full-Time/Part- Time

Full-time

Posting Date

August 21 2026

Closing Date

September 21 2026

Hours Of Work

8:30 a.m. – 5:00 p.m.

Grade

Office Location:

14.4

Toronto

Great location! Steps away from the main public transit station

What We Offer

• Eligibility for benefits is dependent on the terms of employment

The Opportunity

The AI Data and Integration Engineer reports to the AI Engineering Lead and is the single accountable owner for making trusted, governed data and reliable system connectivity available to First National’s AI enabled mortgage workflows, from design through production.

This is a hands on engineering role within the AI Platform Squad, focused on data contracts, source to target integration with Merlin and enterprise systems, APIs, event integration, document and metadata flows, controlled write back, data quality, lineage, and operational support. This role holds end to end accountability for data and integration delivery, including the batch, service oriented, and legacy interface dependencies that AI enabled underwriting workflows rely on.

How You Will Contribute

• Design, build, test, and operate the data and integration components for AI enabled mortgage workflows, including source ingestion, transformation, enrichment, document metadata, reference data, APIs, event flows, exception handling, and controlled write back to core systems.
• Hold end to end integration accountability for AI use cases across Merlin, SQL Server sources, document repositories, enterprise services, and event backbones, so that integration delivery does not fragment across AI, product, data, and architecture teams.
• Translate workflow, policy, reporting, and operational requirements into source to target mappings, canonical data models, interface contracts, validation rules, reconciliation controls, and traceable data lineage, in partnership with the Merlin Product Owner, the Residential Underwriting Business SME, AI Engineers, and application teams.
• Build governed batch and near real time pipelines using approved First National patterns across Databricks and Azure, including Lakeflow or comparable orchestration, Delta Lake bronze, silver, and gold layers, Unity Catalog, SQL Server, document repositories, and enterprise integration services.
• Develop and maintain secure APIs, services, and event integrations using Python, SQL, FastAPI, .NET or comparable technologies, Azure Service Bus, API Management, Git based workflows, automated tests, CI/CD, and infrastructure as code practices.
• Implement data quality and integration controls, including schema validation, completeness, accuracy, timeliness, duplication, referential integrity, reconciliation, error routing, replay, idempotency, observability, alerting, and audit evidence.
• Apply privacy, security, retention, access control, and data governance requirements to structured and unstructured information, including PII handling, Entra ID, RBAC, Key Vault, private connectivity, logging, and least privilege access.
• Support AI Engineers and full stack engineers with reliable, documented interfaces and representative data, diagnose data and integration failures through development, evaluation, UAT, parallel runs, production releases, incidents, and ongoing monitoring, and refactor partner delivered or prototype pipelines into modular, testable, documented, supportable services, contributing reusable connectors, data contracts, mappings, and engineering patterns back to the AI Factory catalog.

The Experience You Need

• Bachelor’s degree in computer science, software engineering, data engineering, information systems or a related discipline.
• 5 plus years of progressive data engineering, integration engineering, software engineering, cloud engineering, or related technology experience.
• Strong hands on experience with Python, SQL, APIs, ETL or ELT pipelines, data modeling, automated testing, Git based delivery, CI/CD, cloud services, and production support.
• Practical experience with Microsoft Azure, Databricks or comparable data platforms, Delta Lake, Unity Catalog, Lakeflow or comparable orchestration tools, SQL Server, Azure Service Bus, API Management, Key Vault, Entra ID, and infrastructure automation is strongly preferred.
• Experience designing data contracts, source to target mappings, canonical models, event driven interfaces, change data capture, reconciliation, lineage, metadata, data quality controls, and controlled write back to enterprise systems, including integration with legacy, batch, and service oriented interfaces.
• Ability to build resilient integrations with attention to performance, scalability, security, privacy, governance, error handling, replay, idempotency, observability, cost, and operational support.
• Experience collaborating with product owners, domain experts, AI and application engineers, platform teams, enterprise data teams, security, QA, and operations through design, UAT, production release, incident response, and continuous improvement.
• Experience in financial services, mortgage lending, lending operations, servicing, broker channels, third party partnerships, or regulated technology environments is preferred.

Relationships

External: Engages implementation partners, cloud providers, data and AI platform providers, and integration and specialist vendors on interface design, delivery quality, monitoring, production readiness, and knowledge transfer to First National.

Internal: Reports to the AI Engineering Lead within the AI Platform Squad and works closely with the Applied AI Platform Engineer, the AI Quality and Evaluation Lead, and the Technical Product Manager, AI Platform.

Working Environment And Physical Demands Analysis

• Office environment
• Periods of high volume with tight timelines
• Long periods of stationary position/sitting
• Prolonged periods of repetitive movement (i.e. using a keyboard and mouse)
• Long periods of time in viewing a computer screen
• Multi-tasking may include speaking to customers on a telephone call while looking up information on a computer program.

Why join First National?

• Competitive Compensation
• Comprehensive benefits program (i.e., Health Spending Account, Maternity and Parental Leave Top Up)
• Extensive training programs to set our employees up for success
• Modern office environment conducive to collaboration
• Supportive teamwork culture
• Opportunities to give back to the communities and work through events focused on a variety of charities
• Ongoing social events throughout the year

The Team You’ll Join

Founded in 1988, First National is one of Canada’s largest non-bank lenders. We provide residential mortgages exclusively through the mortgage broker channel and we are Canada’s largest commercial mortgage lender.

First National has been consistently recognized as a great place to work and we are proud that our employee engagement feedback is higher than our industry partners.

We would like to thank all applications for their interest in this existing vacancy, but only candidates selected for an interview will be contacted.

Artificial Intelligence is not used in our recruitment or hiring process for this role.

First National is proud to be an equal opportunity employer and is committed to diversity and inclusion regardless of race, color, religion, national origin, age, gender identity, physical or mental disability, sexual orientation and any other category protected by law.

First National supports requests for accommodation from applicants with disabilities; please contact Human Resources at [e-mail] should you need an accommodation at any point in the recruitment process.

#FNLOON