montréal qc data warehouse architect Jobs – 12 Openings This Week

Data Architect
BMC Software —Montréal, QC
- $137,850–$229,750 a year
- Remote
- Azure
- SQL
- AWS
Warehouse Clerk
Batimat —Town of Mount-Royal, QC
- $45,000 a year
- Full-time
- Bilingual
- English
- Forklift
- Profit sharing
- Wellness program
Quick apply
1d
Senior Data Engineer - (Canada-based)
Artefact —Montréal, QC
- Azure
- Computer Science
- DevOps
IT Director, Warehouse and Inventory Management
Saputo Inc. —Saint-Laurent, QC
- Full-time
- Hybrid work
- English
- Warehouse experience
- IT
- Wellness program
- Work from home
Data Engineer
JAM Industries Ltd —Montréal, QC
- Full-time
- Hybrid work
- Azure
- DevOps
- SQL
- Wellness program
- Disability insurance
Quick apply
Senior Data Engineer
Datatonic —Montréal, QC
- $110,000–$140,000 a year
- Full-time
- Remote
- Java
- SQL
- AWS
- Designated paid holidays
Data Engineer (Team Lead)
Apertera —Montréal, QC
- Full-time
- Hybrid work
- DevOps
- Databases
- SQL
- Dental care
- Vision care
Quick apply
1d
System Integrator
Joseph Ribkoff —Montréal, QC
- Full-time
- Bilingual
- Azure
- English
Quick apply
Senior Oracle Data Warehouse Developer (PL/SQL Expert) Remote, QC
Rona —Boucherville, QC
- Full-time
- Remote
- Oracle
- Databases
- SQL
Quick apply
Dynamics 365 Developer
Joseph Ribkoff —Montréal, QC
- Full-time
- Bilingual
- System design
- English
Quick apply
1d
Lead AI/ML Engineer
Xsolla —Montréal, QC
- $130,000–$160,000 a year
- Full-time
- SQL
- AWS
- Machine learning
- Dental care
- Paid time off
Quick apply
Senior Software Developer (Netsuite)
Vention —Montréal, QC
- Full-time
- Hybrid work
- Computer Science
- Engineering
- Bachelor's
- Work from home
Quick apply
14d

More jobs to discover

Find similar jobs that you might be interested in.

Warehouse Operations Clerk
Wintersteiger —Laval, QC
Receive and inspect incoming shipments including verifying damage and accuracy of shipping contents against shipping documents (quality, etc).
Quick apply
Receiving clerk
Les Marches D'aliments Naturel Tau —Saint-leonard, QC
The person in this position will receive product orders. Receive orders from various departments; Day-to-day management and follow-up of orders;
Quick apply

Show more similar jobs

Explore jobs in cities nearby

Check out jobs in cities near your current location, Columbus

25-167 Senior Data Engineer (Azure Data Factory / Databricks) - 12 month contract - Oshawa - hybrid remote
CorGTA —Oshawa, ON
Strong hands-on expertise with Python, PySpark, SparkSQL, and SQL for large-scale data processing, transformation, and pipeline development.
$85–$95 an hour
3d
Principal Data Engineer
APPTOZA INC. —Toronto, ON
Risk exposure| liquidity| credit| and market risk models Enable aggregation| drill down| and drill back from reports to transaction level data.
$60.00–$253,082.90 an hour
Quick apply
11d

Show more jobs in cities nearby

I want to receive the latest job alerts for data warehouse architect in montréal qc

By signing in to your account, you agree to SimplyHired's Terms of Service and consent to our Cookie and Privacy Policy.

Explore jobs in more locations

data warehouse architect jobs near montréal qc

Data Architect

BMC Software -
Montréal, QC

Apply Now

Job details

$137,850–$229,750 a year

Qualifications

Performance tuning
Power BI
Data modeling
Azure
Tableau
SQL
AWS
APIs
S3
Kafka
Metadata
AI
Informatica
Python

Full job description

Basic Information

Job Name

Lead Data Scientist - Canada

Country

Canada

State

Date Published

01-May-2026

Job ID

46748

Travel

You may occasionally be required to travel for business

This role can be based remotely in Canada

Looking for details about our benefits?

Description and Requirements

CareerArc Code

CA-AJ

Remote: #LI-Remote

BMC empowers nearly 80% of the Forbes Global 100 to accelerate business value, faster than humanly possible. Our industry-leading portfolio unlocks human and machine potential to drive business growth, innovation, and sustainable success. BMC does this in a simple and optimized way by connecting people, systems, and data that power the world’s largest organizations so they can seize a competitive advantage.

Title: Data Architect (Hands-On Builder)

Location: Canada Remote

Data Architect will focus on the design, build, and evolve a modern, scalable data architecture that will power analytics, reporting, AI/ML use cases, and operational decision-making across the GTM business. This role will define data patterns and standards, partner with IT, and business partner teams to ensure our data platform is secure, reliable, cost-efficient, and easy to use.

This role is ideal for someone with strong hands-on architecture depth and can define target-state architecture, guide implementation, and ensure high-quality delivery across pipelines, integrations, and governance.

Key Responsibilities:

Build and Own Core Data Pipelines (Hands-On)
Architect and implement end-to-end ingestion and transformation pipelines from source systems into Snowflake.
Develop robust ELT/ETL workflows using dbt and orchestration tools (e.g., Airflow/Dagster/ADF), including:
incremental loads, SCD handling, backfills, and reprocessing
late-arriving data patterns and idempotent job design
CDC-based ingestion where applicable
Build integrations for key enterprise SaaS systems (Salesforce, Marketing Cloud, Netsuite, Zuora, Gainsight, CSOD) and internal app databases.
Data Modeling & dbt Development
Own the data modeling layer in Snowflake with dbt:
design dimensional models (star schemas), marts, and curated layers
marts, modular models, macros, packages
define metric-ready datasets (e.g., ARR/NRR, pipeline, churn, product usage) with consistent definitions
Optimize for performance and cost (clustering, warehouse sizing, query patterns, caching, micro-partitioning awareness).

