Senior Data Engineer, Marketing Analytics — Remote

INGEPSY; Sur; A distancia; COP 120.000.000 - 180.000.000; Jornada completa

Ventajas ofrecidas por este puesto de trabajo

Remote role

Descripción de la vacante

INGEPSY is seeking a Senior Data Engineer to centralize data from paid media and CRM into a single source of truth. You will own ingestion pipelines, CRM connections, and a scalable BigQuery warehouse, while building modular dbt/Dataform pipelines for multi-client reporting.

You will also drive CI/CD, data quality, and Looker Studio reporting to deliver trusted insights for education and nonprofit partners.

Formación

• 5+ years of hands-on data engineering, ideally in marketing or agency.
• Experience configuring datastreams, transformations, and destinations in ETL platforms.
• Intermediate to advanced SQL with BigQuery transformation experience.
• Expertise in modular, version-controlled SQL pipelines (dbt/Dataform).
• Python for custom API connections and automation; CRM data flows (Slate/Salesforce/HubSpot).

Responsabilidades

• Own data ingestion & pipeline architecture from sources to dashboards.
• Own CRM integration to feed warehouse with lead/enrollment data.
• Own the data warehouse in BigQuery with efficient schemas.
• Own transformation & mapping via modular dbt/Dataform pipelines.
• Manage CI/CD and data segregation across multi-client environments.
• Enable reporting with Looker Studio dashboards and automated sheets.

Conocimientos

SQL

BigQuery

dbt

Dataform

Python

CRM integration

ETL pipelines

Data modeling

Git

Marketing metrics

Herramientas

Adverity

Fivetran

Supermetrics

Funnel

Looker Studio

BigQuery

GitHub Actions

Descripción del empleo

INGEPSY is seeking a Senior Data Engineer to centralize data from paid media and CRM into a single source of truth. You will own ingestion pipelines, CRM connections, and a scalable BigQuery warehouse, while building modular dbt/Dataform pipelines for multi-client reporting.

You will also drive CI/CD, data quality, and Looker Studio reporting to deliver trusted insights for education and nonprofit partners.