Data Engineer – Marketing-oriented

This is a fully remote position, open to applicants in Canada.

📋 Description

• Lead the data ingestion and pipeline architecture from paid media platforms through Adverity to dashboards.

• Establish and maintain API pipelines for Meta, Google Ads, LinkedIn, TikTok, and various programmatic platforms.

• Develop custom Python connectors for systems that are not supported.

• Create and manage CRM data connections for Slate, Salesforce, and HubSpot.

• Oversee Google BigQuery warehouse routing, optimization, storage, and schema design.

• Manage partitioning, clustering, and storage strategies to optimize query costs and performance.

• Construct modular, version-controlled, and well-documented dbt or Dataform transformation pipelines.

• Maintain CI/CD pipelines using GitHub Actions and implement automated testing.

• Enforce stringent data segregation across multi-client environments.

• Develop efficient data views for Looker Studio dashboards and automated Google Sheets reports.

• Collaborate with the Data and Analytics Manager and client teams to translate reporting requirements into warehouse models.

• Monitor pipeline health, address API interruptions, reduce latency, and troubleshoot discrepancies.

• Implement validation frameworks and conduct automated testing.

• Actively identify and communicate data quality risks to leadership.

⛳️ Requirements

• A minimum of 5 years of practical experience in data engineering.

• Extensive experience in configuring datastreams, transformations, and destinations in Adverity or a similar ETL platform such as Fivetran, Supermetrics, or Funnel.

• Intermediate to advanced proficiency in SQL.

• Demonstrated experience with Google BigQuery in transformation, partitioning, and modeling.

• Expertise in using dbt or Dataform.

• Proficient in Python for creating custom API connections and automating pipelines.

• Experience with CRM data flows and integrations, including Slate, Salesforce, and/or HubSpot.

• Comprehensive understanding of marketing metrics such as ROAS, CPA, and CAC.

• Knowledge of paid platform schemas and data structuring to enhance Looker Studio performance.

• Proficient with Git and collaborative development practices.

• Capability to manage multi-client data environments while ensuring strict data segregation.

• Excellent communication skills to convey complex data workflows to non-technical audiences.

• Experience in education marketing is highly valued.

• Familiarity with integrating AI-driven insights or machine learning models into marketing data pipelines is a plus.

• Knowledge of AI or LLM tools is a plus.

• Experience in maintaining APIs for generative AI platforms is a plus.

• Experience with AI/ML-driven anomaly detection is a plus.

🏝️ Benefits

• Flexible remote role within a distributed, async-friendly team.

• Competitive salary based on experience and location.

• High-visibility position with significant ownership of the agency's reporting infrastructure.

• Opportunity to establish the data backbone for an agency that supports education and nonprofit organizations.

• A culture that emphasizes finding innovative solutions, teamwork, and achieving results.

• Direct influence on enhancing partners' performance data visibility and trust.