Reporting Analyst

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

Benefits offered by this job

Medical insurance

Dental insurance

401(k)

Paid leave

Tuition reimbursement

Job summary

NBCUniversal is seeking a Reporting Analyst in New York to review and confirm trafficking and launch of campaigns across NBCU properties including NBCUniversal’s Peacock portfolio. The role focuses on creating weekly to monthly reporting decks, developing formulas to streamline reporting, and maintaining client reports for the digital ad sales business.

The ideal candidate has 2+ years in digital ad operations, strong Excel prowess, and experience with reporting tools.

Qualifications

• Minimum 2+ years' experience in a digital, ad operations and/or trafficking role.
• Understanding of video, display, and web technologies (HTML, JavaScript, VPAID, VAST, Charles, Conviva).
• Advanced knowledge of Microsoft Excel and various formulas.

Responsibilities

• Provide QA on campaign launches and troubleshoot major launches.
• Offer technical support across performance ad platforms and systems.
• Assist with pulling and analyzing reporting to uncover errors before revenue impact.
• Work with Sr. Manager, Digital Sales Operations QA to support Sales Operations.
• Some on-call coverage for after-hours ad-related emergencies and tentpole events.
• Daily/weekly reporting and creation of advanced formulas to automate data.
• Review and test tags with external ad vendors for rich media creatives.

Skills

Advanced Excel

PowerPoint

Analytical thinking

Education

2+ years digital ad ops experience

Tools

FreeWheel

Google Ad Manager

HTML

JavaScript

Conviva

VPAID

VAST

Charles

Job description

As a Reporting Analyst, you are responsible for reviewing and confirming the successful trafficking and launch of campaigns across the NBCU Portfolio. These campaigns include display, mobile and app media along with a heavy focus on in-stream video for short-form and full-episode ad products across NBC Universal's primetime properties including Peacock. You will also focus on creating various reporting decks on a weekly to monthly cadence. A key component of this role is to create and develop formulas to help better streamline reporting for our clients, while maintaining all custom client reporting across the digital ad sales business as well as ad hoc reports for internal partners.

Duties and 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

Minimum (2+) two years' experience in a digital, ad operations and/or trafficking role

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

Eligibility Requirements

• Must be willing to work in New York, NY
• Must be willing to submit to a background investigation
• Must have unrestricted work authorization to work in the United States
• Must be 18 years or older

Desired Characteristics

• Passion for digital video/marketing and understanding of the digital media ecosystem
• Experience with FreeWheel, Google Ad Manager ad serving technologies
• Innovative thinker excited about automation workflow opportunities
• Proven ability to troubleshoot and resolve video, system, and ad operational issues
• Fast paced learner with the ability to create advanced formulas and macros for reporting/analytics
• Analytical and interpersonal skills with ability to work independently and collaboratively
• Ability to set and self-manage goals, deadlines, and multiple assignments concurrently in a project-based environment
• Familiarity with Web/Internet technologies (Charles, HTML, JavaScript, Conviva etc.)
• Familiarity with emerging video and mobile product landscape
• Ability to thrive in a continuously changing environment

Additional Requirements

• Hybrid : This position currently has a hybrid schedule, which requires contributing from the office a minimum of four days per week. The Company reserves the right to change in-office requirements at any time.
• This position is eligible for company sponsored benefits, including medical, dental and vision insurance, 401(k), paid leave, tuition reimbursement, and a variety of other discounts and perks. Learn more about the benefits offered by NBCUniversal by visiting the Benefits page of the Careers website.
• Salary Range: $72,000 - $80,000

NBCUniversal's policy is to provide equal employment opportunities to all applicants and employees without regard to race, color, religion, creed, gender, gender identity or expression, age, national origin or ancestry, citizenship, disability, sexual orientation, marital status, pregnancy, veteran status, membership in the uniformed services, genetic information, or any other basis protected by applicable law.

If you are a qualified individual with a disability or a disabled veteran and require support throughout the application and/or recruitment process as a result of your disability, you have the right to request a reasonable accommodation. You can submit your request to [e-mail].