Marketing Data Engineer

Analytics Engineer (Contract) Boston, MA (Hybrid) • • • 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. Responsibilities • Maintain and troubleshoot data ingestion pipelines (APIs, connectors, Python workflows) • Ingest and standardize vendor datasets with inconsistent schemas • Manage and optimize a Google BigQuery 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 Required Qualifications • Advanced SQL experience in BigQuery or similar cloud warehouse • Hands-on dbt experience in production environments • Python for ingestion, APIs, or data processing • Experience working with paid media or marketing datasets • Git version control workflows • Comfortable working with legacy or partially documented pipelines Preferred Qualifications • Experience with Supermetrics, Fivetran, or similar ingestion tools • Multi-dataset or multi-stakeholder environments • Exposure to BI modeling layers or semantic modeling tool • • • Applicants must currently reside within the Greater Boston area. Applications from outside the area will not be considered for this or future local opportunities. • • •