Job Closed
This listing is no longer active.
Built to unlock the next stage of growth for home improvement companies.
Data Engineer
Location
Canada
Posted
59 days ago
Salary
$120K - $150K / year
Seniority
Senior
Job Description
Data Engineer
Clever Digital Marketing
• 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
Job 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
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
Related Guides
Related Categories
Related Job Pages
More Data Engineer Jobs
• Own and manage the data pipeline for updating and adding records to our internal database of contact and company information • Complete data analysis requests for the engineering and product team • Evaluate and configure new data services • Own the overall improvement of our internal database of contacts and company records
Data Engineer – Databricks
AddeptoBig Data, Machine Learning, Data Science, AI, MLOps and DataOps Services
• Design scalable data processing pipelines for streaming and batch processing using Big Data technologies like Databricks, Airflow and/or Dagster. • Contribute to the development of CI/CD and MLOps processes. • Develop applications to aggregate, process, and analyze data from diverse sources. • Collaborate with the Data Science team on Machine Learning projects, including text/image analysis and predictive model building. • Develop and organize data transformations using Databricks/DBT and Apache Airflow. • Translate business requirements into technical solutions and ensure optimal performance and quality.
• Develop and maintain a high-performance data processing platform for automotive data, ensuring scalability and reliability. • Design and implement data pipelines that process large volumes of data in both streaming and batch modes. • Optimize data workflows to ensure efficient data ingestion, processing, and storage using technologies such as Spark, Cloudera, and Airflow. • Work with data lake technologies (e.g., Iceberg) to manage structured and unstructured data efficiently. • Collaborate with cross-functional teams to understand data requirements and ensure seamless integration of data sources. • Monitor and troubleshoot the platform, ensuring high availability, performance, and accuracy of data processing. • Leverage cloud services (AWS) for infrastructure management and scaling of processing workloads. • Write and maintain high-quality Python (or Java/Scala) code for data processing tasks and automation.
Senior Data Science Engineer
AvengaA global IT engineering and consulting company specializing in custom software development.
Role Description Within the telecommunications domain, we are actively seeking a Senior Data Scientist to strengthen our team focused on building AI-driven solutions that enhance customer experience and operational efficiency. - You will be working on advanced Generative AI use cases, including conversational AI (chatbots and voice bots), as well as internal AI tools that support business teams in their daily operations. - The role involves designing and scaling solutions such as RAG-based systems and intelligent assistants, enabling both customer-facing and internal automation scenarios. Qualifications - Master’s degree in AI, Machine Learning, Data Science, or a related field - 3–6 years of experience as a Data Scientist (preferably at Senior level) - Strong expertise in AI/ML and practical experience delivering business-impacting solutions - Hands-on experience with Generative AI, especially LLMs - Experience with NLP use cases (e.g. chatbots, voice bots, text processing) - Solid programming skills in Python and experience working with APIs, SQL, and Git - Experience designing and implementing production-ready solutions - Ability to communicate complex technical concepts to non-technical stakeholders Requirements - Experience with telecom domain or customer-facing digital products (nice-to-have) - Knowledge of Agentic AI, RAG systems, vector databases, and chunking strategies (nice-to-have) - Familiarity with LLM frameworks such as LangChain, LlamaIndex, LangGraph, AutoGen, or similar (nice-to-have) - Experience with AWS and/or on-premise deployments (nice-to-have) - Knowledge of Docker, Airflow, CI/CD pipelines (e.g. GitHub Actions/Runners) (nice-to-have) - Experience with Google AI/NLP ecosystem (nice-to-have) Benefits - At Avenga, everyone matters. We provide equal opportunities in recruitment, career development, and leadership, regardless of race, ethnicity, gender identity, sexual orientation, disability, age, religion, or any other characteristic. - We are committed to fostering a work environment where our diverse community of employees, candidates, and business partners actively shapes our growth. - By bringing together people from different backgrounds and experiences, we build a workplace where everyone feels free to be themselves while honoring the boundaries of others.



