Senior Data Engineer - Remote Marketing Analytics Pipelines

INGEPSY; Medellín; A distancia; COP 120.000.000 - 180.000.000; Jornada completa

Ventajas ofrecidas por este puesto de trabajo

Remote-friendly team

Descripción de la vacante

INGEPSY is a fast-growing data-driven agency seeking a Senior Data Engineer to stitch data across paid media, CRM, and analytics into a single source of truth. You will own ingestion pipelines, CRM connections, and the data warehouse in BigQuery, plus modular transformations in dbt/Dataform.

You’ll enable fast Looker Studio dashboards and automated reporting while keeping data quality high. The role requires 5+ years in data engineering (marketing/agency preferred), strong SQL, Python, and

Formación

• 5+ years hands-on data engineering experience, preferably in marketing or agency settings.
• Strong experience configuring datastreams and transformations in ETL platforms (Adverity, Fivetran, Supermetrics, Funnel).
• Advanced SQL with BigQuery experience in transformation and modeling.
• Expertise in modular, version-controlled SQL pipelines using dbt or Dataform.
• 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 paid platform schemas.

Responsabilidades

• Own data ingestion & pipeline architecture — connect APIs from paid media platforms into Adverity and build scalable pipelines.
• Own CRM integration — ensure lead/enrollment data flows into the warehouse.
• Own the data warehouse — design schemas in BigQuery and manage partitioning, clustering, and storage.
• Own transformation & mapping — create modular, version-controlled SQL transformations in dbt/Dataform.
• Own CI/CD & data segregation — maintain CI/CD pipelines and enforce data segregation across multi-client environments.
• Enable the reporting layer — create clean views for Looker Studio dashboards and automated Google Sheets reports.
• Drive data quality — monitor pipelines, validate data, and flag issues to leadership.

Conocimientos

Data engineering

SQL

BigQuery

dbt/Dataform

Python

ETL pipelines

API integration

Looker Studio

Git

CI/CD

Data quality

CRM integrations

Herramientas

Adverity

Fivetran

Supermetrics

Funnel

Dataform

dbt

Descripción del empleo

INGEPSY is a fast-growing data-driven agency seeking a Senior Data Engineer to stitch data across paid media, CRM, and analytics into a single source of truth. You will own ingestion pipelines, CRM connections, and the data warehouse in BigQuery, plus modular transformations in dbt/Dataform.

You’ll enable fast Looker Studio dashboards and automated reporting while keeping data quality high. The role requires 5+ years in data engineering (marketing/agency preferred), strong SQL, Python, and