Manager, Data Operations

OMD; New York (NY); On-site; USD 90,000 - 115,000; Full time

Job summary

Omnicom's Data Operations team is focused on delivering data-driven services across planning and investment functions in New York. You will build data warehouses and dashboards (Tableau, Datorama) and ensure data quality while collaborating with SMEs.

The role requires 3–5 years in advertising or related fields, strong presentation skills, and deep knowledge of taxonomy practices and BI platforms. In-office presence is required for several days weekly.

Qualifications

• A university degree in a related field and 3-5 years of experience in advertising, management consulting, marketing or digital consulting.
• Knowledge of agency-side execution processes.

Responsibilities

• Develop data warehouse and visualization dashboards, including calculated measurements and dimensions.
• Consult with SMEs to design and develop business rules for data processing.
• Set up and maintain data streams using BI tools; monitor and resolve data stream failures; ensure no gaps in measurements and dimensions.
• Create and maintain taxonomy generators for campaigns, placements, ad sets, etc.
• Manage development and maintenance of business intelligence tools; ensure data quality standards.
• Collect data from direct partners for dashboarding; perform ad-hoc data refreshes and dashboard updates.
• Work with investment teams on taxonomy resolution within ad servers; identify opportunities to improve processes; lead, mentor and train junior team members.

Skills

Data visualization

Automation & data pipelines

Presentation skills

Project management

Data QA

Ad platform knowledge

Education

Bachelor's degree in related field

Tools

Tableau

Datorama

Alteryx

Planit

Prisma

DDS

DV360

CM360

Innovid

Google Marketing Platform

Job description

Job Description

The Data Operations team is pivotal in the delivery of modern agency services. We are tightly integrated with planning and investment teams to deliver on and exceed our clients’ business goals.

Agency

Omd

Job Function

Data and Analytics

Job Subfunction

Data Engineering

Responsibilities

• Development of data warehouse and visualization dashboards
  • Creation and maintenance of calculated measurements and dimensions
  • Development of dashboards using data visualization tools such as Datorama and Tableau
• Consult with subject-matter experts to design and develop business rules for data processing
  • Setup and maintenance of data streams using business intelligence tools
  • Monitor, respond & resolve data stream failures
  • Ensure there are no gaps in measurements and dimensions
• Create and maintain taxonomy generators for campaigns, placements, ad sets, etc.
• Manage the development and maintenance of business intelligence tools
• Ensure compliance of data quality standards
• Collect data from direct partners for dashboarding development
• Ad-hoc emergency data refreshes and dashboard updates

Internal Facing Responsibilities

• Work with investment teams on taxonomy resolution within ad servers
• Identify opportunities to improve processes
• Lead, mentor and train junior team members
• Create and conduct ongoing taxonomy QA check and inform internal teams of accuracy

Required Skills

• Data Collection and Processing: Familiarity in building data visualization solutions (Tableau, Datorama, etc.) as well as automation solutions (Alteryx, Datorama, etc.)
• Good presentation and communication skills
• Demonstrated knowledge of the function and formation of standardized taxonomy practices for more accurate and efficient data collection & automation
• Expert in QA resolution
• Experienced with planning, optimization and analysis tools (Planit, Prisma, DDS)
• Demonstrated familiarity with self-serve tools within Search platforms (Google Ads, Bing, SA360), Programmatic DSPs (DV360, Yahoo, etc.), Ad Servers (CM360, Innovid, etc.), Social Platforms (Meta, Pinterest, TikTok, etc.) and Google Suite (Marketing Platform, Tag Manager, Analytics, Merchant Center)
• Excellent project management skills

Education And Experience

• A university degree in a related field, and 3-5 years of experience in advertising, management consulting, marketing or digital consulting
• Knowledge of agency-side execution processes

$90,000 - $115,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.

$90,000 - $115,000