Reporting Analyst

NBCUniversal•New York, NY

8h•$72,000 - $80,000•Hybrid

About The Position

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.

Requirements

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

Nice To Haves

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

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