Senior Web Data Engineer - Remote & Impactful Analytics

Atomic Hr; Ciudad Juárez; A distancia; MXN 900.000 - 1.500.000; Jornada completa

Ventajas ofrecidas por este puesto de trabajo

Remote role

Descripción de la vacante

Atomic HR is seeking a Senior Web Analyst to own data ingestion, CRM integrations, and the data warehouse for education and nonprofit clients. You will design scalable pipelines from API sources to Looker Studio dashboards, ensuring data quality and reliability across multi-client environments.

You will collaborate with the Data and Analytics Manager and client teams to translate reporting needs into robust warehouse models, leveraging Adverity, dbt/Dataform, and Python-driven integrations.

Formación

• 5+ years of hands-on data engineering experience.
• Experience configuring datastreams and ETL pipelines in Adverity or similar platforms.
• Strong SQL with BigQuery modeling experience.
• Proficient Python for API connections and automation.
• CRM data flows and integrations experience.
• Understanding of marketing metrics (ROAS, CPA) and paid platform schemas.

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.
• Own CRM integration — maintain reliable CRM data connections (Slate, Salesforce, HubSpot) so lead data flows into the warehouse.
• Own the data warehouse — manage raw and processed data in Google BigQuery, design schemas, partitioning, and storage strategy.
• Own transformation & mapping — build modular SQL schemas for multi-channel data in dbt/Dataform pipelines with consistent naming conventions.
• Own CI/CD & data segregation — maintain CI/CD pipelines (GitHub Actions) for robust releases and enforce data segregation across multi-client environments.
• Enable the reporting layer — create clean data views for Looker Studio dashboards and Google Sheets reports, translating requirements into warehouse models.
• Drive data quality — monitor pipelines, resolve API breaks, minimize latency, and flag data quality risks to leadership.

Conocimientos

Data engineering

SQL

Python

CRM integrations

Looker Studio

Git & CI/CD

Herramientas

Adverity

dbt/Dataform

BigQuery

Fivetran

Supermetrics

Funnel

Descripción del empleo

Atomic HR is seeking a Senior Web Analyst to own data ingestion, CRM integrations, and the data warehouse for education and nonprofit clients. You will design scalable pipelines from API sources to Looker Studio dashboards, ensuring data quality and reliability across multi-client environments.

You will collaborate with the Data and Analytics Manager and client teams to translate reporting needs into robust warehouse models, leveraging Adverity, dbt/Dataform, and Python-driven integrations.