Senior Web Analytics Engineer - Remote

North Davis Project Illumination; Región Centro; Remote; MXN 850.000 - 1.200.000; Vollzeit

Benefits dieser Stelle

Remote role

Competitive compensation

High-visibility Data & Analytics role

Zusammenfassung

North Davis Project Illumination is seeking a Senior Web Analyst to own end‑to‑end data pipelines, from paid media and CRM sources into a centralized data warehouse. You will build robust connectors, design scalable BigQuery schemas, and implement modular dbt/Dataform transformations to support Looker Studio dashboards and automated reporting.

You will collaborate with the Data and Analytics Manager to evolve the reporting suite, ensure data quality, and enable accurate, trustable insights for

Qualifikationen

• 5+ years in data engineering or analytics, ideally in marketing/agency
• Strong SQL and BigQuery experience for transformation and modeling
• Proficiency in dbt or Dataform and modular pipelines
• Python for custom connectors and automation
• Experience with CRM data flows (Salesforce, HubSpot, Slate)
• Understanding of marketing metrics (ROAS, CPA, CAC) and paid-platform schemas
• Git and multi-client data environment management with strict data segregation
• Ability to translate complex data workflows into clear narratives for non-technical audiences

Aufgaben

• Own data ingestion & pipeline architecture from paid media and CRM into the warehouse
• Build and maintain reliable CRM data connections (Slate, Salesforce, HubSpot)
• Manage data warehouse in BigQuery, schemas, partitioning, and cost optimization
• Develop SQL mappings and transformations in dbt/Dataform with clear conventions
• Maintain CI/CD pipelines with testing and data segregation across clients
• Support reporting layer for Looker Studio dashboards and automated reports
• Monitor data quality, troubleshoot issues, and communicate findings to leadership

Kenntnisse

SQL

BigQuery

Python

API integration

CRM data flows

Data storytelling

Git

Data quality

Ausbildung

Bachelor's degree in CS/Engineering/Analytics

Tools

Adverity

dbt

Dataform

Looker Studio

BigQuery

Jobbeschreibung

North Davis Project Illumination is seeking a Senior Web Analyst to own end‑to‑end data pipelines, from paid media and CRM sources into a centralized data warehouse. You will build robust connectors, design scalable BigQuery schemas, and implement modular dbt/Dataform transformations to support Looker Studio dashboards and automated reporting.

You will collaborate with the Data and Analytics Manager to evolve the reporting suite, ensure data quality, and enable accurate, trustable insights for