Data Engineer
RoleData 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, $74M 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.
Who We Are Looking For
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
- 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
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
- 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
- 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
- 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
- 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