Senior Data Engineer - ETL (Python, BigQuery) - Remote

Bluelight Consulting, Llc; La Pampa; Remote; ARS 136,863,000 - 197,692,000; Full time

Benefits offered by this job

Remote role

Job summary

Bluelight Consulting, Llc is seeking a Senior Data Engineer with a marketing‑oriented focus to join a remote team serving education and nonprofit clients. You will own end‑to‑end data pipelines from paid media to the warehouse, integrate CRM data, and design scalable BigQuery solutions that power Looker Studio dashboards and automated reporting.

You will implement modular dbt/Dataform transformations, maintain CI/CD pipelines, and ensure data quality across multi‑client environments while

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.
• Intermediate to advanced SQL, with proven BigQuery experience in transformation, partitioning, and modeling.
• Expertise in dbt or Dataform, managing modular, version-controlled 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.

Responsibilities

• Own data ingestion & pipeline architecture — connect paid media pipelines into Adverity, build Python connectors, and architect scalable pipelines.
• Own CRM integration — maintain reliable CRM data connections (Slate, Salesforce, HubSpot).
• Own the data warehouse — manage BigQuery schemas, partitioning, and storage strategy.
• Own transformation & mapping — build modular SQL schemas in dbt/Dataform pipelines with clear naming conventions.
• Own CI/CD & data segregation — maintain GitHub Actions pipelines and enforce data isolation across multi-client environments.
• Enable the reporting layer — create data views for Looker Studio dashboards and automated Google Sheets reports.
• Drive data quality — monitor pipelines, run validations, and troubleshoot data quality issues.

Skills

Data engineering

SQL

BigQuery

dbt

Python

CRM data

Marketing metrics

Git

Tools

Adverity

Fivetran

Supermetrics

Funnel

Looker Studio

Google Sheets

Job description

Bluelight Consulting, Llc is seeking a Senior Data Engineer with a marketing‑oriented focus to join a remote team serving education and nonprofit clients. You will own end‑to‑end data pipelines from paid media to the warehouse, integrate CRM data, and design scalable BigQuery solutions that power Looker Studio dashboards and automated reporting.

You will implement modular dbt/Dataform transformations, maintain CI/CD pipelines, and ensure data quality across multi‑client environments while