Senior Platform Engineer - Remote, Ai-Driven Devops

Oyster

Santa Fe Capital

Remote

ARS 129,136,000 - 182,310,000

Full time

5 days ago

Be an early applicant

Application generator

Get a reply from this employer — a resume and cover letter tailored to exactly what they’re hiring for.

Get past ATS filters

Benefits offered by this job

Remote role

Competitive compensation

High-visibility data projects

Job summary

Oyster is seeking a Senior Data Engineer focused on marketing analytics to own data ingestion, CRM integrations, and the data warehouse. You will implement scalable pipelines from paid media and CRM sources into a BigQuery warehouse, build modular dbt/Dataform transformations, and enable fast Looker Studio dashboards.

The role emphasizes data quality, CI/CD practices, and cross-team collaboration for a growing education and nonprofit client base.

Qualifications

5+ years of hands-on data engineering experience, ideally in a marketing or agency environment.
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 with dbt or Dataform, modular and version-controlled SQL pipelines.
Python proficiency for custom API connections and automation.
Experience with CRM data flows (Slate, Salesforce, HubSpot)
Strong understanding of marketing metrics (ROAS, CPA, CAC) and platform schemas.

Responsibilities

Own data ingestion & pipeline architecture from paid media and CRM into Adverity and warehouse.
Build reliable CRM connections (Slate, Salesforce, HubSpot) ensuring clean data flow to the warehouse.
Design and optimize BigQuery schemas, partitioning, and storage for multi-source marketing data.
Create modular, documented dbt/Dataform transformations with consistent naming and metrics.
Maintain CI/CD pipelines (GitHub Actions) and enforce data segregation across multi-client environments.
Deliver reporting-ready data views for Looker Studio dashboards and automated Sheets reports.
Monitor pipelines, validate data quality, troubleshoot issues and reduce latency.

Skills

Data engineering

ETL pipelines

SQL (BigQuery)

dbt / Dataform

Python

CRM integrations

Data quality

Git / CI/CD

Data storytelling

Tools

Adverity

Fivetran

Supermetrics

Funnel

BigQuery

dbt

Dataform

Looker Studio

GitHub Actions

Job description

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

Our client is a fast-growing performance marketing agency specializing in mission-driven organizations across higher education and nonprofit sectors. Since launching in 2020, the agency has built a strong reputation for combining strategic thinking, creative execution, and data-driven marketing to help universities and organizations achieve measurable growth.

Company Overview:

Your Role:

The Senior Data Engineer sits at the center of the agency's Data and Analytics function, connecting every paid media platform and CRM the agency touches into a single, reliable source of truth. You'll own the full path data takes: from a client's ad accounts and CRM, through Adverity, into a BigQuery warehouse, through modular dbt/Dataform transformations, and out to the Looker Studio dashboards and automated Google Sheets reports the team and its partners rely on daily. Reporting to the Data and Analytics Manager, you're joining at a pivotal moment — the agency is scaling its roster of education and nonprofit partners, and this role is instrumental in evolving the automated reporting suite that makes that growth possible without sacrificing data quality or client trust.

You’ll:

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 anything not natively supported, and architect scalable pipelines from source system through to dashboard
Own CRM integration — build and maintain reliable CRM data connections (Slate, Salesforce, HubSpot) so lead and enrollment data flows cleanly into the warehouse
Own the data warehouse — route, optimize, and store raw and processed data in Google BigQuery; design efficient schemas for complex, multi-source marketing data (granularity, normalization, slowly changing dimensions); manage partitioning, clustering, and storage strategy to control query cost and performance
Own transformation & mapping — build SQL schemas that map, blend, and organize multi-channel data accurately for each client, in modular, version-controlled, documented dbt or Dataform pipelines, with standardized naming conventions and metric definitions across platforms and clients
Own CI/CD & data segregation — maintain CI/CD pipelines (GitHub Actions, automated testing) for robust, version-controlled releases, and enforce strict data segregation across multi-client environments
Enable the reporting layer — create clean, performant data views built specifically for fast Looker Studio dashboards and automated Google Sheets reports, and partner 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 to root cause across source/warehouse/BI layers, and proactively flag data quality risks to leadership

You Bring:

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

Bonus Points:

Experience integrating AI‑driven insights or machine learning models into marketing data pipelines to sharpen predictive analytics and data utility
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

What’s Offered:

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

Interview Process:

Application Review (resume + a few questions)
Screening Call with Atomic HR
Hiring Team Interview (walkthrough of a pipeline or data model you've built)
Technical Assessment (a real‑world data engineering case study)
Final Interview with company leadership

About the Role:

This role is focused on the backend of an analytics and data processing platform built around dashboards, attribution and large‑scale analytical processing.

What You Will Do:

Maintain and evolve the platform
Investigate and fix production issues
Work with complex SQL scripts and stored procedures
Investigate data inconsistencies and business rules
Provide operational technical support related to dashboards and data processing
Work with integrations and asynchronous workflows
Participate in troubleshooting and performance analysis
Adjust backend features and business rules
Help improve internal automations and platform workflows

Requirements:

Strong experience with C# and .NET (5 years +)
Intermediate to advanced SQL skills, including complex scripts, stored procedures and performance optimization
Experience troubleshooting production environments
Intermediate English with ability to communicate in technical discussions, participate in meetings and collaborate in an international environment

Nice to Have:

Experience with ETL or data processing
Experience working with large data volumes
Experience with analytics, BI or dashboard platforms
Experience with Snowflake or analytical databases
Experience with asynchronous workflows
Experience with integrations and APIs
Familiarity with using AI tools in development and technical troubleshooting workflows