Back to jobs

Data Architect | Canada

Pay
Pay not listed
Work setting
Remote — work setting source
Location type: Remote
From the employer’s posting
Employment
Full-time — employment source
Employment type: Full-time
From the employer’s posting
Team
Technology & AI Consulting › Data & AI Consulting — team source
Department: Technology & AI Consulting › Data & AI Consulting
From the employer’s posting

What you’ll work on

Full posting
  • Design the business data model from discovered business processes and data analysis

  • Translate business requirements into technical design specifications

  • Define data architecture standards, principles and reference architecture

  • Coach and mentor data engineers, analysts and ML engineers on modeling

  • Develop work estimates for data warehouse and data lake deliverables

From the employer’s posting
Design the business data model based on the discovered business processes and data analysis
Translate business requirements into technical design specifications, including data streams, integrations, transformations, databases, and data warehouses
Define the data architecture framework, standards, and principles
Coach and mentor a team of a few dozen data engineers, analysts and ML Engineers on data architecture and modeling best practices
Develop work estimates for Data Warehouse & Data Lake deliverables

What you’ll bring

All qualifications

Core experience

  • 10+ years of work experience in data analytics
  • Bachelor's degree in a technical or quantitative field
  • Hands-on experience deploying solutions in large-scale, high performing databases
  • Expertise in data management platforms such as Snowflake, Databricks or Microsoft Fabric
Qualification wording
10+ years of work experience in the data analytics space
Bachelor’s degree in a technical or quantitative field (e.g. Computer Science, Math, Economics Statistics)
Hands-on experience deploying solutions in large-scale, high performing databases
Expert in technologies including 1 or more of each class: Data management layer Snowflake Databricks Microsoft Fabric
Education & alternatives
What We're Looking For: - Bachelor’s degree in a technical or quantitative field (e.g. Computer Science, Math, Economics Statistics) - 10+ years of work experience in the data analytics space
Apply at Cuesta Partners

Posting record

Report an error

Open 5 monthsWe first saw this posting 169 days ago and it is still up. Roles open this long are often slow to fill or kept open to collect applications.

Status in our records
Live
First seen by us
Jun 2, 2026169 days ago
Recorded sightings
100
Last seen by us
Nov 18, 2026
Employer says posted
May 15, 2026

These dates show when we found the posting. Check the employer’s website to confirm it is still accepting applications.

How this job compares

Time since we first saw it

Day 169

Up longer than most. Similar jobs usually come down between day 8 and day 57.

From 9,610 similar postings that came down. Coming down is not always a hire.

Cuesta Partners is hiring

8 open jobs

Open jobs by the week we first saw them, last 12 weeks.

  • Its jobs tend to stay up a long time
Hiring record

See how this role fits your experience

Add your resume and we’ll mark which of these tools you already use, and point out anything in the posting that could rule you out.

  • Python
  • SQL
  • AWS
  • Azure
  • BigQuery
  • Databricks
  • dbt
  • Fivetran
  • GCP
  • Looker
  • Matillion
  • Power BI
  • Qlik
  • Snowflake
  • Tableau
  • Airflow
Where the posting names them
- DBT - Python / SQL - Apache Airflow etc.
- Microsoft Fabric - GCP Big Query/ AWS DB Options - Data acquisition & integration
- Looker - Domo / ThoughtSpot / Qlik / platform BI vendors (ORCL, SAP, AWS etc.) Architecture transformations:
- Data acquisition & integration - Azure Data Factory (ADF) - Matillion
- Snowflake - Databricks - Microsoft Fabric
- ETL - DBT - Python / SQL
- Matillion - FiveTran & HVR - Keboola
- Tableau - Looker - Domo / ThoughtSpot / Qlik / platform BI vendors (ORCL, SAP, AWS etc.)
- Azure Data Factory (ADF) - Matillion - FiveTran & HVR
- Vis: - PowerBI - Tableau
- Data management layer - Snowflake - Databricks
- PowerBI - Tableau - Looker
- Python / SQL - Apache Airflow etc. - Vis:

Your next step

Complete your application on jobs.ashbyhq.com. The employer’s form will show what is required.

Applying through Ashby

  • No account needed. “Autofill from resume” at the top of the form fills the key fields from your file.

Already applied? Track this application

Job description

View original posting ↗

Cuesta Partners is looking for a Data Architect to engage with us on transformational data programs with companies looking to take their AI & data capabilities to the next level.

Key Areas of Focus:

Business data modeling

  • Trade-offs between different modeling philosophies – dimensional, 3NF, Data Vault

  • Conceptual vs physical modeling

  • Modeling techniques such as inheritance, parent / child tables, ragged structures, slowly changing dimensions etc.

  • Normalization vs de-normalization trade-offs

  • Detailed understanding the design trade-offs around different modeling approaches

  • Ability to lead model review sessions, and being able to lay out the design "options" and implications, and also present it in a way that both executives and technical-minded people can understand

Modern data delivery design patterns

  • Data as product

  • Design compromises & considerations

  • Know what exemplar deliverables look like

  • Team composition and responsibilities / work to be done

  • Streaming vs batch design patterns / considerations

  • Pros / cons of data mesh delivery model vs alternatives

  • Comparison of modern cloud native platforms vs legacy on-premises data solutions