Cloud Platform Enablement (AWS + Azure)

Implement secure, scalable data platform components across AWS and Azure:
landing zones, storage (S3/ADLS), networking, secrets management, and compute integration patterns
secure connectivity to Snowflake (PrivateLink/peering patterns where relevant)
Work with technology teams to implement RBAC, role hierarchy, masking policies, row access policies, and data sharing patterns.

Reliability, Testing, and Observability

Implement data quality and reliability controls:
dbt tests (schema, relationship, accepted values) and custom tests for business logic
anomaly detection and pipeline monitoring (e.g., Datadog/CloudWatch/Azure Monitor, Monte Carlo if applicable)
SLAs/SLOs for critical datasets and clear incident runbooks
Build operational readiness: logging, alerting, retries, failure isolation, and safe deploys.

CI/CD, Version Control, and Engineering Practices

Build and maintain CI/CD for data development (PR checks, dbt builds, environment promotion).
Establish practical engineering standards:
naming conventions, repo structure, branching strategy
documentation that stays current (dbt docs, data dictionaries)
code reviews and design patterns that scale with the team

AI / Agentic AI Architecture

Design and implement architecture patterns that support AI/ML, GenAI, and agentic AI use cases across the Sales business, including structured and unstructured data pipelines, retrieval-ready data design, and secure enterprise data access.
Define scalable patterns for AI-enabled applications and agents, including metadata design, indexing, vector-ready data preparation, API/tool access, and governance controls such as lineage, auditability, observability, and guardrails.
Partner Closely with Analytics & Business Teams
Collaborate with BI/Analytics to ensure the curated layer supports dashboards and self-service.
Translate business needs into data products quickly with tight feedback loops, iterative delivery, measurable outcomes.

Required Qualifications

10+ years of experience in data engineering and data architecture with a strong hands-on track record.
Strong production experience with Snowflake (performance tuning, data loading patterns, security model).
Strong production experience with dbt:
incremental models, snapshots, tests, macros, documentation, deployments
Experience building pipelines and integrations in AWS and/or Azure (both preferred).
Advanced SQL skills and strong understanding of data modeling (dimensional modeling, SCD types).
Experience with orchestration (Airflow, Dagster, Prefect, or Azure Data Factory) and reliable job design.

Preferred Qualifications (Nice to Have)

Experience with ingestion tooling (Boomi, Fivetran, Matillion, Informatica, Stitch) and/or CDC tooling (Debezium/HVR).
Experience designing or supporting data architecture for GenAI, RAG, enterprise search, or agentic AI use cases in production environments.
Familiarity with modern AI-related technologies and patterns such as OpenAI APIs, LangChain/LangGraph, Snowflake Cortex, Azure AI services, vector-ready data pipelines, and secure tool integration for AI agents.
Experience with streaming/event ingestion (Kafka/Kinesis/Event Hubs) for near-real-time pipelines.
Familiarity with governance/security patterns in Snowflake (masking/row access, tags, classification).
Exposure to BI layers (Tableau/Power BI/Looker) and semantic/metrics frameworks.
Python experience for custom integrations, APIs, and automation (Lambda, Azure Functions).

#LI-Remote

Our commitment to you!

BMC’s culture is built around its people. We have 6000+ brilliant minds working together across the globe. You won’t be known just by your employee number, but for your true authentic self. BMC lets you be YOU!

If after reading the above, You’re unsure if you meet the qualifications of this role but are deeply excited about BMC and this team, we still encourage you to apply! We want to attract talents from diverse backgrounds and experience to ensure we face the world together with the best ideas!

BMC is committed to equal opportunity employment regardless of race, age, sex, creed, color, religion, citizenship status, sexual orientation, gender, gender expression, gender identity, national origin, disability, marital status, pregnancy, disabled veteran or status as a protected veteran. If you need a reasonable accommodation for any part of the application and hiring process, visit the accommodation request page.

BMC Software maintains a strict policy of not requesting any form of payment in exchange for employment opportunities, upholding a fair and ethical hiring process.

The annual base salary range represents the low and high end of the BMC salary range for this position. Actual salaries depend on a wide range of factors that are considered in making compensation decisions, including but not limited to skill sets; experience and training, licensure, and certifications; and other business and organizational needs.

The range listed is just one component of BMC's employee compensation package. Other rewards may include a variable plan and country specific benefits.

At BMC, it is not typical for an individual to be hired at /near the top of the range. A reasonable estimate of the current range is $137,850 - $229,750

Min salary

137,850

Mid point salary

183,800

Max salary

229,750

Apply Now

Refine Your Search

data warehouse architect jobs in montréal qc

Data Architect

Warehouse Clerk

Senior Data Engineer - (Canada-based)

IT Director, Warehouse and Inventory Management

Data Engineer

Senior Data Engineer

Data Engineer (Team Lead)

System Integrator

Senior Oracle Data Warehouse Developer (PL/SQL Expert) Remote, QC

Dynamics 365 Developer

Lead AI/ML Engineer

Senior Software Developer (Netsuite)

More jobs to discover

Explore jobs in cities nearby

I want to receive the latest job alerts for data warehouse architect in montréal qc

Explore jobs in more locations

Basic Information

Description and Requirements

Job seeker tools

Employer Tools

Browse

Stay Connected