Hotspexmedia

Hotspexmedia

Data Engineer

Toronto, Ontario

No sponsorshipDetected 27 days ago
JavaScriptTypeScriptPythonJavaScalaCode ReviewGitSQLPostgreSQLRedisBigQueryGCPMachine LearningAirflowdbtData EngineeringData VisualizationRAGGoogle AdsLeadershipPublic Speaking

About the role

  • Connect data across BigQuery, Postgres, and Airtable; expose clean datasets to AI, Workflow, Analytics consumers

Responsibilities

  • Own connectivity between BigQuery, Postgres, and Airtable; ensure consumers (AI, Workflow, Analytics) get the schema they need
  • Owns design, build, operation of Hotspex's data transformation and storage layer.
  • Own every production stored procedure, scripted procedure, scheduled query across BigQuery and Postgres
  • Maintain stored-procedure inventory with ownership, dependencies, runbooks
  • Design schemas and write dbt models transforming marketing platform data (Google Ads, Meta, LinkedIn, etc.) into conformed dimensional schemas
  • Implement dbt tests (uniqueness, not-null, referential integrity, custom rules) on every production model
  • Maintain incremental models for high-volume tables; tune for cost and freshness
  • Own dbt documentation and lineage

Requirements

  • 2+ years data engineering, analytics engineering, or database development
  • Hands-on stored procedure experience - production stored procedures (BigQuery scripted procedures, PL/pgSQL, T-SQL, PL/SQL, or equivalent).
  • Working knowledge of dbt (or strong SQL/Git fundamentals to ramp quickly)
  • BigQuery production experience (partitioning, clustering, scripted procedures, scheduled queries)
  • Postgres production experience (PL/pgSQL, indexes, query plans)
  • Production dbt experience (Cloud or Core)

Nice to have

  • Looker / LookML exposure (consumer-side
  • not required to own)
  • n8n or other workflow orchestrators
  • RAG / vector search data prep
  • Agency, media, or analytics domain
  • Languages: SQL (advanced), Python (or equivalent), optionally JavaScript for dbt/BigQuery UDFs
  • Data: BigQuery, Postgres, Airtable, dbt, Redis (cache awareness)
  • Orchestration: Airflow (or Dagster, Prefect, Cloud Composer), dbt Cloud Run

Skills

  • Linear, GitHub, Claude Code, Cursor
  • Airflow (or Dagster, Prefect, Cloud Composer), dbt Cloud Run
  • Cloud Monitoring, Looker (consumer-side)

Company info

  • Not a data analyst - no ad-hoc analysis, dashboarding, stakeholder reporting
  • Not analytics engineering / dashboards - LookML and Looker dashboards not owned
  • Not workflow automation - n8n belongs to Workflow Automation Engineer
  • Not ML / AI engineering - model development belongs to AI team
  • Not a DBA - no infrastructure provisioning or cluster management
  • 🦁 Courage
  • 1️⃣ One Team
  • 💪 Resilience
  • 🚀 Empowerment
Apply directly at Hotspexmedia →Create a free account for alerts like thisView Hotspexmedia immigration profile

This listing is sourced directly from Hotspexmedia's careers page and normalized into a canonical job model.