Find work in Canada.

487,534 jobs across our Canadian network. How we count

Jobs in Canada

Email me new jobs Save this search

Added 2 months ago
CP
Application Support Analyst
CAAT Pension Plan
Toronto, ON · Head Office
- Full-time
We are seeking an Application Support Analyst for our Information Technology team. Reporting to the Senior Manager, Enterprise Applications & Service Delivery the Application Support…
Added 3 months ago
C
Architecte de solutions (ServiceNow)
CGI
Sherbrooke, Quebec
- Full-time
…team that includes senior ServiceNow developers, a business analyst, and a QA analyst. In this position, you will be responsible for guiding solution direction, ensuring overall…
Added 2 months ago
FC
Robotics Process Analyst (Multiple Openings)
Fidelity Canada
Mississauga, ON · Toronto, ON
- Full-time
We are seeking a highly motivated Robotics Process Analyst to design, develop, and support intelligent automation solutions that enhance operational efficiency, improve customer experience,…
Added 4 months ago
HM
Data Engineer
Hotspex Media
Toronto, Ontario
- $85,000 to $115,000 CAD / year
- Full-time
Added 3 months ago
CT
Business Analyst - EDI
Creation Technologies
Vancouver, BC
- Full-time
Manage and optimize communication protocols (AS2, SFTP, HTTPS, API) and oversee the onboarding of new trading partners (customers and suppliers).
Added 3 months ago
WK
Software Quality Assurance Analyst (GenAI-Enabled)
Wolters Kluwer
Sherbrooke, QC · CAN - Sherbrooke
- Full-time
Compréhension des tests d’API et de la validation des données (SQL de préférence).
Added 3 months ago
OG
Venture Studio Analyst - Onni Capital
Onni Group of Companies
Vancouver, BC
- Full-time
There is an exciting opportunity for a Venture Studio Analyst to join Onni Capital in Vancouver.
Added 2 months ago
Technical Lead Analyst - Billing & Pricing Platforms
Scotiabank
Toronto, ON
Collaborate with architects to define system design, API contracts, and service interactions aligned to enterprise standards.
Added 3 months ago
TA
Gen AI Engineer
Tiger Analytics Inc.
Remote, Canada
- Full-time
- Remote
…are a Great Place to Work-Certified™ company, recognized by analyst firms such as Forrester, Gartner, HFS, Everest, ISG, and others.We are looking for a highly skilled AI Engineer with 7+…
Added 1 month ago
B
Senior Dynamics 365 CE / CRM & Power Platform Consultant
BDO
Toronto, ON · Oakville, ON
- Full-time
Added 3 months ago
BA
Senior Analyst, Application Integration
Brookfield Asset Management
Toronto, ON · Brookfield Place
- Full-time
The Senior Analyst, Application Integration, delivers application integration solutions that support the operations and scalability of our Brookfield Wealth Solutions and Brookfield Credit…
Added 5 months ago
TW
Senior Data Analyst – DEM&S Ecosystem Support / Analyste principal(e) des données – Soutien à l’écosystème DEM&S - NETE
The Weir Group PLC
Montreal, Quebec
- Full-time
Établir et maintenir des normes de format et d’échange de données (y compris XML, protocoles API et normes de sérialisation des données) pour assurer l’interopérabilité et la cohérence…
Added 3 months ago
SI
AI Process Automation Engineer
Staples Inc.
Richmond Hill, ON
- Full-time
5 + years working as a business analyst, systems analyst or in a process improvement role
Added 2 months ago
MS
Technical Business Analyst – HRIS Workday (Hybrid)
Morgan Stanley
Montreal, QC
- Full-time
We’re seeking someone to join our team as a Business Analyst to lead the definition and delivery of HR data capabilities that enable trusted workforce insights, scalable data products, and…
Added 3 months ago
FC
Technical Analyst Sr
Fidelity Canada
Toronto, ON
- Full-time
Strong experience in working with various source and target systems (Oracle, Snowflake, Sales Force, API, flat files) using informatica iPaaS/IDMC
Added 4 months ago
DS
Agentic AI Engineer
D3 Security Management Systems
Vancouver, BC
- Full-time
…Operations Center (ASOC) platform. Morpheus automates Tier 1–3 analyst work with unmatched precision, processing millions of alerts in real time and empowering security teams to respond…
Added 3 months ago
L&
Senior Systems Analyst (SAP BTP)
Lindt & Sprüngli (Canada), Inc
Toronto, ON · LSNA - CAN - Corporate - Head Office - Toronto - ON - LSNA
- Full-time
We are seeking a highly skilled Senior Systems Analyst with deep expertise in SAP Business Technology Platform (BTP) to drive design, integration, and innovation across enterprise…
Added 1 month ago
Support Center Analyst II
eSentire
Waterloo, ON
…troubleshooting skills, Cloud & identity configurations as well as API troubleshooting skills, demonstrates excellent performance in high volume/ high-pressure…
Added 3 months ago
M
Intermediate Business Analyst
MDA
Sainte-Anne-de-Bellevue, QC
- Full-time
…and Project Management supporting all MDA sites. The Business Analyst analyzes complex business problems and provide automated sustainable solutions to the organization. The Candidate…
Added 1 month ago
SH
Quality Assurance Analyst
SE Health
Markham, ON
- Contract
As a Quality Assurance Analyst, you will participate in the planning, preparation, and execution of testing for in-house applications, integrations, and vendor/SaaS solutions. The role will…
Added 1 month ago
SH
Quality Assurance Analyst
SE Health
Markham, ON
- Contract
As a Quality Assurance Analyst, you will participate in the planning, preparation, and execution of testing for in-house applications, integrations, and vendor/SaaS solutions. The role will…
Added 3 months ago
SD
Business Analyst
Symbiotic Digital
Toronto, Ontario · Downtown Toronto (Central Bay Street), Ontario
- Contract
We are seeking a Senior Business Analyst to provide a
Added 3 months ago
K
Senior Business Analyst
Klick
Toronto, Ontario
- Full-time
The Business Analyst, Omnichannel Enablement supports data-driven healthcare marketing initiatives by translating client and stakeholder needs into clear requirements, solution plans, and…
Added 5 months ago
G
Chef(fe) de produit / Product Owner - Integration
Genetec
Montreal, Quebec
- Full-time
Vous souhaitez définir la feuille de route d'intégration d'une entreprise moderne, en tirant parti d'Azure, des API et d'une architecture orientée événements
Added 6 months ago
E
HPLC Analyst - Eurofins BioPharma Product Testing Toronto, Inc.
Eurofins
Toronto, Ontario
- $50,000 CAD / year
- Full-time
Reporting directly to the Department Head - Chemistry, the Analyst will be responsible for providing basic technical support and analysis within the Biopharmaceutical Chemistry Testing…

