Find work in Canada.

563,290 jobs across our Canadian network. How we count

Jobs in Canada

25+ jobs

Email me new jobs Save this search

Added 1 min ago
R
Business Analyst
Raise
Calgary, AB
- Full-time
Added 1 min ago
S
Analyst, Buyer
SaskPower
Regina, SK
- Full-time
Added 1 min ago
MF
Commercial Sales Training Manager
McCain Foods
Toronto, ON
- Full-time
Partner with Sales, Marketing, Category, HR, Commercial Analytics, and Digital teams to align capability development with business priorities.
Added 1 min ago
A
Project Manager - Space & Defense Programs
ABB
Quebec, QC
- Full-time
ABB Measurement and Analytics designs, manufactures and markets near- and mid-infrared analytical systems for the petroleum, chemistry, life sciences, semiconductors, academic and…
Added 1 min ago
KR
Senior Business Analyst - Payments
KTek Resourcing
Toronto, ON
- Full-time
Data Analytics: Ability to analyze payment transaction data, validate requirements, identify discrepancies, and support reconciliation and reporting.
Added 1 min ago
T
Business System Analyst
Tekshapers
Toronto, ON
- Full-time
Added 1 min ago
L
5760 - Seasonal Sales Help
Lids
Medicine Hat, AB
- Temporary
…criminal record information, and demographic data used for analytics and…
Added 1 min ago
L
7752 - Seasonal Sales Help
Lids
Lethbridge, AB
- Temporary
…criminal record information, and demographic data used for analytics and…
Added 1 min ago
F
Spécialiste, Rémunération globale (avantages sociaux et rémunération) / Total Rewards Specialist (benefits & compensation)
Fasken
Toronto, ON
- Full-time
Added 1 min ago
L
7765 - Seasonal Sales Help
Lids
Lethbridge, AB
- Temporary
…criminal record information, and demographic data used for analytics and…
Added 1 min ago
IG
EDI Developer
Insight Global
Toronto, ON
- $50 to $65 CAD / hour
- Contract
Added 1 min ago
F
Spécialiste, Rémunération globale (avantages sociaux et rémunération) / Total Rewards Specialist (benefits & compensation)
Fasken
Montreal, QC
- Full-time
Added 1 min ago
B
Senior Financial Analyst
Brookfield
Toronto, ON
- Full-time
Added 1 min ago
TI
Customer Supply Chain Analyst
Techtronic Industries Canada Inc. - TTI Canada
Toronto, ON
- Full-time
Added 1 min ago
SF
Corporate Actions & Security Master
SGGG Fund Services Inc.
Toronto, ON
- $55,000 to $60,000 CAD / year
- Full-time
Added 1 min ago
D
Consultant/Senior Consultant, Anaplan
Deloitte
Toronto, ON
- Full-time
Added 1 min ago
O
Senior Digital Strategy and Growth Manager
Okta
Toronto, ON
- $140,000 to $192,000 CAD / year
- Full-time
Added 1 min ago
D
Manager, DT&PMI , Operational Due Diligence
Deloitte
Toronto, ON
- Full-time
Added 1 min ago
PI
Senior Database Reliability Engineer
PENN Interactive
Canada
- Full-time
Added 1 min ago
RI
IT Cloud Data Engineer
Rivago Infotech Inc
Toronto, ON
- Contract
· Experience with Cloud based data architectures, messaging, and analytics.
Added 1 min ago
YU
Communication and Engagement Specialist
York University
Toronto, ON
- Full-time
…Microsoft Dynamic CRM, Symplicity or other software), and Google…
Added 1 min ago
MC
Supply Chain Analyst
Masco Canada
St. Thomas, ON · Masco Canada - St. Thomas
- Full-time
Supply Chain Analytics, Insights, & Reporting
Added 1 min ago
AM
Procurement Assistant Manager, Facilities
A.P. Moller - Maersk
Mississauga, ON
- Full-time
Added 1 min ago
MC
Supply Chain Analyst
Masco Corporation
St. Thomas, ON · Masco Canada - St. Thomas
- Full-time
Supply Chain Analytics, Insights, & Reporting
Added 2 mins ago
MM
Supply Chain Supervisor
Mohawk Medbuy Corporation
Kingston, ON
- $71,757 to $84,101 CAD / year
- Full-time

The Essence Group

FinTech Data Engineer: Claude AI Workflow for Form ADV & FINTRX Analytics

