Remote Marketing Data Engineer: BigQuery & Looker Studio

Atomic Hr; La Pampa; Remote; ARS 136,732,000 - 197,502,000; Full time

Benefits offered by this job

Remote role

Competitive compensation

Job summary

Marketing Agency for Education seeks a Senior Data Engineer to connect paid media channels, CRMs, and warehouse data into a single source of truth. The role focuses on designing scalable pipelines from Adverity through a BigQuery warehouse to Looker Studio dashboards and automated reporting.

You will own data quality, CI/CD, and multi-client data segregation, enabling reliable education marketing analytics and partner reporting across education and nonprofit sectors.

Qualifications

• 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 comparable ETL platforms.
• Intermediate to advanced SQL, with BigQuery experience in transformation, partitioning, and modeling.
• Expertise in dbt or Dataform, managing modular, version-controlled SQL pipelines.
• Python proficiency for custom API connections and pipeline automation.

Responsibilities

• Own data ingestion & pipeline architecture — connect and maintain API pipelines from paid media platforms into Adverity, build Python connectors, and architect scalable pipelines from source to dashboard.
• Own CRM integration — build and maintain reliable CRM data connections (Slate, Salesforce, HubSpot) so lead and enrollment data flow into the warehouse.
• Own the data warehouse — route, optimize, and store data in Google BigQuery; design schemas for multi-source marketing data and manage partitioning and storage strategy.
• Own transformation & mapping — build SQL schemas that map, blend, and organize multi-channel data in modular dbt/Dataform pipelines with consistent naming and metrics.
• Own CI/CD & data segregation — maintain CI/CD pipelines (GitHub Actions) for robust, version-controlled releases and enforce data segregation across multi-client environments.
• Enable the reporting layer — create clean data views for Looker Studio dashboards and automated Sheets reports, translating requirements into warehouse models.
• Drive data quality — monitor pipelines, resolve API breaks, minimize latency, implement validation and testing, flag data quality risks.

Skills

Data engineering

SQL

BigQuery

dbt

Dataform

Python

APIs

Adverity

CRM integrations

Looker Studio

Git

CI/CD

APIs for ERP/CRM

Tools

Adverity

Fivetran

Supermetrics

Funnel

Google BigQuery

Looker Studio

dbt

Dataform

GitHub Actions

Slate

Salesforce

HubSpot

Job description

Marketing Agency for Education seeks a Senior Data Engineer to connect paid media channels, CRMs, and warehouse data into a single source of truth. The role focuses on designing scalable pipelines from Adverity through a BigQuery warehouse to Looker Studio dashboards and automated reporting.

You will own data quality, CI/CD, and multi-client data segregation, enabling reliable education marketing analytics and partner reporting across education and nonprofit sectors.