Hotspex Media

Data Engineer

Toronto, ON, Canada

$85,000 to $115,000 CAD / year · Full-time

Apply About employer

Applications open in a new tab.

Job details

Pay: $85,000 to $115,000 CAD / year
Job type: Full-time
Posting language: English
Posted: Jun 24, 2026

Original job description

Join Hotspex Media! 🙌 #1 Ranked Media Buying and Planning Agency on Clutch.co 🔥 Finalist 'Best AI Tool', 2024 Digiday Technology Awards 🎉 Hybrid Work Model (1 Day in Office / Week) 🥇 Winner of Waterstone Canada's Most Admired Corporate Cultures Reports to: Director of AI & ML Location: Hybrid with the option for Remote if Outside Greater Toronto Area (must be legally authorized to work in and based in Canada) Team: Small, high-autonomy team with direct access to leadership. Impact: Owns design, build, operation of Hotspex's data transformation and storage layer. About the Role & Mission Connect data across BigQuery, Postgres, and Airtable; expose clean datasets to AI, Workflow, Analytics consumers Build and maintain dbt models transforming marketing platform data into conformed dimensional schemas (Kimball facts/dimensions) Own SQL surface: queries, stored procedures, views, materialized views, scheduled routines Optimize warehouse performance and cost: query tuning, partitioning, clustering, incremental models Orchestrate pipelines with Airflow or similar Core Competencies SQL Engineering: Writes, tunes, maintains complex SQL across BigQuery and Postgres Stored Procedures & Routines: Designs and owns stored procedures, scripted procedures, UDFs, scheduled jobs dbt / Transformation Modeling: Builds and maintains dbt models with tests, docs, incremental patterns Pipeline Orchestration: Schedules and monitors pipelines via Airflow or similar Cross-Functional Partnership: Delivers consumable data products for AI, Workflow, Analytics Job Specific Competencies Advanced SQL: Complex joins, window functions, CTEs, query optimization, execution plans on BigQuery and Postgres Stored Procedures & Routines: Production stored procedures, scripted procedures (BigQuery scripting / PL/pgSQL), UDFs, scheduled queries with error handling, idempotency, observability dbt Modeling: Sources, staging, intermediate, marts; tests; documentation; incremental strategies; macros Pipeline Orchestration: Airflow, Dagster, Prefect, or equivalent Data Modeling: Kimball facts/dimensions, slowly changing dimensions, conformed schemas Warehouse Optimization: Partitioning, clustering, materialized views, cost tuning on BigQuery Airtable Integration: Schema mapping, sync patterns, base-as-source Job ResponsibilitiesConnect & Optimize Data Own connectivity between BigQuery, Postgres, and Airtable; ensure consumers (AI, Workflow, Analytics) get the schema they need Refactor ad-hoc SQL into versioned, tested, documented routines Optimize cost and performance: partitioning, clustering, materialization Detect and fix performance regressions before downstream impact SQL & Stored Procedure Ownership Own every production stored procedure, scripted procedure, scheduled query across BigQuery and Postgres Author new stored procedures for batch transforms, reporting routines, AI/ML feature prep Maintain stored-procedure inventory with ownership, dependencies, runbooks dbt Model Build & Maintenance Design schemas and write dbt models transforming marketing platform data (Google Ads, Meta, LinkedIn, etc.) into conformed dimensional schemas Implement dbt tests (uniqueness, not-null, referential integrity, custom rules) on every production model Maintain incremental models for high-volume tables; tune for cost and freshness Own dbt documentation and lineage Pipeline Orchestration Schedule, monitor, and version pipelines in Airflow or similar Alert routing, retry policy, backfill patterns Coordinate with Workflow Eng on hand-off points between n8n and orchestrated data pipelines Data Quality, Monitoring & Reliability Implement automated tests (dbt tests, freshness checks, row-count anomaly detection) Detect and acknowledge data quality incidents within 1 business hour (SLA) Author runbooks for common failure modes Track and reduce incident frequency; report trends quarterly Cross-Functional Partnership Partner with Workflow Automation Engineer on ingestion contracts: landing schemas, refresh patterns Partner with Junior AI Engineer on data needs for RAG, embeddings, AI services: feature tables, serving views Translate PM/CS and Product requirements into dimensional models Owns: SQL design, stored procedure logic, transformation modeling, performance choices Does not own: automation logic (Workflow Eng), AI service code (Jr AI Eng), client-facing strategy Documentation & Knowledge Use Claude Code for stored procedure docs, model READMEs, schema references Version-controlled repos, clean Markdown, proper Git hygiene Document data contracts: ingestion → transformation → consumption Continuous Improvement Use AI tooling (Claude Code, Cursor) to accelerate SQL authoring, refactoring, documentation Track and report query cost reduction and model freshness improvement quarterly Resolve categories of technical debt: consolidating duplicated SQL, retiring shadow tables Explicitly Out of Scope n8n automation design and ownership (Workflow Automation Engineer) Rust service development, RAG pipelines, embedding models (Junior AI Engineer) Looker dashboard authoring and LookML feature development Strategic analytics presentations to leadership ML model engineering, training, prompt engineering as a discipline Required Qualifications 2+ years data engineering, analytics engineering, or database development Strong SQL - complex joins, window functions, CTEs, query optimization (must demonstrate) Hands-on stored procedure experience - production stored procedures (BigQuery scripted procedures, PL/pgSQL, T-SQL, PL/SQL, or equivalent). Non-negotiable. Working knowledge of dbt (or strong SQL/Git fundamentals to ramp quickly) Python or other scripting language for data tasks (Java, Scala, TypeScript also acceptable) Airflow or similar pipeline orchestration experience (Dagster, Prefect, dbt Cloud schedules, Cloud Composer) Dimensional modeling fundamentals - facts, dimensions, grain, conformed schemas Git fundamentals - branches, PRs, code review participation Documentation discipline - version-controlled Markdown Strongly Preferred BigQuery production experience (partitioning, clustering, scripted procedures, scheduled queries) Postgres production experience (PL/pgSQL, indexes, query plans) Airtable production experience (schema design, sync patterns, API integration) Production dbt experience (Cloud or Core) Marketing/advertising data sources (Google Ads, Meta, LinkedIn) AI tooling (Claude Code, Cursor, ChatGPT) as daily accelerator Nice to Have Looker / LookML exposure (consumer-side; not required to own) n8n or other workflow orchestrators RAG / vector search data prep Agency, media, or analytics domain Technology Stack Languages: SQL (advanced), Python (or equivalent), optionally JavaScript for dbt/BigQuery UDFs Data: BigQuery, Postgres, Airtable, dbt, Redis (cache awareness) Orchestration: Airflow (or Dagster, Prefect, Cloud Composer), dbt Cloud Run Integration consumer-side: n8n Cloud: GCP Observability: Cloud Monitoring, Looker (consumer-side) Tools: Linear, GitHub, Claude Code, Cursor What this Role is NOT Not a data analyst - no ad-hoc analysis, dashboarding, stakeholder reporting Not analytics engineering / dashboards - LookML and Looker dashboards not owned Not workflow automation - n8n belongs to Workflow Automation Engineer Not ML / AI engineering - model development belongs to AI team Not a DBA - no infrastructure provisioning or cluster management Our Values: We know our people are what allows us to achieve all that we do and that’s why it’s important that everyone we bring onto our team lives our values with us. 🦁 Courage 1️⃣ One Team 💪 Resilience 🚀 Empowerment Hotspex Media Inc. is an equal opportunity employer and values diversity in its workforce. Due to the large volume of applications received, Hotspex Media may, from time to time, use artificial intelligence to optimize screening efforts.

