Senior Data Engineer

Diagram; Montreal (administrative region); Remote; CAD 120,000 - 160,000; Full time

Benefits offered by this job

Remote-friendly schedules

Stock option plan

4 weeks vacation

Telemedicine app

Job summary

Novisto is seeking a Senior Data Engineer for the Analytics Platform to own the data foundation powering analytics, benchmarking, and AI products. You will architect the lakehouse, design ingestion pipelines, and model datasets while collaborating with Tech Leads, PMs, and ESG Data Ops to ensure reliable, well-documented, query-ready assets.

The role combines hands-on data engineering with strong software practices, including data modeling, testing, CI/CD, version control, API contracts, and

Qualifications

• 6+ years of data engineering or backend engineering experience, with 2+ years in a senior or lead capacity.
• Core skills include expert-level SQL and strong Python proficiency; familiarity with cloud infrastructure (Azure, GCP), CI/CD, containerization, infrastructure-as-code, and DevOps practices.
• Produced experience designing and operating a production lakehouse or cloud data warehouse (Databricks, Snowflake, BigQuery) with open table formats (Delta, Iceberg, Hudi); hands-on with dbt and orchestration tools (Airflow, Dagster, Prefect).
• Solid grounding in dimensional and analytical data modelling; experience with batch and streaming/CDC ingestion, late-arriving data, schema drift and backfills.
• Operational mindset to integrate AI-assisted development tools; experience with event-driven and service-oriented architectures in agile environments.
• Bonus: multi-tenant B2B SaaS, ESG-focused data systems.

Responsibilities

• Design lakehouse architecture and data storage layouts.
• Model curated and semantic analytics datasets; design batch, incremental, and CDC ingestion with clear data contracts.
• Build and operate robust ETL/ELT pipelines with idempotent reprocessing and backfill strategy.
• Develop data quality tooling and platform observability, including lineage, SLAs, and cost telemetry.
• Collaborate with engineering leads and product teams; mentor data engineers across squads.
• Design backend services and APIs to expose curated datasets with multi-tenant data isolation.

Skills

SQL

Python

Data modeling

ETL/ELT design

IaC

CI/CD

Mentoring

Cost optimization

Education

Bachelor's degree in Computer Science

Tools

Databricks

Snowflake

BigQuery

dbt

Airflow

Dagster

Prefect

Delta Lake

Iceberg

Hudi

Azure

GCP

Kubernetes

Docker

Job description

As a Senior Data Engineer on the Analytics Platform, you will build and own the data foundation powering Novisto’s analytics, benchmarking, and AI products. You’ll design the lakehouse, data ingestion pipelines, and curated datasets while partnering with Tech Leads, Product Managers, and ESG Data Ops to turn raw operational data into reliable, well documented, query ready assets. The role combines hands on data engineering with strong software engineering practices, including data modelling, testing, CI/CD, version control, API and data contracts, and platform architecture, while balancing scalability, cost, freshness, and maintainability and mentoring developers on best practices. What you’ll build and own:

• Data Architecture & Lakehouse: Lead the design and evolution of Novisto's lakehouse, including storage layout, table formats, layering strategy, partitioning, and retention.
• Data Modelling & Ingestion: Model curated and semantic layers for analytics and reporting. Design batch, incremental, and CDC ingestion from all source modules, establishing clear data contracts.
• Pipeline Delivery & Execution: Build and operate robust ETL/ELT pipelines with clear ownership, dependency management, backfill strategy, and idempotent reprocessing. Contribute hands-on to transformation and orchestration codebases.
• Reliability & Observability: Build data quality tooling (schema validation, freshness/volume checks, automated regression tests) and platform observability (lineage, SLAs, alerting, cost telemetry). Own production health and incident response.
• Cross-functional Alignment: Write technical tickets to bridge functional intent and technical execution. Collaborate with Engineering Tech Leads and Principal Devs to ensure technical consistency, and mentor developers to grow data engineering capabilities across squads.
• Product Integration & Data Serving: Design and build the backend services and APIs that expose curated datasets to product modules. Implement multi-tenant data isolation, authentication and authorization (tenant scoping, row-level security), and serving patterns (query APIs, materialized views, caching) that meet product latency requirements.

Core Requirements

• Experience: 6+ years of data engineering or backend engineering experience, with 2+ years in a senior or lead capacity. Bachelor's degree in Computer Science or equivalent.
• Core Skills: Expert-level SQL and strong proficiency in Python. Familiarity with cloud infrastructure (Azure, GCP), CI/CD, containerization, infrastructure-as-code, and DevOps practices.
• Data Tech: Proven experience designing and operating a production lakehouse or cloud data warehouse (Databricks, Snowflake, BigQuery) with open table formats (Delta, Iceberg, Hudi). Hands-on experience with transformation frameworks (dbt) and orchestrators (Airflow, Dagster, Prefect).
• Applied Knowledge: Solid grounding in dimensional and analytical data modelling. Experience with batch and streaming/CDC ingestion patterns, late-arriving data, schema drift, and backfills.
• Operational Mindset: Demonstrated ability to integrate AI-assisted development tools into workflows. Experience with architectural patterns (event-driven, service-oriented) in agile environments.
• Bonus: Experience with multi-tenant B2B SaaS, data-intensive applications, or ESG.

What We Offer

• Impact: Advance Novisto’s mission to drive economic, environmental, and social sustainability through better ESG data management.
• Compensation & Equity: Stock option plan in an early-stage, well-financed company.
• Flexibility & Time Off: Remote-friendly flexible schedules, 4 weeks of vacation, and summer hours.
• Health & Wellness: 100% insurance coverage and access to Dialogue’s telemedicine app.
• If you prefer to work at the office, we have a beautiful office in Old Montreal, close to downtown and steps away from a metro (subway) station