Senior Data Engineer: Marketing Analytics & Data Pipelines

INGEPSY; Cartagena de Indias; A distancia; COP 280.260.000 - 404.820.000; Jornada completa

Ventajas ofrecidas por este puesto de trabajo

Remote role

Competitive compensation

High-visibility role

Impactful work with education/nonprofit

Asynchronous-friendly team

Descripción de la vacante

INGEPSY is hiring a Senior Data Engineer to anchor the agency's data and analytics function. You will own end-to-end data ingestion, CRM connections, and the BigQuery warehouse, building modular dbt/Dataform pipelines and robust CI/CD with GitHub Actions.

Remote-first: collaborate with education and nonprofit partners, optimize Looker Studio dashboards, and ensure data quality across multi-client environments for scalable reporting and insights.

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 (Fivetran, Supermetrics, Funnel).
• Intermediate to advanced SQL, with proven 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).
• A deep understanding of marketing metrics (ROAS, CPA, CAC) and paid platform schemas, with a proven track record of structuring data to optimize Looker Studio performance.
• Proficiency with Git and collaborative development workflows, and proven ability to manage multi-client data environments with strict data segregation.

Responsabilidades

• Own data ingestion & pipeline architecture — connect and maintain API pipelines from paid media platforms into Adverity and build custom Python connectors.
• Own CRM integration — ensure lead and enrollment data flows into the warehouse reliably.
• Own the data warehouse — design schemas, manage partitioning, and optimize storage in BigQuery.
• Own transformation & mapping — develop modular, version-controlled SQL pipelines in dbt or Dataform.
• Own CI/CD & data segregation — maintain GitHub Actions pipelines and enforce multi-client data separation.
• Enable the reporting layer — create fast data views for Looker Studio dashboards and automated reports.
• Drive data quality — monitor pipelines, validate data, and troubleshoot discrepancies.

Conocimientos

SQL

BigQuery

dbt

Dataform

Python

CRM data flows

Git

Looker Studio

Herramientas

Adverity

Fivetran

Supermetrics

Funnel

GitHub Actions

Looker Studio

Descripción del empleo

INGEPSY is hiring a Senior Data Engineer to anchor the agency's data and analytics function. You will own end-to-end data ingestion, CRM connections, and the BigQuery warehouse, building modular dbt/Dataform pipelines and robust CI/CD with GitHub Actions.

Remote-first: collaborate with education and nonprofit partners, optimize Looker Studio dashboards, and ensure data quality across multi-client environments for scalable reporting and insights.