Senior Data Engineer - Marketing Analytics (Remote)

INGEPSY; Colombia; A distancia; COP 280.260.000 - 373.680.000; Jornada completa

Ventajas ofrecidas por este puesto de trabajo

Remote role

Impactful projects

Descripción de la vacante

INGEPSY is seeking a Senior Data Engineer to anchor the agency’s data and analytics work. You’ll connect paid media platforms and CRMs into a single source of truth, move data from sources through Adverity into a BigQuery warehouse, and deliver modular dbt/Dataform pipelines and Looker Studio dashboards.

You’ll own ingestion pipelines, CRM integrations, and the warehouse, ensuring data quality and scalable performance across multi-client environments.

Formación

• 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 pipelines.
• Python proficiency for custom API connections and pipeline automation.
• Experience with CRM data flows and integrations (Slate, Salesforce, and/or HubSpot).
• Deep understanding of marketing metrics (ROAS, CPA, CAC) and paid platform schemas.

Responsabilidades

• Own data ingestion & pipeline architecture across paid media and CRM sources.
• Build and maintain reliable CRM connections (Slate, Salesforce, HubSpot).
• Own the data warehouse in BigQuery and design scalable schemas.
• Develop modular, version-controlled dbt/Dataform transformations.
• Maintain CI/CD pipelines and enforce multi-client data segregation.
• Create fast Looker Studio dashboards and automated Google Sheets reports.
• Monitor data quality, troubleshoot API breaks, and optimize performance.

Conocimientos

Data engineering

SQL

BigQuery

dbt/Dataform

Python

Adverity

CRM integration

Git

Communication

Herramientas

Adverity

Fivetran

Supermetrics

Funnel

Looker Studio

Descripción del empleo

INGEPSY is seeking a Senior Data Engineer to anchor the agency’s data and analytics work. You’ll connect paid media platforms and CRMs into a single source of truth, move data from sources through Adverity into a BigQuery warehouse, and deliver modular dbt/Dataform pipelines and Looker Studio dashboards.

You’ll own ingestion pipelines, CRM integrations, and the warehouse, ensuring data quality and scalable performance across multi-client environments.