Marketing Data Operations (Marketing Analytics) at HDMZ in Chicago, IL

Summary

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.

Responsibilities

While the other groups interpret and communicate performance insights, the Marketing Data Operations (Marketing Analytics) position ensures the reliability and integrity of the underlying data systems that support those insights.

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

Experience

• 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