Data Engineer

Role Overview

• Implement and manage robust, scalable ETL/ELT pipelines to ingest, transform, and load data from Google Ads, Meta Ads, and Microsoft/Bing Ads APIs — as well as CRM, call tracking, and lead event sources — into our BigQuery data ecosystem
• Own Bronze layer ingestion with full fidelity, audit trails, and zero silent failures
• Build and maintain the permanent Cloud Run connector for the Microsoft Ads Reporting API (SOAP/OAuth2), replacing interim Dataslayer bridges as the platform matures
• Integrate Pub/Sub-based event streaming for real-time lead data flows and speed-to-lead use case
• Translate designs and specifications from the Data Architect into functional, production-grade data infrastructure and code
• Extend the Medallion Architecture (Bronze → Silver → Gold), owning Silver layer transformation logic and Gold layer Dataform models serving Command Centre, client reporting, and future AI/ML consumers
• Own the CDMID join logic that unifies CRM, ad platform, and call tracking data into a coherent lead record across all client accounts
• Develop and manage data models within BigQuery, ensuring data is organized efficiently for analytics and AI/ML workloads
• Apply dimensional modeling and star schema design principles to build a single source of truth for all reporting and analytics across our home improvement advertiser base
• Deliver the clean, trusted, cost-metric-driven datasets that allow our team to move beyond vanity metrics to cost-per-issued-lead and cost-per-demo insights that drive real client decisions
• Write Python-based automation scripts and leverage GCP services — Cloud Run, Cloud Functions, Pub/Sub, and Dataflow — to orchestrate data workflows and eliminate manual processes
• Graduate CRM push workflows off Zapier and onto a reliable, auditable Cloud Run pipeline
• Proactively monitor and tune data pipelines and BigQuery queries for performance and cost-efficiency
• Implement data quality checks, validation rules, and monitoring across the full pipeline to ensure accuracy, completeness, and timeliness of all data assets
• Build the observability and alerting layer so the team knows about data issues before clients do
• Maintain living architecture documentation as a reliable source of truth across workstreams

Requirements

• 3–5+ years of hands-on data engineering experience building and maintaining production pipelines — not analytical support or BI roles; you have owned infrastructure end-to-end
• Strong, practical GCP expertise: BigQuery, Cloud Run, Dataflow, Cloud Storage, and Pub/Sub are essential
• Deep proficiency in SQL and Python for data transformation, scripting, and pipeline development
• Direct production experience with at least one major ad platform API: Google Ads, Meta Marketing API, or Microsoft Ads Reporting API (SOAP/OAuth2)
• Proven experience designing, building, and operationalizing complex ETL/ELT pipelines from a variety of sources
• Solid understanding of data warehousing concepts — dimensional modeling, star schemas, and analytical schema design
• Experience with real-time data streaming technologies such as Pub/Sub or equivalent
• Familiarity with data transformation frameworks: Dataform, dbt, SQLMesh, or equivalent

Tech Stack

• BigQuery
• Cloud
• ETL
• Google Cloud Platform
• Python
• SOAP
• SQL

Benefits

• An incredible team and culture — high-performance, feedback-oriented, and data-driven, where everyone is empowered to succeed. Our culture thrives on collaboration, extreme ownership, and Kaizen. This is more than a workplace — it's a place where you'll grow, learn, and thrive alongside passionate teammates who are as invested in your success as you are
• Full ownership of a data platform being built from the ground up — your architecture decisions will shape CDM's competitive advantage for years
• Be part of the #1 fastest-growing marketing company in Canada, redefining performance marketing for the home improvement industry
• A modern, GCP-native stack with AI embedded in daily workflows — Claude and Gemini are tools you'll use every day, not novelties
• Exposure to AI/NLQ, MMM modeling, and ML optimization layers as the proprietary platform matures
• Above-industry competitive compensation that reflects your expertise and contributions
• Fully remote work environment with the flexibility to work from anywhere
• 3+ weeks of paid time off annually, with the freedom to use them as you see fit
• Comprehensive group benefits including health, dental, and vision
• Company-provided MacBook Pro and home office budget to help you create your ideal workspace
• A work abroad policy to support you when you need a fresh perspective
• Merch deliveries and opportunities to connect with teammates at meetups and company-wide events
• A clear path to increased scope, leadership, and platform ownership for those who demonstrate exceptional performance and impact