BigQueryData Engineer (Marketing-oriented) | Remote for Marketing Agency for EducationOur client is a fast-growing performance marketing agency specializing in mission-driven organizations across higher education and nonprofit sectors.
Since launching in ****, the agency has built a strong reputation for combining strategic thinking, creative execution, and data-driven marketing to help universities and organizations achieve measurable growth.Company Overview:Our client is a fast-growing performance marketing agency specializing in mission-driven organizations across higher education and nonprofit sectors.
Since launching in ****, the agency has built a strong reputation for combining strategic thinking, creative execution, and data-driven marketing to help universities and organizations achieve measurable growth.Your RoleThe Senior Data Engineer sits at the center of the agency's Data and Analytics function, connecting every paid media platform and CRM the agency touches into a single, reliable source of truth.
You'll own the full path data takes: from a client's ad accounts and CRM, through Adverity, into a BigQuery warehouse, through modular dbt/Dataform transformations, and out to the Looker Studio dashboards and automated Google Sheets reports the team and its partners rely on daily.
Reporting to the Data and Analytics Manager, you're joining at a pivotal moment — the agency is scaling its roster of education and nonprofit partners, and this role is instrumental in evolving the automated reporting suite that makes that growth possible without sacrificing data quality or client trust.You'llOwn data ingestion & pipeline architecture — connect and maintain API pipelines from paid media platforms (Meta, Google Ads, LinkedIn, TikTok, programmatic) into Adverity,



build custom Python connectors for anything not natively supported, and architect scalable pipelines from source system through to dashboardOwn CRM integration — build and maintain reliable CRM data connections (Slate, Salesforce, HubSpot) so lead and enrollment data flows cleanly into the warehouseOwn the data warehouse — route, optimize, and store raw and processed data in Google BigQuery; design efficient schemas for complex, multi-source marketing data (granularity, normalization, slowly changing dimensions); manage partitioning, clustering, and storage strategy to control query cost and performanceOwn transformation & mapping — build SQL schemas that map, blend, and organize multi-channel data accurately for each client, in modular, version‐controlled, documented dbt or Dataform pipelines, with standardized naming conventions and metric definitions across platforms and clientsOwn CI/CD & data segregation — maintain CI/CD pipelines (GitHub Actions, automated testing) for robust, version‐controlled releases, and enforce strict data segregation across multi‐client environmentsEnable the reporting layer — create clean, performant data views built specifically for fast Looker Studio dashboards and automated Google Sheets reports, and partner with the Data and Analytics Manager and client teams to translate reporting requirements into warehouse modelsDrive data quality — monitor pipeline health, resolve API breaks, minimize latency, implement validation frameworks and automated testing, troubleshoot discrepancies to root cause across source/warehouse/BI layers, and proactively flag data quality risks to leadershipYou Bring5+ years of hands‐on data engineering experience, ideally in a marketing ordidates must live in Latin America.
Work for the most exciting companies in the North American Market.
Work remotely.
#J-*****-Ljbffr

📌 Senior Data Engineer — Remote Marketing Analytics (Mendoza)
🏢 ADDMORE Services
📍 Mendoza