Senior Marketing Data Engineer — Remote

INGEPSY; Cartagena de Indias; A distancia; COP 279.356.000 - 403.514.000; Jornada completa

Ventajas ofrecidas por este puesto de trabajo

Remote role

Descripción de la vacante

INGEPSY, a fast-growing performance marketing agency serving education and nonprofit partners, is seeking a Senior Web Analyst. You’ll own end-to-end data pipelines, linking paid media and CRM feeds into Adverity, a BigQuery warehouse, and Looker Studio dashboards.

You’ll design modular dbt/Dataform transformations, maintain CI/CD and data segmentation, ensure data quality, and partner with clients and the Data & Analytics Manager to scale automated reporting 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, 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.
• An analytical, solution-driven mindset with a growth orientation, and strong communication skills that turn complex data workflows into clear narratives for non-technical audiences.

Responsabilidades

• Own data ingestion & pipeline architecture — connect and maintain API pipelines from paid media platforms into Adverity, build custom Python connectors, and architect scalable pipelines from source to dashboard.
• Own CRM integration — build and maintain reliable CRM data connections (Slate, Salesforce, HubSpot) so lead and enrollment data flows into the warehouse.
• Own the data warehouse — route, optimize, and store raw and processed data in Google BigQuery; design efficient schemas and manage partitioning and storage strategy.
• Own transformation & mapping — build SQL schemas that map, blend, and organize multi-channel data in modular, documented pipelines with consistent naming and metrics definitions.
• Own CI/CD & data segregation — maintain CI/CD pipelines (GitHub Actions, automated testing) for robust releases, enforce data segregation across multi-client environments.
• Enable the reporting layer — create clean, performant data views for Looker Studio dashboards and automated Google Sheets reports, translating requirements into warehouse models.
• Drive data quality — monitor pipeline health, resolve API breaks, minimize latency, implement validation and testing, flag data quality risks.

Conocimientos

SQL

BigQuery

dbt/Dataform

Python

ETL platforms

CRM data flows

Git

Data modeling

Data warehousing

API integration

Looker Studio

Herramientas

Adverity

Fivetran

Supermetrics

Funnel

Descripción del empleo

INGEPSY, a fast-growing performance marketing agency serving education and nonprofit partners, is seeking a Senior Web Analyst. You’ll own end-to-end data pipelines, linking paid media and CRM feeds into Adverity, a BigQuery warehouse, and Looker Studio dashboards.

You’ll design modular dbt/Dataform transformations, maintain CI/CD and data segmentation, ensure data quality, and partner with clients and the Data & Analytics Manager to scale automated reporting across multi-client environments.