Digital Ad Operations & Reporting Analyst

NBCUniversal; New York (NY); Hybrid; USD 72,000 - 80,000; Full time

Benefits offered by this job

Medical insurance

Dental insurance

Vision insurance

401(k)

Paid leave

Tuition reimbursement

Job summary

NBCUniversal is seeking a Reporting Analyst to validate campaign launches across its NBCU portfolio, focusing on display, mobile, and in-stream video including Peacock. You will build reporting decks and develop formulas to streamline client reporting for the digital ad sales group.

Responsibilities include QA, technical troubleshooting, and collaboration with sales operations to ensure accurate data and timely deliverables.

Qualifications

• Advanced knowledge of Microsoft Excel and various formulas.
• Experience creating presentations and analyzing complex sets of data using PowerPoint and Excel.
• Understanding of video, display, and web technologies (HTML, JavaScript, VPAID, VAST, Charles, Conviva, and related tools).

Responsibilities

• Provide quality assurance on all campaign launch/modifications across the NBCU Portfolio and implement critical troubleshooting on major campaign launches.
• Offer technical support and troubleshooting in a timely and professional manner to internal and external customers across all performance related ad platforms and systems.
• Assist with pulling and analyzing reporting to uncover potential errors/issues before they become revenue impacting.
• Work directly with the Sr. Manager, Digital Sales Operations QA to ensure that all details of Sales Operations are being upheld and that the Sales team is being properly supported.
• Some on call support is required for afterhours ad-related emergencies and coverage over tentpole events.
• Daily and weekly reporting with the ability to created advanced formulas to better automate large amounts of data.
• Work with external ad vendors to review and test tags for varying rich media creative types and executions.

Skills

Advanced Excel

PowerPoint

HTML

JavaScript

VPAID

VAST

Conviva

Charles

Tools

FreeWheel

Google Ad Manager

Job description

NBCUniversal is seeking a Reporting Analyst to validate campaign launches across its NBCU portfolio, focusing on display, mobile, and in-stream video including Peacock. You will build reporting decks and develop formulas to streamline client reporting for the digital ad sales group.

Responsibilities include QA, technical troubleshooting, and collaboration with sales operations to ensure accurate data and timely deliverables.