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

Company Description

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

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.

Comcast NBCUniversal has announced its intent to create a new publicly traded company ('Versant') comprised of most of NBCUniversal's cable television networks, including USA Network, CNBC, MSNBC, Oxygen, E!, SYFY and Golf Channel along with complementary digital assets Fandango, Rotten Tomatoes, GolfNow, GolfPass, and SportsEngine. The well-capitalized company will have significant scale as a pure-play set of assets anchored by leading news, sports and entertainment content. The spin-off is expected to be completed during 2025.

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. 
• Pr