Remote Senior Data Engineer - Web Analytics

Atomic Hr; Tabasco; A distancia; MXN 900.000 - 1.500.000; Jornada completa

Ventajas ofrecidas por este puesto de trabajo

Remote role

Competitive compensation based on 경험

Ownership over reporting infra

High-visibility Data & Analytics team

Impact on education/nonprofit partners

Collaborative, async-friendly culture

Descripción de la vacante

Atomic HR busca un Senior Web Analyst para unificar datos de campañas, CRM y reporting dentro de una agencia de marketing de rendimiento. Serás el nexo entre Adverity, BigQuery y Looker Studio, asegurando un flujo de datos fiable y escalable.

Trabajarás en pipelines, modelado de datos, pruebas y calidad, con enfoque en educación y organizaciones sin fines de lucro. Remoto, con equipo distribuido y crecimiento de cartera de clientes.

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 to dashboard
• Own CRM integration — build and maintain reliable CRM data connections so lead and enrollment data flows into the warehouse
• Own the data warehouse — route, optimize, and store raw and processed data in Google BigQuery; design efficient schemas for multi-source data
• Own transformation & mapping — build SQL schemas that map, blend, and organize multi-channel data in modular dbt/Dataform pipelines with standardized naming
• Own CI/CD & data segregation — maintain CI/CD pipelines (GitHub Actions, automated testing) for robust releases and enforce data segregation
• Enable the reporting layer — create clean data views for Looker Studio dashboards and automated Google Sheets reports
• Drive data quality — monitor pipelines, resolve API breaks, validate data and flag risks to leadership

Conocimientos

SQL

BigQuery

dbt/Dataform

Python

Git

Looker Studio

CRM integrations

ETL pipelines

Data quality

Communication

Herramientas

Adverity

Fivetran

Supermetrics

Funnel

GitHub Actions

Descripción del empleo

Atomic HR busca un Senior Web Analyst para unificar datos de campañas, CRM y reporting dentro de una agencia de marketing de rendimiento. Serás el nexo entre Adverity, BigQuery y Looker Studio, asegurando un flujo de datos fiable y escalable.

Trabajarás en pipelines, modelado de datos, pruebas y calidad, con enfoque en educación y organizaciones sin fines de lucro. Remoto, con equipo distribuido y crecimiento de cartera de clientes.