Senior Web Analytics Engineer — Remote Data & BI Pipelines

Atomic Hr; Morelia; A distancia; MXN 600.000 - 840.000; Jornada completa

Ventajas ofrecidas por este puesto de trabajo

Remote role

Competitive compensation

Impactful data projects

Descripción de la vacante

Atomic HR is seeking a Senior Web Analyst to lead data engineering across multi‑source marketing data, CRM integrations, and warehouse management. You’ll architect pipelines from paid media to dashboards, ensure data quality, and enable Looker Studio reporting for education and nonprofit partners.

You’ll collaborate with a scaling Data & Analytics team, own CI/CD, and build modular dbt/Dataform pipelines while maintaining strict data segregation for multi-client environments.

Formación

• 5+ years of hands-on data engineering experience, ideally in a marketing or agency environment.
• Strong experience configuring datastreams, transformations, and destinations in Adverity or a comparable ETL platform (Fivetran, Supermetrics, Funnel)
• Intermediate to advanced SQL, with proven BigQuery experience in transformation, partitioning, and modeling
• Expertise in dbt or Dataform, managing modular, version-controlled, documented SQL transformation pipelines
• Python proficiency for custom API connections and pipeline automation
• Experience with CRM data flows and integrations (Slate, Salesforce, and/or HubSpot)
• A deep understanding of marketing metrics (ROAS, CPA, CAC) and paid platform schemas, with a proven track record of structuring data to optimize Looker Studio performance
• Proficiency with Git and collaborative development workflows, and proven ability to manage multi-client data environments with strict data segregation
• An analytical, solution‑driven mindset with a growth orientation, and strong communication skills that turn complex data workflows into clear narratives for non‑technical audiences — education marketing experience (traditional or online) is especially valued

Responsabilidades

• Own data ingestion & pipeline architecture — connect and maintain API pipelines from paid media platforms into Adverity, build custom Python connectors, and architect scalable pipelines from source system through to dashboard
• Own CRM integration — build and maintain reliable CRM data connections so lead and enrollment data flows cleanly into the warehouse
• Own the data warehouse — route, optimize, and store raw and processed data in Google BigQuery; design efficient schemas for multi-source marketing data
• Own transformation & mapping — build SQL schemas that map, blend, and organize multi-channel data in modular, version-controlled pipelines
• Own CI/CD & data segregation — maintain CI/CD pipelines (GitHub Actions, automated testing) for robust, version-controlled releases, and enforce strict data segregation across multi-client environments
• Enable the reporting layer — create clean, performant data views for Looker Studio dashboards and automated Google Sheets reports
• Drive data quality — monitor pipeline health, resolve API breaks, minimize latency, implement validation frameworks and automated testing

Conocimientos

Data engineering

SQL

BigQuery

Python

dbt/Dataform

Looker Studio

API integration

Git

Herramientas

Adverity

BigQuery

dbt

Dataform

GitHub Actions

Descripción del empleo

Atomic HR is seeking a Senior Web Analyst to lead data engineering across multi‑source marketing data, CRM integrations, and warehouse management. You’ll architect pipelines from paid media to dashboards, ensure data quality, and enable Looker Studio reporting for education and nonprofit partners.

You’ll collaborate with a scaling Data & Analytics team, own CI/CD, and build modular dbt/Dataform pipelines while maintaining strict data segregation for multi-client environments.