Data Warehouse Developer (CAN - Toronto or Calgary)

ClearGov•Toronto, ON

12d•Hybrid

About The Position

ClearGov is seeking a Data Warehouse Developer with a passion for learning, a kind heart, a positive attitude, and a great sense of humor to join their growing data team. This role is responsible for transforming raw signals from sales, success, and product tools into a unified "source of truth." The ideal candidate understands the importance of data reliability and is comfortable with complex SQL, Python pipelines, and data governance frameworks. The Data Warehouse Developer will be a key player in helping local governments and school districts improve their operations. The position is open to candidates in Toronto or Calgary.

Requirements

5+ years of Experience with modern data stack tools (e.g., Databricks, dbt, Airflow, Fivetran/Airbyte).
Knowledge of Gong conversation intelligence data and how to link it to CRM outcomes.
Understanding of SaaS metrics (CAC, LTV, Net Retention, Churn).

Nice To Haves

Strong knowledge of Go-To-Market operations.

Responsibilities

Design and maintain robust data pipelines using the Medallion Architecture (Bronze/Silver/Gold) to ensure data lineage and scalability.
Ingest and model data from core tech stack tools including Salesforce, Zendesk, Pendo, ChurnZero, and Gong.
Transform disparate data sources into a high-performance Fact/Dimension (Star Schema) architecture.
Implement automated data quality rules and validation checks to ensure accuracy.
Define and enforce data governance standards across the warehouse.
Build and manage alerting and monitoring systems to proactively identify pipeline failures or data drift.
Occasionally build stakeholder-facing dashboards and self-serve layers to visualize GTM KPIs.
Find the root cause of bugs in source systems and fix the logic.
Bridge the gap between technical infrastructure and business requirements from Sales and Marketing leaders.
Take pride in "clean" code and even cleaner data.