Data Engineer

Data Engineer Department: Data & Engineering Employment Type: Full Time Location: Canada Compensation: $120,000 - $150,000 / year Description Role: Data Engineer Who We Are Mission: At Clever Digital Marketing, we are on a mission to empower large‑scale home improvement companies by fueling their top‑line revenue through innovative digital marketing strategies. By bridging the gap in the industry for a highly profitable digital lead vendor, we’ve created a unique space where growth isn’t just supported—it’s catalyzed. Product: Clever Digital Marketing delivers outcome‑driven paid advertising and strategic advising solutions.

We don’t focus on clicks and impressions—we focus on net sales. Our customized, data‑driven strategies are tailored to each client’s unique needs, ensuring measurable impact and scalable profitability across Google, Meta, and Bing ad platforms. Scale: Recognized by the Globe and Mail as the #1 Fastest‑Growing Company in the Marketing & Advertising category and #42 across all of Canada, we are the growth engine behind some of North America’s most ambitious home improvement brands — companies on track to generate over $500 million in combined revenue in 2026.

With a team of 80+ across North America, $74 M in digital ad spend managed, and 400,000+ leads generated, we’ve built something rare: a system where scale isn’t luck. It’s engineering. Impact: As trusted subject matter experts in the home improvement space, we are redefining what it means to deliver value.

Our commitment to authenticity and collaboration ensures we remain a powerhouse of growth, innovation, and measurable results for every client we serve. We are looking for a foundational Data Engineer to own the infrastructure that powers our entire advertising operation. As we scale Data Platform 2.0 — our GCP‑native data platform — we need a builder with extreme ownership who can translate architectural vision into production‑grade infrastructure, and who is energized by the challenge of engineering scale in a fast‑moving, high‑performance environment.

Key Responsibilities What You’ll Do Build and Manage Data Pipelines 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 Execute the Architectural Vision 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 Manage Data Warehousing and Modeling 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 Automate and Optimize 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 Ensure Data Quality and Reliability 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 Skills, Knowledge and Expertise What We Are Looking For Non‑Negotiables 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 Who You Are Extreme Ownership — you drive outcomes end‑to‑end and take full accountability for pipeline reliability and data quality Results With Speed — you ship working solutions and iterate; you don’t let perfect be the enemy of good Kaizen — you leave the platform better than you found it and are always looking for the next improvement Proactive communicator — you surface problems early, flag risks before stakeholders do, and document decisions clearly Effective collaborator — comfortable bridging the gap between data infrastructure and the media buyers and clients who depend on it Nice to Haves Background in performance marketing, ad‑tech, retail media, or a multi‑client agency environment Experience with CRM data pipelines (HubSpot, Salesforce) or call tracking data integration Experience building data foundations for ML model training or feature engineering Prior experience replacing fragile automation tools with production‑grade pipeline infrastructure Familiarity with Dataslayer or similar ad data connectors What You Will Not Do Own media buying, campaign strategy, or client‑facing reporting delivery — your role is the infrastructure that makes those possible Work in a legacy or on‑premise environment — this is a fully cloud‑native GCP stack Benefits What We Offer 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 Other Job‑Type: Full‑Time Permanent Standard business hours: 9am - 5pm EST Working Arrangements: Remote - Occasional in‑office collaboration opportunities Base Salary: Competitive - Based on Experience Clever Digital Marketing values the unique skills and experiences each individual brings to the team.

We are happy to provide reasonable accommodations to candidates in need of support during the recruitment and selection process. Please note that artificial intelligence (AI) may be utilized during the interview or candidate evaluation process to support the fair and efficient screening, assessment, and selection of applicants. #J-18808-Ljbffr