*** 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
Experience working with paid media or marketing datasets
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
#J-18808-Ljbffr
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
Experience working with paid media or marketing datasets
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
#J-18808-Ljbffr