Data Engineer owning paid media, CRM, BigQuery, and reporting pipelines for an education and nonprofit marketing agency. Building trusted data infrastructure for partner performance analytics.
Responsibilities
Own data ingestion and pipeline architecture from paid media platforms through Adverity to dashboards
Connect and maintain API pipelines for Meta, Google Ads, LinkedIn, TikTok, and programmatic platforms
Build custom Python connectors for unsupported systems
Build and maintain CRM data connections for Slate, Salesforce, and HubSpot
Own Google BigQuery warehouse routing, optimization, storage, and schema design
Manage partitioning, clustering, and storage strategy to control query cost and performance
Build modular, version-controlled, documented dbt or Dataform transformation pipelines
Maintain CI/CD pipelines using GitHub Actions and automated testing
Enforce strict data segregation across multi-client environments
Create performant data views for Looker Studio dashboards and automated Google Sheets reports
Translate reporting requirements into warehouse models with the Data and Analytics Manager and client teams
Monitor pipeline health, resolve API breaks, minimize latency, and troubleshoot discrepancies
Implement validation frameworks and automated testing
Proactively identify and report data quality risks to leadership
Requirements
5+ years of hands-on data engineering experience
Strong experience configuring datastreams, transformations, and destinations in Adverity or a comparable ETL platform such as Fivetran, Supermetrics, or Funnel
Intermediate to advanced SQL skills
Proven Google BigQuery experience in transformation, partitioning, and modeling
Expertise in dbt or Dataform
Python proficiency for custom API connections and pipeline automation
Experience with CRM data flows and integrations, including Slate, Salesforce, and/or HubSpot
Deep understanding of marketing metrics including ROAS, CPA, and CAC
Understanding of paid platform schemas and structuring data to optimize Looker Studio performance
Proficiency with Git and collaborative development workflows
Ability to manage multi-client data environments with strict data segregation
Strong communication skills for explaining complex data workflows to non-technical audiences
Education marketing experience is especially valued
Experience integrating AI-driven insights or machine learning models into marketing data pipelines is a bonus
Familiarity with AI or LLM tools is a bonus
Experience maintaining generative AI platform APIs is a bonus
Experience with AI/ML-driven anomaly detection is a bonus
Benefits
Remote role with flexibility in a distributed, async-friendly team
Competitive compensation based on experience and location
High-visibility role with real ownership of the agency's reporting infrastructure
Opportunity to build the data backbone for an agency serving education and nonprofit organizations
Culture focused on finding a better way, teamwork, and results
Direct impact on partners' performance data visibility and trust
Administrateur principal de plateformes de données chez EDC, société d’État aidant les entreprises canadiennes à réussir à l’étranger. Conception, exploitation et gouvernance de plateformes de données infonuagiques.
Senior Data Platform Administrator shaping and operating EDC’s secure enterprise data platforms. Supporting Canadian businesses through Export Development Canada’s trade - finance solutions.
Staff full - stack engineer architecting GitLab’s data products, integrations, and knowledge graph. Building APIs, marketplace data access, and AI - powered developer intelligence.
Data Governance Architect shaping governance strategies and cloud data architectures for Lovelytics’ enterprise data and AI consulting clients. Leading technical delivery, presales, migrations, and governance implementations on Databricks.
Senior Data Engineer owning Databricks lakes, pipelines, and AI data infrastructure. Building Quandri’s AI operating system for insurance agencies and brokerages.
Senior Data Engineer architecting Azure and Databricks data platforms for TTEC Digital’s client experience solutions. Building governed pipelines, APIs, MCP integrations, and agentic AI data services.
Senior Data Engineer building Palantir Foundry data solutions for Unit8, a Swiss AI and data analytics consultancy. Supporting client delivery and establishing its Canadian market presence.
Staff Software Engineer building AWS data infrastructure and integrations for Solink’s cloud video - security platform. Driving scalability, architecture, and engineering mentorship.
Senior Azure Fabric Data Engineer building reliable pipelines and modern data platforms for Data Elephant, a Canadian data, analytics, and AI consultancy. Delivering trusted datasets for reporting, AI, and machine learning.
Senior Data Architect leading Microsoft Fabric implementations for Data Elephant, a Canadian data, analytics, and AI consulting firm. Designing secure Azure, OneLake, and Fabric platforms for clients.