Remote Data Engineer | BigQuery & GCP Expert

Caramel Point; Santa Fe Capital; Remote; ARS 4,464,000 - 7,812,000; Full time

Benefits offered by this job

Remote role

Competitive compensation

Job summary

Caramel Point is seeking a Senior Data Engineer focused on marketing data to consolidate paid media and CRM sources into a single BigQuery warehouse. You will build modular, version-controlled pipelines (dbt/Dataform), connect Adverity with Python connectors, and ensure data quality for Looker Studio dashboards and automated reports.

The role emphasizes strong SQL, CRM integrations (Slate/Salesforce/HubSpot), and cross-team collaboration to scale reporting for education and nonprofit clients.

Qualifications

• 5+ years 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 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)
• Understanding of marketing metrics (ROAS, CPA, CAC) and paid platform schemas, with ability to optimize Looker Studio performance
• Proficiency with Git and collaborative development workflows, and ability to manage multi-client data environments with strict data segregation
• Analytical, solution-driven mindset with growth orientation and strong communication; education marketing experience valued

Responsibilities

• Own data ingestion & pipeline architecture — connect and maintain API pipelines from paid media platforms into Adverity; build custom Python connectors; architect scalable pipelines
• Own CRM integration — build and maintain reliable CRM data connections into the warehouse
• Own the data warehouse — design and manage BigQuery schemas, partitioning, clustering, and storage strategy
• Own transformation & mapping — build modular, version-controlled SQL schemas for multi-channel data in dbt/Dataform pipelines
• Own CI/CD & data segregation — maintain GitHub Actions and automated testing for multi-client environments
• Enable the reporting layer — create fast data views for Looker Studio dashboards and Google Sheets reports
• Drive data quality — monitor pipelines, validate data, troubleshoot discrepancies, flag risks to leadership

Skills

Data engineering

SQL

Data modeling

Python

Analytical mindset

Communication skills

Tools

Adverity

Fivetran

Supermetrics

Funnel

dbt

Dataform

Git

Slate

Salesforce

HubSpot

Looker Studio

Job description

Caramel Point is seeking a Senior Data Engineer focused on marketing data to consolidate paid media and CRM sources into a single BigQuery warehouse. You will build modular, version-controlled pipelines (dbt/Dataform), connect Adverity with Python connectors, and ensure data quality for Looker Studio dashboards and automated reports.

The role emphasizes strong SQL, CRM integrations (Slate/Salesforce/HubSpot), and cross-team collaboration to scale reporting for education and nonprofit clients.