Senior Web Analyst

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

📋 Description

• Take charge of data ingestion and pipeline architecture across various paid media platforms such as Meta, Google Ads, LinkedIn, TikTok, and programmatic.

• Develop custom Python connectors for data sources that lack native support.

• Design scalable pipelines that transition from source systems to dashboards.

• Establish and maintain CRM data connections for Slate, Salesforce, and HubSpot.

• Route, optimize, and store both raw and processed data within Google BigQuery.

• Create efficient schemas for complex multi-source marketing data, focusing on granularity, normalization, and slowly changing dimensions.

• Oversee partitioning, clustering, and storage strategies to manage query cost and performance effectively.

• Construct SQL schemas that map, blend, and organize data across multiple channels for clients.

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

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

• Ensure strict data segregation across environments serving multiple clients.

• Generate high-performance data views for Looker Studio dashboards and automated Google Sheets reports.

• Convert reporting requirements into warehouse models in collaboration with the Data and Analytics Manager and client teams.

• Monitor the health of pipelines, address API interruptions, minimize latency, and establish validation frameworks.

• Diagnose discrepancies across source, warehouse, and BI layers to identify root causes.

• Proactively alert leadership to any data quality risks.

⛳️ Requirements

• 5+ years of practical experience in data engineering, preferably within a marketing or agency setting.

• Extensive experience in configuring datastreams, transformations, and destinations within Adverity or an equivalent ETL platform (Fivetran, Supermetrics, Funnel).

• Intermediate to advanced SQL skills, with demonstrated BigQuery experience in transformation, partitioning, and modeling.

• Proficiency in dbt or Dataform, managing modular, version-controlled, and documented SQL transformation pipelines.

• Strong Python skills for creating custom API connections and automating pipelines.

• Familiarity with CRM data flows and integrations (Slate, Salesforce, and/or HubSpot).

• A comprehensive understanding of marketing metrics (ROAS, CPA, CAC) and schemas from paid platforms, with a proven ability to structure data for enhanced Looker Studio performance.

• Competence in using Git and engaging in collaborative development workflows.

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

• Excellent communication skills that translate complex data workflows into understandable narratives for non-technical audiences.

• Experience in education marketing is highly regarded.

• Exposure to integrating AI-driven insights or machine learning models into marketing data pipelines.

• Familiarity with AI or LLM tools for tasks such as performance forecasting, automated audience segmentation, or marketing workflows.

• Background in connecting, managing, and maintaining APIs for generative AI platforms within a marketing data architecture.

• Experience utilizing AI/ML-driven anomaly detection to oversee pipelines and proactively identify data quality issues.

🏝️ Benefits

• Remote position offering the flexibility of a distributed, async-friendly team.

• Competitive salary based on experience and location.

• A critical, high-visibility role in a growing Data & Analytics team, with genuine ownership of the agency's reporting infrastructure.

• Opportunity to build the data foundation for an agency whose partners are education and nonprofit organizations dedicated to creating a better world.

• Direct impact: the pipelines and models you create will significantly influence how partners perceive (and trust) their performance data.