Remote Cloud Platform Engineer: Bi & Sql Expert

Ontrac Solutions LLC.

Ciudad de Mendoza

A distancia

ARS 139.086.000 - 185.448.000

Jornada completa

Hace 13 días

Una candidatura completa en un minuto

Currículum y carta de presentación personalizados, listos para enviar.

Supera los filtros ATS

Ventajas ofrecidas por este puesto de trabajo

Remote role
Competitive compensation
Ownership of reporting infrastructure
Impact on education/nonprofit partners
Async-friendly team

Descripción de la vacante

Ontrac Solutions Llc. is seeking an experienced Data Engineer (Marketing-oriented) to centralize data from paid media and CRM sources into a BigQuery warehouse.

You will design scalable pipelines, integrate CRM data, and create modular dbt/Dataform transformations for robust dashboards in Looker Studio. You will collaborate with the analytics manager and client teams to translate reporting requirements into reliable warehouse models and automated reports, with a focus on data quality and

Formación

  • 5+ years of hands-on data engineering in marketing or agency settings.
  • Experience configuring datastreams and destinations in ETL platforms like Adverity.
  • Advanced SQL with BigQuery—transforms, partitioning, modeling.
  • Expertise in dbt or Dataform pipelines with clear versioning.
  • Python proficiency for custom API connections and automation.
  • CRM data flows (Slate, Salesforce, HubSpot) and their integration.
  • Strong understanding of ROAS, CPA, CAC and platform schemas.
  • Proficient Git and multi-client data environment management.
  • Analytical mindset with clear communication for non-technical audiences.

Responsabilidades

  • Own data ingestion & pipeline architecture—connect ad platforms to Adverity and build Python connectors.
  • Own CRM integration—maintain reliable CRM connections (Slate, Salesforce, HubSpot) into the warehouse.
  • Own the data warehouse—manage BigQuery schemas, partitioning, and storage strategy.
  • Own transformation & mapping—build modular, version-controlled SQL in dbt or Dataform.
  • Own CI/CD & data segregation—maintain GitHub Actions pipelines for releases and client isolation.
  • Enable the reporting layer—craft data views for Looker Studio dashboards and Sheets reports.

Conocimientos

SQL
BigQuery
dbt/Dataform
Python
Adverity
ETL pipelines
CRM integrations
Marketing metrics
Git

Educación

Bachelor's in CS/SE

Herramientas

Fivetran
Supermetrics
Looker Studio
GitHub Actions
BigQuery tooling

Descripción del empleo

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:

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.

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

Consigue la evaluación confidencial y gratuita de tu currículum.

o arrastra y suelta tu archivo aquí

Similar jobs

Puestos de trabajo similares que vale la pena comparar

Remote Cloud Platform Engineer: Bi & Sql Expert
Remote Cloud Platform Engineer: Bi & Sql Expert

Ontrac Solutions LLC. • Rosario

A distancia
ARS 92.909.000 - 139.364.000
Remote role
Competitive compensation
High-visibility role on scaling team
+3
Senior Bi & Backend Engineer - Remote
Senior Bi & Backend Engineer - Remote

Bridgenext • Ciudad de Mendoza

A distancia
ARS 108.178.000 - 169.994.000
Remote role
Competitive compensation
Ownership of reporting infra
+2
Remote Senior Ai-Driven Marketing Engineer
Remote Senior Ai-Driven Marketing Engineer

The Flex • Rosario

A distancia
ARS 84.997.000 - 131.359.000
Remote role
Competitive compensation
High-visibility role
+2
Remote Senior Ai-Driven Marketing Engineer
Remote Senior Ai-Driven Marketing Engineer

The Flex • Municipio de Juan José Castelli

A distancia
ARS 1.000.000 - 2.500.000
Remote role
Async-friendly team
Ownership of reporting infrastructure
Spanish-Speaking Data Architect - Remote & Growth
Spanish-Speaking Data Architect - Remote & Growth

N-iX LTD • Santa Fe Capital

A distancia
ARS 1.500.000 - 2.100.000
Remote work
Competitive compensation
High-visibility role
+3
Remote Growth Engineer: Automate Data & Bi Insights
Remote Growth Engineer: Automate Data & Bi Insights

Atomic Hr • Rosario

A distancia
ARS 92.666.000 - 154.443.000
Remote work
Remote Data & Bi Ops Coordinator (Power Bi + Sql)
Remote Data & Bi Ops Coordinator (Power Bi + Sql)

Avicado Construction Technology Services, LLC • Santa Fe Capital

A distancia
ARS 139.086.000 - 200.903.000
Remote role
Competitive compensation
High-visibility role
+1
Senior Remote Full-Stack Engineer – Bi & Power Bi Expert
Senior Remote Full-Stack Engineer – Bi & Power Bi Expert

Fullstack • Santa Fe Capital

A distancia
ARS 1.800.000 - 2.600.000
Remote work flexibility
Competitive compensation
High-visibility role on scaling Data &
+1
Senior Cloud Data Engineer - Remote Ai & Analytics
Senior Cloud Data Engineer - Remote Ai & Analytics

Alignerr Corp. • Santa Fe Capital

A distancia
ARS 1.800.000 - 3.000.000
Remote work
Competitive pay
High-visibility role
+2
Remote Backend Engineer | Graphql, Java/Kotlin & Bi Data
Remote Backend Engineer | Graphql, Java/Kotlin & Bi Data

BairesDev • Ciudad de Mendoza

A distancia
ARS 139.312.000 - 232.187.000