Master data governance

  • Types and most common root cause of DQ issues

  • Remediation approaches

  • MDM architecture styles / patterns

  • Key capabilities of MDM & DQ vendors

Expert in technologies including 1 or more of each class:

  • Data management layer

    • Snowflake

    • Databricks

    • Microsoft Fabric

    • GCP Big Query/ AWS DB Options

  • Data acquisition & integration

    • Azure Data Factory (ADF)

    • Matillion

    • FiveTran & HVR

    • Keboola

  • Data transformation & orchestration

    • ETL

    • DBT

    • Python / SQL

    • Apache Airflow etc.

  • Vis:

    • PowerBI

    • Tableau

    • Looker

    • Domo / ThoughtSpot / Qlik / platform BI vendors (ORCL, SAP, AWS etc.)

Architecture transformations:

  • Considerations / experience evaluating lift & shift vs re-model trade-offs

  • Considerations / experience when consolidating decentralized silos

  • Considerations / experience when moving to modern cloud stacks

  • Considerations / experience when enabling unified operational & analytics data hubs

Communication & leadership skills:

  • Able to identify & evaluate most important criteria when making design decisions

  • Able to look around corners – recognize likely issues before they happen

  • Able to communicate complex subjects with executive leaders

  • Able to solicit input & feedback to model and design decisions

  • Ability to teach / leverage experience to develop team/talent around them

  • Use past experiences to help with change management to eases concerns over shifts in approach

What You'll Do:

  • Design the business data model based on the discovered business processes and data analysis

  • Set the standard for AI-augmented development practices — ensuring projects are structured and tooled in ways that allow coding agents to operate effectively, and coaching the team to work the same way.

  • Translate business requirements into technical design specifications, including data streams, integrations, transformations, databases, and data warehouses.

  • Develop work estimates for Data Warehouse & Data Lake deliverables

  • Coach and mentor a team of a few dozen data engineers, analysts and ML Engineers on data architecture and modeling best practices

  • Define the data architecture framework, standards, and principles, including modeling, metadata, security, reference data such as product codes and client categories, and master data such as clients, vendors, materials, and employees

  • Define reference architecture, which is a pattern others can follow to create and improve data systems

  • Define data flows, i.e., which parts of the organization generate data, which require data to function, how data flows are managed, and how data changes in transition

  • Collaborate and coordinate with team members, clients and external SMEs

What We're Looking For:

  • Bachelor’s degree in a technical or quantitative field (e.g. Computer Science, Math, Economics Statistics)

  • 10+ years of work experience in the data analytics space

  • Active, hands-on experience using AI-assisted development tools (e.g., Cursor, Claude Code, Codex, or similar) in your daily workflow — including building working prototypes, agentic pipelines, RAG systems, or LLM-powered data and analytics products — is a strong asset.

  • Previous experience in the consulting space is a plus

  • A passion for exploring and solving different kinds of problems

  • A desire to learn and assimilate technical information quickly

  • Hands-on experience deploying solutions in large-scale, high performing databases

  • Expertise aligned to technologies listed in Key Areas of Focus

Benefits: What you’ll gain:

At Cuesta, we value entrepreneurship, humility, diversity, learning, speed, and balance. We provide our team members with:

  • Constant opportunities for exposure & learning

  • Flexible working location and enabling personal-life harmony with work

  • Agency and influence in the company’s total strategy and direction

  • Collaboration with a high-performing team

  • Competitive base salary (outlined in this listing) and target bonus of 15-25%

  • Supplemental Health, Dental, Vision, and Life insurance

Demand for Data Leadership roles

New Data Leadership postings at the employers we follow are up 8% over the last 6 weeks compared with the 6 before.

Weekly new Data Leadership postings at the same employers, from the week of August 17 to the week of November 9. The fewest in a week was 752, the most 1,164, and the latest week had 785.
August 17Last week

Each bar is one week of new postings. The darkest bars are the last 6 weeks.

Counted from the hiring pages we’ve followed for at least five weeks, so employers we add don’t look like growth. Updated weekly.

About the role

We file this job under Data Leadership, by the work the posting describes.

Data leaders run data teams or design how a company's data fits together. Managers hire, set priorities and answer for whether the data work pays off; architects choose the systems and the shape of the data.

Expect years of hands-on data work, experience leading people or projects, and the ability to explain tradeoffs to executives.

Unlike a senior engineer or analyst, most of a data leader's week goes to people, planning and decisions rather than building.

US government figures for computer and information systems managers

Median yearly pay, May 2025
$175,140
Expected change, 2025 to 2035
15.8% more jobsagainst 3.5% for all jobs

The government has no code for data leaders, so these figures are for the closest group, computer and information systems managers, which includes data processing and data operations managers.

Source: US Bureau of Labor Statistics, Occupational Employment and Wage Statistics (May 2025) and Employment Projections (2025 to 2035). Occupation code 11-3021.

Source details

View original posting ↗

Source notes

Source excerpts

Selected passages from the saved posting. Check the full description for conditions and exceptions.

Pay

No pay amount identified in the saved description.

Location & working pattern

Canada

Working pattern and location restrictions need checking in the full posting.

Work authorization

No clear work-authorization passage found. Eligibility is unconfirmed.

Find answers in the posting

AI
How answers work

AI selects complete passages from this posting. Check them for conditions and exceptions.

Uses this posting and your question. No profile needed.