Sr. Analyst, Global Analytics and Insights (UP&E)

Company Description

We create world-class content, which we distribute across our portfolio of film, television, and streaming, and bring to life through our theme parks and consumer experiences. We own and operate leading entertainment and news brands, including NBC, NBC News, MSNBC, CNBC, NBC Sports, Telemundo, NBC Local Stations, Bravo, USA Network, and Peacock, our premium ad-supported streaming service. We produce and distribute premier filmed entertainment and programming through Universal Filmed Entertainment Group and Universal Studio Group and have world-renowned theme parks and attractions through Universal Destinations & Experiences. NBCUniversal is a subsidiary of Comcast Corporation.

As a company uniquely positioned to educate, entertain and empower through our platforms, Comcast NBCUniversal stands for including everyone. Our Diversity, Equity and Inclusion initiatives, coupled with our Corporate Social Responsibility work, is informed by our employees, audiences, park guests and the communities in which we live. We strive to foster a diverse, equitable and inclusive culture where our employees feel supported, embraced and heard. Together, we’ll continue to create and deliver content that reflects the current and ever-changing face of the world.

Universal Products & Experiences Overview:

Universal Products & Experiences (UP&E) globally drives the expansion and elevation of NBCUniversal’s iconic collection of brands, intellectual properties, characters, and stories based on the company’s extensive portfolio of properties created by Universal Pictures, Illumination, DreamWorks Animation and NBCUniversal Television and Streaming. The division executes this through innovative physical and digital products, engaging retail and product experiences across our expansive global theme park destinations (for both owned and 3rd party IP), location-based venues, e-commerce product platforms, and retailers around the world. Along with global brand strategy and creative, UP&E’s three lines of business include Consumer Products, Games and Digital Platforms, as well as Theme Parks Products & Retail. UP&E is a division of Universal Destinations & Experiences, part of NBCUniversal, a subsidiary of Comcast Corporation. https://www.universalproductsexperiences.com/

Universal Products & Experiences is committed to attracting and retaining a diverse workforce of the highest caliber. We are committed to fostering equitable and inclusive environments that honor the experiences, perspectives, and uniqueness of each colleague.

It is the policy of NBCUniversal and NBCUniversal's affiliated businesses to consider all qualified applicants for employment without regard to race, color, religion, national origin, sex (including pregnancy) sexual orientation, age, disability, veteran status or other characteristics protected by applicable law.

Job Description

This role will support the development of business analytics models and tools which empower data-driven decision making and commercial results.  Will assist in building reporting and analytics across the Consumer Products and Games organization worldwide in partnership with Retail, Category, Franchise, Product Development, Strategy, Business Development, and Finance teams. 

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: $70,000 - $95,000

Qualifications

Responsibilities include:

Data Maintenance/Data Management 

• Maintain and manage the integrity of the data, including mapping product hierarchies.  
• Collaborate with IT and Retail/Category teams to ensure consistency, completeness, and accuracy of data.
• Design international weekly account data activation, delivery, ETL, attribution, and restatement processes.
• Coordinate new international retailer data onboarding efforts with external partners including gathering business requirements, integration, and QA testing workflows. 

Reporting 

• Assist in development, data visualization and distribution of overall UP&E, region, account, film release, and seasonal based reporting and performance recaps, and high-level insights on trending, key drivers, and comparisons to internal and external benchmarks.
• Prepare presentations and read-outs to internal Sales and Category teams on business performance
• Support Sales, Category and Franchise teams in preparation for the key milestone meetings (TTT, JBP, Studio Swings)

Analytics 

• Support the day-to-day operational activities for external data and insights providers with subject matter expertise on vendor platforms and data hierarchies to manage database extractions.
• Extract, wrangle, and translate data from multiple databases/sources to solve business issues with cohesive and easy to understand insights.
• Regularly develop Gaps and Opportunities analysis and analyze category and regions/countries market share to grow business at both the Franchise/Property and Category/Subcategory level. Ability to clearly articulate results and insights and size incremental opportunities.
• Provide distribution analysis to identify underpenetrated channel opportunities by region and country. 
• Identify shopper trends and opportunities using third-party market level data and incorporating internal sales/financial data to create opportunity analyses.
• Assist with custom data requests and presentation needs for senior executives.

Planning and Forecasting 

• Develop quarterly account, category and franchise level forecasts leveraging current sales, seasonality, industry trends, and internal Sales feedback to accurately project sales for fiscal year with upside or downside risks to plan. 
• Prepare retail focused marketing and program investment ROI planning and analytics in partnership with Sales, Retail Marketing, and Finance teams.

Required Qualifications

• Bachelor’s degree in Business, Finance, Accounting, Economics, or other quantitative field of study
• 3-5 years of business or retail analytics, retail planning, or category buying experience
• High level of fluency in Microsoft Excel including pivot tables and complex formulas.
• Experience with Data Architecture, Data Modeling and Report Creation with Data Visualization tools (Tableau, Power BI, Microstrategy)
• Experience using third party syndicated data and platforms such as Circana, Euromonitor, IRI, Nielsen
• Ability to manage large datasets, interpret data, identify insights, and articulate into actionable strategies
• Data and results oriented with excellent attention to detail
• Highly organized and ability to manage multiple assignments simultaneously under tight deadlines with limited direction. 
• Excellent analytical reasoning and problem-solving skills
• Track record of collaboration with cross-functional teams
• Strong communication and presentation skills

Desired Qualifications

• Familiarity with Snowflake queries or other big data environments
• Experience in Entertainment based industry
• Python
• SQL

Eligibility Requirements

• Interested candidates must submit a resume/CV online to be considered.
• Must be willing to submit to a background investigation.
• Must have unrestricted work authorization to work in the United States.
• Hybrid: This position has been designated as hybrid, generally contributing from the office a minimum of three days per week.

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.