Job Description

The Reporting Analyst is 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. This role 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 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.
• Strong knowledge of Microsoft Excel and PowerPoint with the ability to analyze complex sets of data.
• Assist with pulling and analyzing reporting to uncover potential errors/issues before they become revenue impacting.
• Provides technical support and troubleshooting in a timely and professional manner to internal and external customers across all performance related ad platforms and systems.
• Work with external ad vendors to review and test tags for varying rich media creative types and executions.

Qualifications

• Experience with FreeWheel, Google Ad Manager ad serving technologies.
• At least two years’ experience in an ad operations or trafficking role.
• Ability to take and troubleshoot video/system issues.
• Strong understanding of video and display technologies (HTML, JavaScript, VPAID, VAST, etc).
• Digital video passion and knowledge.
• Expert knowledge of Microsoft Excel and various formulas.
• PowerPoint design and experience with compiling data.
• Expert on trouble shooting ad related issues.
• Minimum of two years’ experience in a Digital and/or trafficking role.
• Web/Internet technologies (Charles, HTML, JavaScript, Conviva etc.).

_ Desired Characteristics:_

• Innovative thinker excited about automation workflow opportunities.
• Digital media and/or marketing experience.
• Fast paced learner with the ability to create advanced formulas and macros for reporting/analytics.
• Strong 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.
• Expert knowledge of Digital ad operations with the ability to problem solve issues.
• Familiarity with emerging video and mobile product landscape.
• Proficiency in MS Word, Excel, Access, PowerPoint, HTML, JavaScript.
• Ability to thrive in a continuously changing environment.
• Freewheel ad server knowledge a plus.

** 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

Additional Information

As part of our selection process, external candidates may be required to attend an in-person interview with an NBCUniversal employee at one of our locations prior to a hiring decision. 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.

NBCUniversal will consider for employment qualified applicants with criminal histories, or arrest or conviction records, in a manner consistent with relevant legal requirements, including the City of Los Angeles' Fair Chance Initiative For Hiring Ordinance, the Los Angeles County Fair Chance Ordinance for Employers, and the California Fair Chance Act, where applicable.

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 AccessibilitySupport@nbcuni.com.