Marketing Data Operations (Marketing Analytics)

HDMZ•Chicago, IL

4h•Remote

About The Position

The Marketing Data Operations (Marketing Analytics) will lead the agency's core marketing data infrastructure, ensuring the reliable ingestion, validation, and organization of media performance data across all client accounts. This role is the operational authority responsible for maintaining the accuracy, security, and consistent structure of marketing metrics as they move from partner platforms into the agency's reporting ecosystem. The primary goal is to safeguard data integrity and system scalability, enabling the analytics and strategy teams to generate reliable, high-quality client insights. This position oversees the agency’s marketing data pipeline, including Funnel.io (data aggregation and warehouse layer), Google Looker Studio (reporting connections), and Advantage (media billing system). The role collaborates closely with media, analytics, and finance teams to maintain operational consistency between platform data, reporting systems, and billing records. The position provides leadership across all client portfolios (~$6–10M in annual media spend), ensuring that the agency’s marketing data infrastructure remains stable, secure, and scalable as new clients, partners, and integrations are introduced. The role supports the agency’s EOS-lite structure by maintaining clear ownership of data workflows, establishing repeatable processes, and ensuring that operational responsibilities remain transparent across departments. This role reports to the VP, Digital Marketing and collaborates closely with media teams, analytics staff, finance leadership, and external technology vendors.

Requirements

2–4 years of marketing data operations or marketing analytics engineering
Experience managing multi-platform media datasets using ELT platforms (e.g., Funnel.io, Supermetrics) and cloud data warehouses (e.g., BigQuery, Snowflake, Redshift)
Understands SQL and measurement for Clients
Proficiency in: Google Campaign Manager 360, Display & Video 360, Google Slides, Looker Studio, Google Sheet automation, SFTP and API ingestion
Strong understanding of both branding and performance-driven media strategies
A positive influence on HDMZ culture and a strong representative of the agency at client meetings, lunches, and conferences

Responsibilities

Data Ingestion & Pipeline Management
Ingest partner metrics from a variety of sources, including email, SFTP, APIs, and automated feeds
Maintain ingestion pipelines in Funnel.io or similar ETL platforms
Normalize and map metrics across partner schemas
Maintain data dictionaries and schema documentation
Data Quality & Governance
Validate dataset integrity before warehouse ingestion
Implement QA checks and anomaly detection
Monitor ingestion failures and resolve pipeline errors
Maintain access controls and follow data security protocols
Data Warehouse Operations
Maintain dataset structures in BigQuery, Snowflake, or similar
Manage table updates and scheduled refreshes
Maintain naming conventions and data lineage documentation
Reporting Infrastructure
Requires a strong visual creative sense for user interfaces for Looker Studio visualizations
Ensure dashboards refresh correctly and show correct data
Troubleshoot broken data connections
Data QA practices and processes