Reporting Analyst
Not Disclosed•Full-TimeOn-site
location_on5254, Denny Avenue, North Hollywood Neighborhood Council District, Los Angeles, Los Angeles County, California, 91601, United States
About the Role
The Reporting Analyst serves as a critical quality gatekeeper for the NBCU Portfolio, ensuring the successful trafficking and launch of campaigns across display, mobile, app media, and in-stream video products. This position places a heavy emphasis on short-form and full-episode ad products within NBC Universal's primetime properties, including Peacock.
Beyond launch verification, the role is dedicated to streamlining client reporting through the development of advanced formulas and automated workflows. You will maintain custom client reporting for the digital ad sales business and generate ad hoc reports for internal partners, ensuring data integrity before issues impact revenue.
Day in the Life
Your work involves a blend of technical troubleshooting and strategic analysis. You will provide quality assurance on all campaign launches and modifications, implementing critical fixes for major releases. A significant portion of your time is spent analyzing complex datasets to uncover potential errors before they escalate, requiring strong proficiency in Microsoft Excel and PowerPoint.
Collaboration is central to this position. You will work directly with the Manager of Digital Sales Operations QA to uphold sales operations standards and support the sales team. Additionally, you will liaise with external ad vendors to review and test tags for various rich media creative types. The role demands reliability, including on-call support for after-hours ad-related emergencies and coverage during major tentpole events.
Work location
Work model: On-site
5254, Denny Avenue, North Hollywood Neighborhood Council District, Los Angeles, Los Angeles County, California, 91601, United States
Los Angeles, California
Key Responsibilities
- check_circleReview and confirm successful trafficking and launch of campaigns across the NBCU Portfolio
- check_circleCreate and develop formulas to streamline reporting and automate large data sets
- check_circleProvide quality assurance on all campaign launches and implement critical troubleshooting
- check_circleOffer technical support and troubleshooting to internal and external customers on ad platforms
- check_circlePull and analyze reporting to uncover potential errors before they impact revenue
- check_circleCreate weekly to monthly reporting decks for clients and internal partners
- check_circleWork with external ad vendors to review and test tags for rich media creative types
- check_circleProvide on-call support for afterhours ad-related emergencies and tentpole events
Requirements
- verifiedStrong knowledge of Microsoft Excel
- verifiedStrong knowledge of Microsoft PowerPoint
- verifiedAbility to create advanced formulas
- verifiedAbility to analyze complex sets of data