Canada

Contract

Apply About employer

Applications open in a new tab.

Job details

Job type: Contract
Experience: Seniority: 5+ years of experience in Python Data Engineering and Software Architecture; 2+ years of hands-on production experience orchestrating LLM APIs.
Posting language: English
Posted: Nov 2, 2026

Original job description

We are seeking an expert Senior FinTech Data Engineer / AI Developer based in Canada or the United States to architect and build a repeatable, highly resilient wealth-management research workflow.

The objective of this project is to eliminate manual research by identifying Registered Investment Advisors (RIAs) showing documented structural or operational pressures (e.g., fee complexity, platform fragmentation, or capacity constraints) that an institutional platform or a larger RIA could address. Note: Predicting or assessing whether an owner wants to move is strictly out of scope.

This requires an engineer who can blend strict programmatic Python data pipelines with non-deterministic LLM document extraction.

Required Workflow & Technical Scope

Starting with a raw FINTRX Excel export file, the automated system must execute the following pipeline:

Automated Document Retrieval: Dynamically extract CRD identifiers from the spreadsheet, handle SEC/IAPD connection protocols safely (respecting rate limits), and fetch the corresponding Form ADV Part 1 (JSON/XML data) and Part 2A Brochures (Narrative PDFs).
Claude-Driven Data Reconciliation: Leverage the Claude API (via structured Tool Use / Function Calling) to parse the narrative prose of Part 2A brochures, cross-reference data against Part 1 fields, and reconcile findings directly against the initial FINTRX records.
Non-Destructive Excel Automation: Programmatically update a multi-sheet master workbook (using openpyxl, xlwings, etc.). The script must preserve original values and dynamically flag discrepancies, missing fields, or target mismatches via a clean exception logging framework.
Screening & Scoring Engine: Implement deterministic data logic to score and rank RIAs based on core proxies for operational pressure (such as account-to-advisor bottlenecks, tech stack fragmentation, or stagnant asset growth metrics).
Data Integrity & Logic Separation: Force the AI pipeline to rigorously isolate verified regulatory facts from logical targeting hypotheses within the generated target profiles.

Required Qualifications & Experience

Seniority: 5+ years of experience in Python Data Engineering and Software Architecture; 2+ years of hands-on production experience orchestrating LLM APIs.
Domain Expertise: Prior experience working with SEC EDGAR / IAPD systems, mapping Form ADV data, and interpreting wealth management data structures (specifically FINTRX).
Advanced LLM Engineering: Deep understanding of the Claude (Anthropic) API ecosystem, including context window management, system prompt optimization, and forcing deterministic JSON outputs through structural tool use.
Data Architecture: Elite spreadsheet automation skills. You must know how to surgically manipulate, format, and audit Excel files via code without destructive overwrites.
Location Constraints: Must be an independent freelance contractor legally authorized to work and residing in the United States or Canada.

Apply About employer

More about this job

Responsibilities

Build a resilient workflow that retrieves and reconciles Form ADV and FINTRX data, using Python pipelines and Claude to extract information from regulatory documents. Automate non-destructive Excel updates, log discrepancies, and implement deterministic screening and scoring of RIAs based on operational-pressure indicators.

Requirements

Candidates must have at least five years of Python data engineering and software architecture experience, plus at least two years of production experience orchestrating LLM APIs. They need hands-on expertise with SEC EDGAR/IAPD, Form ADV, FINTRX, Claude API structured outputs, and careful Excel automation, and must be independent contractors residing in and authorized to work in the United States or Canada.

Skills

Python Data Engineering
Software Architecture
LLM API Orchestration
Claude API
Structured Tool Use
Function Calling
Prompt Optimization
JSON Data Extraction
SEC EDGAR
IAPD
Form ADV
FINTRX
Excel Automation
openpyxl
xlwings
Data Reconciliation

Visa sponsorship

Not detected in the job text

Keywords

Python
Data Engineering
Software Architecture
Claude API
Anthropic
LLM APIs
Structured Tool Use
Function Calling
Prompt Optimization
Context Window Management
Deterministic JSON
SEC EDGAR
IAPD
Form ADV Part 1
Form ADV Part 2A
FINTRX
Excel Automation
openpyxl
xlwings
PDF Extraction
JSON
XML
Data Reconciliation
Exception Logging
RIA Screening
Scoring Engine
Wealth Management
Financial Services
Data Integrity
Rate Limiting

Report this job