Senior Data Architect

IMR Soft LLC

Canada

On-site

CAD 140,000 - 190,000

Full time

12 hours ago
Be an early applicant

A complete application in a minute

Tailored resume and cover letter, ready to send.

Get past ATS filters

Job summary

IMR Soft LLC is seeking a Data Tech Lead specializing in data architecture, modelling, and Snowflake. You will own the data architecture, design models, and drive discussions with business and tech stakeholders to translate requirements into technical specs.

You will guide offshore development teams, ensure adherence to modelling standards, and shape data structures for scalable data warehouses using Snowflake. Strong leadership and communication are essential for success.

Qualifications

  • 8+ years of experience in data engineering, architecture, and warehousing.
  • Hands-on Snowflake with schema design, SQL, and performance optimization.
  • Strong data modelling (conceptual, logical, physical) and dimensional modelling (Star/Snowflake).
  • Strong SQL skills and understanding of ETL/ELT, data integration, and transformation processes.
  • Ability to translate business requirements into detailed data models and technical designs.
  • Excellent stakeholder management and communication; experience leading technical discussions.
  • Experience guiding offshore development teams and aligning delivery.

Responsibilities

  • Own end-to-end data architecture and data modelling.
  • Lead stakeholder discussions to understand requirements and resolve ambiguities.
  • Design logical and physical data models, including fact and dimension tables and hierarchies.
  • Define data warehouse architecture, data integration patterns, and transformation logic.
  • Leverage Snowflake to create scalable data warehouse solutions.
  • Translate models into actionable development specifications and plans.
  • Guide offshore teams, review designs, and address blockers.
  • Ensure development adheres to architecture and data quality standards.

Skills

Data modelling
Snowflake
Data architecture
Data warehousing
SQL
ETL/ELT
Stakeholder management
Leadership
Offshore guidance

Tools

Snowflake
dbt
Airflow
Kafka
AWS Kinesis
AWS
Azure
GCP

Job description

Job Description: Data Tech Lead – Data Architecture & Modelling

Experience: 8+ years

Mandatory Skill: Data modelling, experience with Snowflake

Role Overview

We are looking for an experienced Data Tech Lead with strong expertise in data modelling, data warehousing, and Snowflake. The candidate will own the data architecture and model design, drive stakeholder discussions, translate business requirements into detailed technical specifications, and guide offshore development teams through implementation.

Key Responsibilities
  • Own and drive end-to-end data architecture and data modelling.
  • Lead discussions with business and technology stakeholders to understand requirements, clarify business rules, resolve ambiguities, and eliminate gaps.
  • Design logical and physical data models, including fact and dimension tables, relationships, data grain, keys, and hierarchies.
  • Define data warehouse architecture, data integration patterns, transformation logic, and data structures.
  • Leverage Snowflake to design and optimize scalable data warehouse solutions.
  • Translate architecture and data models into actionable development specifications and implementation plans.
  • Guide offshore development teams, address technical queries, review design and implementation, and resolve technical blockers.
  • Ensure development adheres to the approved architecture, modelling standards, and data quality requirements.
Required Skills & Experience
  • 8+ years of experience in data engineering, data architecture, and enterprise data warehousing.
  • Mandatory hands-on experience with Snowflake, including schema design, SQL development, and performance optimization.
  • Strong expertise in conceptual, logical, and physical data modelling, dimensional modelling, Star/Snowflake schemas, fact and dimension tables, and SCD.
  • Strong SQL skills and understanding of ETL/ELT, data integration, and transformation processes.
  • Proven ability to convert business requirements into detailed data models and technical designs.
  • Excellent stakeholder management and communication skills, with experience leading technical discussions and driving design decisions.
  • Experience providing technical direction and guidance to offshore development teams.
Good to Have
  • Exposure to Snowplow and event-tracking data architecture.
  • Experience with streaming data ingestion technologies such as Kafka or AWS Kinesis.
  • Exposure to dbt, Airflow, and cloud data platforms (AWS, Azure, or GCP).
  • Knowledge of data governance, lineage, and data quality frameworks.
Get your free, confidential resume review.

or drag and drop your file here.

Similar jobs

Similar jobs worth comparing

Senior Data Architect
Senior Data Architect

HRB • Toronto

On-site
CAD 120,000 - 160,000
Senior Data Engineer
Senior Data Engineer

Compunnel Inc. • Montreal

On-site
CAD 90,000 - 120,000
Snowflake Data Engineer — ETL & Data Pipeline Lead
Snowflake Data Engineer — ETL & Data Pipeline Lead

Compunnel Inc. • Montreal

On-site
CAD 90,000 - 120,000
Senior Data Engineer
Senior Data Engineer

Apply Digital • Vancouver

On-site
CAD 120,000 - 180,000
Senior Software Engineer (Snowflake)
Senior Software Engineer (Snowflake)

Drillo.AI • Toronto

On-site
CAD 80,000 - 120,000
Senior Snowflake Engineer
Senior Snowflake Engineer

Princeton IT Services, Inc • Toronto

On-site
CAD 90,000 - 130,000
Senior Data Architect — Snowflake & Cloud Data Solutions
Senior Data Architect — Snowflake & Cloud Data Solutions

HRB • Toronto

On-site
CAD 120,000 - 160,000
Technical Lead - Cloud Data Warehouse
Technical Lead - Cloud Data Warehouse

Massive Insights Inc. • Toronto

Hybrid
CAD 140,000 - 200,000
Hybrid work location
Health & dental benefits
Background check
Data Engineer
Data Engineer

Compunnel Inc. • Toronto

On-site
CAD 100,000 - 130,000
Senior Enterprise Architecture - High Regulated and Compliance Industry
Senior Enterprise Architecture - High Regulated and Compliance Industry

Talencity Inc. • Toronto

Hybrid
CAD 120,000 - 170,000