Reporting Analyst

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.