Remote Senior Marketing Data Engineer

INGEPSY; Bogotá ciudad; A distancia; COP 90.000.000 - 130.000.000; Jornada completa

Ventajas ofrecidas por este puesto de trabajo

Remote role

Competitive compensation

High-visibility role on scaling team

Direct impact on client reporting

Descripción de la vacante

INGEPSY is seeking a Senior Web Analyst to centralize data engineering across paid media, CRM, and the data warehouse. You will own ingestion pipelines, CRM connections, and the BigQuery warehouse, building modular dbt/Dataform transformations and scalable pipelines.

The role emphasizes data quality, cost control, and clear storytelling for clients across education and nonprofits. You'll work with Adverity, Looker Studio, and automated reporting to support executive dashboards and partner

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
• 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 — education marketing experience (traditional or online) is especially valued

Responsabilidades

• Own data ingestion & pipeline architecture, connecting API pipelines from paid media platforms into Adverity and building scalable pipelines from source to dashboard
• Own CRM integration, ensuring lead and enrollment data flow into the warehouse
• Own the data warehouse in BigQuery, design schemas, partitioning, and storage strategy to control costs and performance
• Own transformation & mapping, building modular, version-controlled dbt/Dataform pipelines with standardized naming and metrics
• Own CI/CD & data segregation, maintaining GitHub Actions pipelines for robust releases and strict multi-client segregation
• Enable the reporting layer, creating fast Looker Studio dashboards and automated Sheets reports
• Drive data quality, monitor pipelines, resolve API breaks, and flag data quality risks to leadership

Conocimientos

SQL

BigQuery

Python

Data integration

Herramientas

Adverity

Fivetran

Supermetrics

Funnel

dbt

Dataform

Git

Looker Studio

Descripción del empleo

INGEPSY is seeking a Senior Web Analyst to centralize data engineering across paid media, CRM, and the data warehouse. You will own ingestion pipelines, CRM connections, and the BigQuery warehouse, building modular dbt/Dataform transformations and scalable pipelines.

The role emphasizes data quality, cost control, and clear storytelling for clients across education and nonprofits. You'll work with Adverity, Looker Studio, and automated reporting to support executive dashboards and partner