e-Commerce Analyst (Wizards of the Coast)

Date: Jan 15, 2021

Location: GB

Company: Hasbro

Wizards of the Coast, (‘WotC’) is one of the world's largest publisher of adventure games, including Magic: The Gathering® Trading Card Game and Dungeons & Dragons® Roleplaying Games. Hasbro SA, which is based in Delemont Switzerland, sells WotC products in Europe through its distributor Hasbro European Trading BV, (‘HET’). WOTC Europe is part of this local Hasbro entity and provides services to HET.

The role will consist in turning data into valuable insights to drive HET online sales with Wizards of the Coast (Wizards) brands. You will be required to combine data from multiple sources in order to provide insights/analytics that will enable our e-Commerce team to make informed decisions, support our marketing initiatives and optimise our operations efficiencies.

A day in the life

  • Design, run and update an e-Commerce performance reporting capability, showing metrics such as sell-in, sell-out, revenue, stock levels, LBB, net PPM, average trends at a European level.
  • Build and distribute a regular update of European e-Commerce performance with Wizards brands.
  • Measure on platform marketing campaigns results, track Storefronts’ metrics and produce insights and recommendations.
  • Provide analysis on web behavior, identify future channel trends and anticipate impact on business
  • Create a complex forecast system based on both quantitative and qualitative data to estimate future sales and stock needs on defined timelines.
  • Design and maintain dashboard that tracks e-Commerce HET profitability on Wizards brands.
  • Produce specific and dedicated reports on defined events when required (launch, gift campaign, etc.)
  • Work in close relationship with third party data providers to on-board new solutions.

What you’ll bring :

  • Experience in a commercial, financial or insights-based role
  • Advanced level in Microsoft Excel with excellent ability in PowerPoint
  • Very high attention to detail and data input accuracy
  • High level of planning and organizational skills
  • Excellent communication skills, both written and oral
  • Creative problem solver with the ability to show information in a highly visual way.
  • Willingness to develop skills set and grow as the sole analyst in a growing team
  • Strong commercial awareness: able to understand the market Wizards brands operates in and the team’s strategy.

 

Desirable:

  • Experience with reporting/stats packages (e.g. Power BI, Tableau)
  • Experience with SQL/DAX/Python languages (MS Analysis Services)
  • Experience with Amazon analytics reporting system (ARAP)

 

Hasbro is committed to equality of opportunity in all aspects of employment. We are committed to making all employment decisions without regard to race, color, religion, sex, sexual orientation, gender identity or expression, national origin, age, marital status, or any other legally-protected status.

We will ensure that individuals with disabilities are provided reasonable accommodation to participate in the job application or interview process, to perform essential job functions, and to receive other benefits and privileges of employment. Please contact us to request accommodation.


Job Segment: Database, SQL, Technology