Senior Marketing Data Engineer – Remote, BigQuery & Looker

INGEPSY; Colombia; A distancia; COP 60.000.000 - 120.000.000; Jornada completa

Descripción de la vacante

INGEPSY is seeking a Senior Web Analyst to centralize data across paid media and CRM, building reliable pipelines from ad accounts through Adverity into a Google BigQuery warehouse and Looker Studio dashboards.

You will own data ingestion, CRM connections (Slate, Salesforce, HubSpot), the data warehouse, modular dbt/Dataform transformations, CI/CD, and the reporting layer, ensuring fast, accurate insights for education and nonprofit partners.

Formación

• 5+ years of hands-on data engineering experience in a marketing or agency environment.
• Experience configuring datastreams, transformations, and destinations in Adverity or comparable ETL platforms (Fivetran, Supermetrics, Funnel).
• Intermediate to advanced SQL with BigQuery experience in transformation, partitioning and modeling.
• Expertise with dbt or Dataform and modular, version-controlled SQL pipelines.
• Python proficiency for custom API connections and pipeline automation.
• CRM data flows and integrations (Slate, Salesforce, HubSpot).
• Strong understanding of marketing metrics (ROAS, CPA, CAC) and paid platform schemas.
• Git and collaborative development workflows; multi-client data environments with data segregation.
• Analytical, growth-oriented mindset with strong communication; education marketing experience valued.

Responsabilidades

• Own data ingestion & pipeline architecture—connect and maintain API pipelines from paid media into Adverity and build scalable pipelines from source to dashboard.
• Own CRM integration—maintain reliable CRM data connections (Slate, Salesforce, HubSpot) to warehouse.
• Own the data warehouse—store data in BigQuery and design schemas for multi-source marketing data.
• Own transformation & mapping—build SQL schemas in modular dbt/Dataform pipelines with standardized naming and metrics.
• Own CI/CD & data segregation—maintain pipelines (GitHub Actions) with strict multi-client segregation.
• Enable the reporting layer—create data views for Looker Studio dashboards and Google Sheets reports.
• Drive data quality—monitor pipelines, validate data, troubleshoot discrepancies, and flag risks.

Conocimientos

SQL

BigQuery

Python

dbt

Data modeling

ETL pipelines

Git

CRM data flows

Herramientas

Adverity

Fivetran

Supermetrics

Funnel

Looker Studio

BigQuery Console

Descripción del empleo

INGEPSY is seeking a Senior Web Analyst to centralize data across paid media and CRM, building reliable pipelines from ad accounts through Adverity into a Google BigQuery warehouse and Looker Studio dashboards.

You will own data ingestion, CRM connections (Slate, Salesforce, HubSpot), the data warehouse, modular dbt/Dataform transformations, CI/CD, and the reporting layer, ensuring fast, accurate insights for education and nonprofit partners.