Data Engineer (Marketing-oriented) | Remote for Marketing Agency for Education

Atomic HR • Montevideo, Latam

11h • Remote

About The Position

The Senior Data Engineer will be central to the agency's Data and Analytics function, responsible for integrating various paid media platforms and CRMs into a unified and reliable data source. This role involves managing the entire data lifecycle, from client ad accounts and CRMs, through Adverity, into a BigQuery warehouse, and then through dbt/Dataform transformations to Looker Studio dashboards and automated Google Sheets reports. The position reports to the Data and Analytics Manager and is crucial for scaling the agency's automated reporting suite to support growth in the education and nonprofit sectors, while maintaining high data quality and client trust.

Requirements

• 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.
• Proven ability to manage multi-client data environments with strict data segregation.
• An analytical, solution-driven mindset with a growth orientation.
• Strong communication skills that turn complex data workflows into clear narratives for non-technical audiences.

Nice To Haves

• Education marketing experience (traditional or online) is especially valued.
• Experience integrating AI-driven insights or machine learning models into marketing data pipelines.
• Familiarity using AI or LLM tools to optimize performance forecasting, automated audience segmentation, or marketing workflows.
• Experience connecting, managing, and maintaining APIs for generative AI platforms within a marketing data architecture.
• Experience using AI/ML-driven anomaly detection to monitor pipelines and proactively flag data quality issues.

Responsibilities

• Own data ingestion & pipeline architecture: connect and maintain API pipelines from paid media platforms (Meta, Google Ads, LinkedIn, TikTok, programmatic) into Adverity, build custom Python connectors for unsupported platforms, and architect scalable pipelines from source to dashboard.
• Own CRM integration: build and maintain reliable CRM data connections (Slate, Salesforce, HubSpot) for clean flow of lead and enrollment data into the warehouse.
• Own the data warehouse: route, optimize, and store raw and processed data in Google BigQuery; design efficient schemas for complex marketing data, managing partitioning, clustering, and storage for cost and performance.
• Own transformation & mapping: build SQL schemas in dbt or Dataform to map, blend, and organize multi-channel data accurately for each client, ensuring modularity, version control, documentation, and standardized naming conventions.
• Own CI/CD & data segregation: maintain CI/CD pipelines (GitHub Actions, automated testing) for robust 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, and collaborate with the Data and Analytics Manager and client teams to translate reporting requirements into warehouse models.
• Drive data quality: monitor pipeline health, resolve API breaks, minimize latency, implement validation frameworks and automated testing, troubleshoot discrepancies, and proactively flag data quality risks.

Benefits

• Remote role with the flexibility that comes with a distributed, async-friendly team
• Competitive compensation based on experience and location
• A pivotal, high-visibility seat on a scaling Data & Analytics team, with real ownership over the agency's reporting infrastructure
• The chance to build the data backbone for an agency whose partners are education and nonprofit organizations working to build a better world
• A culture built around finding a better way, playing as a team of A-players, and treating results as the engine rather than the goal
• Direct impact: the pipelines and models you build directly shape how partners see (and trust) their own performance data

What This Job Offers

• Job Type: Full-time
• Career Level: Senior
• Education Level: No Education Listed