Marketing Data Operations (Marketing Analytics) at HDMZ

Chicago, Illinois, United States -

Full Time

Start Date

Immediate

Expiry Date

09 Jun, 26

Salary

30.0

Posted On

11 Mar, 26

Experience

2 year(s) or above

Remote Job

Yes

Telecommute

Yes

Sponsor Visa

Skills

Data Ingestion, Pipeline Management, Data Quality, Data Governance, SQL, Funnel.io, Looker Studio, BigQuery, Snowflake, ETL, API Ingestion, SFTP, Data Validation, Schema Documentation, Data Security, Data Lineage

Industry

Marketing Services

Description

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 Location Chicago, Illinois (Remote) Department Media and Digital Marketing Employment Type Part-Time Minimum Experience Experienced Compensation $30.00 per hour

Responsibilities

This role leads the agency's core marketing data infrastructure, ensuring the reliable ingestion, validation, and organization of media performance data across all client accounts. The position oversees the marketing data pipeline, including Funnel.io, Looker Studio connections, and media billing systems, while collaborating with media, analytics, and finance teams.