Remote Data Engineer - Marketing Analytics & Pipelines

Perficient; Santa Fe Capital; Remote; ARS 1,800,000 - 3,000,000; Full time

Benefits offered by this job

Remote role

Competitive compensation

High-visibility role

Impactful work in education sector

Job summary

Perficient is seeking a Senior Data Engineer (Marketing-oriented) to centralize data from paid media and CRM sources into a single source of truth. You will own ingestion pipelines from Meta, Google Ads, LinkedIn, TikTok, and more into Adverity, connect Slate/Salesforce/HubSpot CRM data, and store transformed data in Google BigQuery.

You’ll shape dbt/Dataform pipelines and enable fast Looker Studio dashboards.

Qualifications

• 5+ years hands-on data engineering experience, ideally 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 in dbt or Dataform, managing modular, version-controlled SQL transformation pipelines.
• Python proficiency for custom API connections and pipeline automation.
• Experience with CRM data flows and integrations (Slate, Salesforce, and/or HubSpot).
• Strong understanding of marketing metrics (ROAS, CPA, CAC) and paid platform schemas, with data structuring to optimize Looker Studio.
• Proficiency with Git and collaborative development workflows, managing multi-client data environments with strict data segregation.

Responsibilities

• 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 data in Google BigQuery; design efficient schemas for multi-source marketing data; manage partitioning, clustering, storage to control cost and performance.
• Own transformation & mapping — build SQL schemas that map, blend, and organize multi-channel data in modular dbt/Dataform pipelines with standardized naming and metrics.
• Own CI/CD & data segregation — maintain CI/CD pipelines (GitHub Actions, automated testing) for robust releases and enforce data segregation across multi-client environments.
• Enable the reporting layer — create clean data views for Looker Studio dashboards and Google Sheets reports; translate requirements into warehouse models.
• Drive data quality — monitor pipeline health, resolve API breaks, minimize latency, implement validation/tests, flag data quality risks.

Skills

Data engineering

SQL

Python

BigQuery

ETL pipelines

Data modeling

Looker Studio optimization

Tools

Adverity

dbt

Dataform

Git

Salesforce

HubSpot

Job description

Perficient is seeking a Senior Data Engineer (Marketing-oriented) to centralize data from paid media and CRM sources into a single source of truth. You will own ingestion pipelines from Meta, Google Ads, LinkedIn, TikTok, and more into Adverity, connect Slate/Salesforce/HubSpot CRM data, and store transformed data in Google BigQuery.

You’ll shape dbt/Dataform pipelines and enable fast Looker Studio dashboards.