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

About the position

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.

Responsibilities

• 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.
• Assist in development, data visualization and distribution of overall UP&E, region, account, film release, and seasonal based reporting and performance recaps.
• Prepare presentations and read-outs to internal Sales and Category teams on business performance.
• Support Sales, Category and Franchise teams in preparation for key milestone meetings.
• Support the day-to-day operational activities for external data and insights providers.
• Extract, wrangle, and translate data from multiple databases/sources to solve business issues.
• Regularly develop Gaps and Opportunities analysis and analyze category and regions/countries market share.
• Provide distribution analysis to identify underpenetrated channel opportunities by region and country.
• Identify shopper trends and opportunities using third-party market level data.
• Assist with custom data requests and presentation needs for senior executives.
• Develop quarterly account, category and franchise level forecasts leveraging current sales, seasonality, industry trends, and internal Sales feedback.
• Prepare retail focused marketing and program investment ROI planning and analytics.

Requirements

• 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.
• Excellent analytical reasoning and problem-solving skills.
• Track record of collaboration with cross-functional teams.
• Strong communication and presentation skills.

Nice-to-haves

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

Benefits

• Medical insurance
• Dental insurance
• Vision insurance
• 401(k)
• Paid leave
• Tuition reimbursement
• Variety of other discounts and perks