Associate Director, Data Management

Hearts & Science; Chicago (IL); On-site; USD 70,000 - 125,000; Full time

Benefits offered by this job

In-office three days a week

Job summary

Hearts & Science in Chicago is seeking a Data Engineering leader to drive data strategy, governance, and quality across diverse client accounts and media channels. You will oversee BI deployments, data warehousing, ETL, and automation, while mentoring Managers, Senior Analysts, and Analysts in a fast-paced environment.

Ideal candidates bring 5–7 years in data management/BI, strong cross‑functional collaboration skills, and a proven track record in data quality and process improvements within

Qualifications

• 5–7 years’ experience in data management, data engineering, Data Management and/or business intelligence.
• 3–5 years’ experience in digital media data across ad server, digital, search, social, video, offline.
• 3–5 years’ experience in agile development environments.
• 3–5 years’ experience in client-facing work and managing offshore or cross-functional teams.
• 4+ years’ experience in data governance and quality processes within data warehousing, ETL, and BI environments.
• 5+ years’ experience in business analysis or related disciplines.

Responsibilities

• Direct the development, implementation, and maintenance of data strategies, quality standards, business rules, and governance processes for diverse client accounts and media channels.
• Oversee the creation and management of project plans, assign and prioritize tasks, and ensure standardized processes.
• Facilitate regular status meetings, resolve roadblocks, and drive initiative progression in a fast-paced, agile environment.
• Act as liaison among internal teams, offshore resources, external vendors, and clients; communicate roles and expectations clearly.
• Supervise investigation and resolution of data integrity issues, define/implement business rules for data cleansing and QA.
• Advise on or lead deployment of BI tools, data warehousing, ETL processes, and automation initiatives.

Skills

Data strategy

Governance

Project leadership

Cross-functional collaboration

Data quality

BI tooling

Team leadership

Data management

Budget handling

Communication

Tools

Tableau

PowerBI

Datorama

Looker/Looker Studio

Domo

SQL

Python

ETL tools (Adverity, Datorama)

Snowflake

Job description

Agency

Hearts & Science

Job Function

Data and Analytics

Job Subfunction

Data Engineering

Job Description

• Data Strategy & Governance: Direct the development, implementation, and maintenance of data strategies, quality standards, business rules, and governance processes for diverse client accounts and media channels.


• Project & Process Leadership: Oversee the creation and management of project plans, assign and prioritize tasks, and ensure standardized processes. Facilitate regular status meetings, proactively resolve roadblocks, and drive initiative progression in a fast-paced, agile environment.


• Cross-Functional Collaboration: Act as liaison among internal teams (Strategy, Digital Investment, Planning, Analytics, Finance), offshore resources, external vendors, and clients. Foster positive working relationships and effectively communicate roles, responsibilities, and expectations.


• Data Quality & Problem Solving: Supervise investigation and resolution of data integrity issues, define/implement business rules for data cleansing and QA, and ensure best practices in all data and technology projects.


• Technical Solution Oversight: Advise on or lead the deployment of business intelligence tools, data warehousing, ETL processes, and automation initiatives. Champion adoption of new technology and process solutions, ensuring data is the backbone for all media and analytics disciplines.


• Team Leadership: Supervise and mentor Managers, Senior Analysts, and Analysts; cultivate a supportive, growth-oriented environment. Guide teams in Data Management, quality assurance, and client management tasks.

Skills & Experience

• 5–7 years’ experience in data management, data engineering, Data Management and/or business intelligence


• 3–5 years’ experience in digital media data (ad server, digital, search, social, video, offline, etc.)


• 3–5 years’ experience in agile development environments


• 3–5 years’ experience in client-facing work and managing offshore or cross-functional teams


• 4+ years’ experience in data governance and quality processes within data warehousing, ETL, and BI environments


• 5+ years’ experience in business analysis or related disciplines


• In-depth expertise across digital and traditional media channels and handling diverse datasets (paid, owned, etc.)


• Demonstrated ability to diagnose, elevate, and solve complex data quality and operational issues


• Outstanding organizational and project management skills


• Comfortable multitasking and adapting to fast-evolving needs


• Superior attention to detail, with excellent verbal and written communication skills


• Proven ability to build relationships across internal teams, vendors, and clients


• Comfort and accuracy working with budgets and large sets of numerical data


• Media industry experience highly preferred

Tools

• Business Intelligence: Advanced Excel (required), Tableau, PowerBI, Datorama, Looker/Looker Studio, Domo, PowerPoint


• Data Management & Transformation: ETL Tools (Adverity, Datorama), Alteryx, SQL (preferred), Python (nice to have)


• Data Storage/Cloud: Snowflake, AWS (Redshift, S3), Starburst.io, Datorama, Domo


• Media Platforms: DCM, DV360, Google Ads, DoubleVerify, IAS, TradeDesk, Facebook, Instagram, Snapchat, Twitter, TikTok, Prisma


• Project Management: HIVE, Asana, Smartsheet, Microsoft Teams


• Media Planning: MediaTools, Lumina, Hudson (bonus)


• Other: Experience with writing business and technical requirements documents; comfort with business rules design and BI tool administration

$70,000 - $125,000

Omnicom's policy requires employees to work in the office for a minimum of three days a week, unless additional in‑office days are directed by their agency or manager. Our objective is to increase this requirement over time, and many of our agencies as well as Omnicom's corporate group already require five days of in‑office attendance.

Omnicom is committed to hiring and developing exceptional talent. We agree that talent is uniquely distributed, and we're focused on developing inclusive teams that can bring the best solutions to everything we do. We strongly believe that celebrating what makes us different makes us better together. Join us—we look forward to getting to know you. We will process your personal data in accordance with our Recruitment Privacy Notice.

Link to Recruitment Privacy Notice: https://www.omc.com/privacy-notice

For US Job Seekers

It is the policy of Omnicom and any of its affiliates to provide equal employment opportunities to all employees and applicants for employment without regard to race, religion, color, ethnic origin, gender, gender identity, age, marital status, veteran status, sexual orientation, disability, or any other basis prohibited by applicable federal, state, or local law. EOE/AA/M/D/V/F.

$70,000 - $125,000