Apply About employer

More about this job

Responsibilities

The Data Engineer will own the design, build, and operation of Hotspex's data transformation and storage layer, connecting data across various platforms and ensuring optimal performance. Responsibilities include maintaining dbt models, optimizing SQL queries, and orchestrating data pipelines.

Requirements

Candidates should have at least 2 years of experience in data engineering or analytics engineering, with strong SQL skills and hands-on experience with stored procedures. Familiarity with dbt and pipeline orchestration tools like Airflow is also required.

Skills

SQL Engineering
Stored Procedures
dbt Modeling
Pipeline Orchestration
Data Modeling
Warehouse Optimization
Airtable Integration
Advanced SQL
Python
Airflow
Dimensional Modeling
Git
Documentation Discipline
BigQuery
Postgres
Data Quality Monitoring

Visa sponsorship

Not detected in the job text

Hiring contact

Director of AI & ML

Keywords

Data Engineer
SQL
BigQuery
Postgres
Airtable
dbt
Airflow
Data Transformation
Data Storage
Pipeline Orchestration
Dimensional Modeling
Stored Procedures
Analytics
AI
Workflow
Marketing Data
Cloud
GCP
Data Quality
Monitoring
Documentation
Git
Performance Optimization
Schema Design
Integration
Automation
Technical Debt
Incident Management
Data Products
Consumer Data

Report this job