Marketing Data Engineer

*** Applicants must currently reside within the Greater Boston area. Applications from outside the area will not be considered for this or future local opportunities. ***

We’re partnering with a Boston-based marketing organization seeking an Analytics Engineer to support and improve an existing media data environment. This role focuses on maintaining data pipelines, improving reliability, and structuring transformation logic for long-term scalability.

This is a hands‑on engineering role working across ingestion, modeling, and warehouse performance.

• Maintain and troubleshoot data ingestion pipelines (APIs, connectors, Python workflows)
• Ingest and standardize vendor datasets with inconsistent schemas
• Manage and optimize a Google Big Query environment
• Convert legacy SQL transformations into dbt models
• Implement partitioning, clustering, and incremental logic to improve performance and cost
• Normalize campaign and media naming structures for reporting consistency
• Support analysts by producing reliable production tables
• Document business logic and data definitions
• Ensure reporting continuity during system transition

• Advanced SQL experience in Big Query or similar cloud warehouse
• Experience working with paid media or marketing datasets
• Comfortable working with legacy or partially documented pipelines

• Experience with Supermetrics, Fivetran, or similar ingestion tools
• Multi-dataset or multi-stakeholder environments
• Exposure to BI modeling layers or semantic modeling tool