Associate Director, Data Management

Hearts & Science; New York (NY); On-site; USD 70,000 - 125,000; Full time

Job summary

Hearts & Science is seeking an experienced Data & Analytics leader in New York to drive data strategy, governance, and quality across diverse client accounts and media channels.

You will oversee BI tooling deployment, ETL processes, and data warehousing, while mentoring a team of analysts and managers. The role requires strong cross-functional collaboration and deep data governance expertise.

Qualifications

• 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.

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 creation and management of project plans, assign tasks, and ensure standardized processes in an agile environment.
• Liaise among internal teams, offshore resources, external vendors, and clients to communicate roles and expectations.
• Supervise investigation and resolution of data integrity issues and define business rules for data cleansing and QA.
• Advise on or lead deployment of BI tools, data warehousing, ETL, and automation initiatives.

Skills

Data management

Data engineering

BI tools

Agile

Client facing

Offshore teams

Governance

Data quality

Budgeting

Cross-functional leadership

Attention to detail

Tools

Tableau

PowerBI

Datorama

Looker/Looker Studio

Domo

SQL

Python

Snowflake

AWS

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.

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