Associate Director, Data Management

Agency:

Hearts & Science Job Function:

Data and Analytics Job Subfunction:
Data Science and Analytics

Job Description:

Core responsibilities include, but are not limited to the following:

Being an organized and proactive self-starter is a must Primary lead to our dashboarding team for standing up our dashboard/data ingestion for our healthcare client. This is the data that feeds insights and reporting.

Lead for client's internal dashboard initiative, including managing data ingestion work streams and QALead for data request and QA work streams to aid advanced analysis, such as marketing mix modeling data or client site data

Lead group of 2-3 data analysts

Identify data gaps, inconsistencies, and integrity issues, and lead resolution with internal teams, clients, vendors, and technology partners.

Evaluate data and research/analytics vendors for or on behalf of clients

Maintain data standards and taxonomies

Develop data-governance practices that support accuracy, consistency, security, and appropriate access controls.

Maintain documentation for data sources, business rules, transformation logic, refresh schedules, ownership, and dependencies.

Partner with vendor, client analytics, and activation teams to improve data accessibility and usability.

Desired Qualifications, Knowledge & Skills5+ years of experience in data management, marketing analytics, business intelligence, media analytics, marketing technology, or a related field

Experience working in a media/advertising agency, marketing organization, consultancy, or similar client-services environment preferred

Demonstrated experience managing end-to-end data processes and workflows for complex client or enterprise environments

Proven experience standing up and managing performance dashboards used by clients or business stakeholders

Strong knowledge & experience with data quality assurance, reconciliation, governance, documentation, and workflow management

Strong understanding of digital media, paid media, campaign measurement, marketing performance, and relevant advertising data sources

Comfortable operating at both a high level and in the details of data workflows and quality checks

Strong communication, project management, and process documentation skills

Strategic thinker who can connect data operations to client and business outcomes

May be required to take on ad hoc assignments, projects, and responsibilities as needed to support business objectives, client needs, and operational requirements.

Desired Technical Experience Cloud data platforms and warehouses:
Snowflake, Databricks, Big Query, Redshift, or similar environments.

Marketing and media data platforms:
Adverity, Datorama Data preparation and workflow automation:
Alteryx, SQL, Python, dbt, or similar technologies.

Business intelligence and visualization:
Tableau, Power BI, Looker, or similar tools.

Advertising and activation platforms:
Google Marketing Platform, Campaign Manager 360, Display & Video 360, Google Ads, Meta Ads Manager, The Trade Desk, Amazon Ads, and other major media platforms.

Data integration and APIs:
Experience working with API-based data feeds, SFTP transfers, cloud storage, ETL/ELT tools, and automated data pipelines.

Database and query technologies:
Experience working with relational databases, dimensional models, and data marts.

$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…