Reporting Analyst

Reporting AnalystNBCUniversal is one of the world's leading media and entertainment companies. We create world-class content, which we distribute across our portfolio of film, television, and streaming, and bring to life through our global theme park destinations, consumer products, and experiences. We own and operate leading entertainment and news brands, including NBC, NBC News, NBC Sports, Telemundo, NBC Local Stations, Bravo, and Peacock, our premium ad-supported streaming service. We produce and distribute premier filmed entertainment and programming through our powerhouse film and television studios, including Universal Pictures, DreamWorks Animation, and Focus Features, and the four global television studios under the Universal Studio Group banner, and operate industry-leading theme parks and experiences around the world through Universal Destinations & Experiences, including Universal Orlando Resort, home to Universal Epic Universe, and Universal Studios Hollywood. NBCUniversal is a subsidiary of Comcast Corporation.Our impact is rooted in improving the communities where our employees, customers, and audiences live and work. We have a rich tradition of giving back and ensuring our employees have the opportunity to serve their communities. We champion an inclusive culture and strive to attract and develop a talented workforce to create and deliver a wide range of content reflecting our world.Job DescriptionAs 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 ResponsibilitiesProvide quality assurance on all campaign launch/modifications across the NBCU Portfolio and implement critical troubleshooting on major campaign launchesOffer technical support and troubleshooting in a timely and professional manner to internal and external customers across all performance related ad platforms and systemsAssist with pulling and analyzing reporting to uncover potential errors/issues before they become revenue impactingWork 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 supportedSome on call support is required for afterhours ad-related emergencies and coverage over tentpole eventsDaily and weekly reporting with the ability to created advanced formulas to better automate large amounts of dataWork with external ad vendors to review and test tags for varying rich media creative types and executionsQualificationsMinimum (2+) two years' experience in a digital, ad operations and/or trafficking roleUnderstanding 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 formulasExperience creating presentations and analyzing complex sets of data using PowerPoint and ExcelEligibility Requirements:Interested candidates must submit a resume/CV through nbcunicareers.com to be consideredMust be willing to work in New York, NYMust be willing to submit to a background investigationMust have unrestricted work authorization to work in the United StatesMust be 18 years or olderDesired CharacteristicsPassion for digital video/marketing and understanding of the digital media ecosystemExperience with FreeWheel, Google Ad Manager ad serving technologiesInnovative thinker excited about automation workflow opportunitiesProven ability to troubleshoot and resolve video, system, and ad operational issuesFast paced learner with the ability to create advanced formulas and macros for reporting/analyticsAnalytical and interpersonal skills with ability to work independently and collaborativelyAbility to set and self-manage goals, deadlines, and multiple assignments concurrently in a project-based environmentFamiliarity with Web/Internet technologies (Charles, HTML, JavaScript, Conviva etc.)Familiarity with emerging video and mobile product landscapeAbility to thrive in a continuously changing environmentAdditional RequirementsHybrid: 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,000Additional InformationAs 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.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 View email address on click.appcast.io.