Remote Data Engineer — Marketing Analytics (BigQuery)

Agileengine, Llc.; Santa Fe Capital; Remote; ARS 182,437,000 - 273,656,000; Full time

Benefits offered by this job

Remote work

Competitive compensation

Job summary

Agileengine, Llc. seeks a Senior Data Engineer (Marketing-oriented) to own end-to-end data pipelines from ads to warehouse and dashboards. You will integrate Meta, Google Ads, LinkedIn, TikTok, and CRM data into Adverity, build dbt/Dataform transformations, and feed Looker Studio reports.

Reporting to the Data and Analytics Manager, you will design scalable BigQuery schemas, enforce data quality, and enable automated reporting for education and nonprofit clients.

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 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.

Responsibilities

• 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— 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 schemas for multi-source marketing data; manage partitioning, clustering, and storage strategy.
• Own transformation & mapping— build SQL schemas that map, blend, and organize multi-channel data in modular dbt/Dataform pipelines.
• Own CI/CD & data segregation— maintain CI/CD pipelines (GitHub Actions, automated testing) for robust, version-controlled releases with strict data segregation.
• Enable the reporting layer— create clean data views for Looker Studio dashboards and Google Sheets reports; translate reporting requirements into warehouse models.
• Drive data quality— monitor pipelines, resolve API breaks, implement validation and testing, flag data quality risks.

Skills

Data engineering

ETL pipelines

SQL

BigQuery

dbt/Dataform

Python

CRM integration

Marketing metrics

Git

Education marketing

Tools

Adverity

Looker Studio

Job description

Agileengine, Llc. seeks a Senior Data Engineer (Marketing-oriented) to own end-to-end data pipelines from ads to warehouse and dashboards. You will integrate Meta, Google Ads, LinkedIn, TikTok, and CRM data into Adverity, build dbt/Dataform transformations, and feed Looker Studio reports.

Reporting to the Data and Analytics Manager, you will design scalable BigQuery schemas, enforce data quality, and enable automated reporting for education and nonprofit clients.