Junior Market Analyst - 12 month FTC

Description Position at SEGA European Head Office 12 MONTH FTC MARKET RESEARCH & CONSUMER INSIGHTS TEAM BASED AT SEGA HQ IN BRENTFORD, WEST LONDON REPORTING TO THE DIRECTOR OF BUSINESS ANALYSIS A BIT ABOUT SEGA SEGA is one of the leading interactive entertainment companies in the world, with our European HQ based in West London and our five development studios spanning the UK, Bulgaria, France and Canada. Known for quality and creativity above all else, our studios include Sports Interactive, Amplitude Studios, Two Point Studios, The Creative Assembly and Relic Entertainment. At the heart of SEGA is our publishing team based in London, where we help the studios bring their creative vision to life. Here we have a hardworking bunch of people spanning Tech, Sales, Marketing, Finance, QA and more. Together, we drive the continued success and evolution of our Western business through living our company values of always collaborating, being entrepreneurial in spirit, having a winning mentality and focusing on uncompromising quality. WORKING THE SEGA WAY We believe that making the best games relies on having the best people, so we make sure that we look after ours... * For our gaming buffs, you can get involved in our lunchtime gaming sessions in our games lounge, regular gaming tournaments and free SEGA games on Steam * If you're more of a foodie, you can take advantage of Icecream Wednesdays or our fresh fruit and cereal every single day * Fitness fanatics will love our discounted gym membership, ride to work scheme, workout area and bootcamps in the park. You can find your zen with weekly yoga classes as well as in-house massage therapy * You'll have access to a comprehensive benefits package that includes life assurance, income protection, private healthcare & dental insurance schemes and an enhanced contributory pension scheme. We offer competitive salaries and a fantastic bonus scheme so that you can stay motivated and focused on making SEGA the best it can be * We hold regular lunch & learn sessions, company updates at the world-famous BAFTA theatre in Central London and Summer and Christmas parties that you'll want to brag to your mates about! What's not to love? * We pride ourselves on having flexible working hours to ensure that you have a life outside of the office * We want people of all backgrounds to see themselves represented and included in our work, so we actively seek to diversify our team and bring more voices to the table. All applicants are welcome! And that's just the tip of the iceberg. Check out our Careers website to find out why we are a workplace you'll never want to leave! POSITION OVERVIEW As a Junior Market Analyst, you'll play a key role in using sales figures and market data to inform sales projections and aid planning and company decision making. You'll collaborate with the Business Planning, Consumer Insights, Searchlight, Product Development, EMEA Sales and Marketing teams to provide sales reporting and pricing analysis at the product level, maximising our sales forecast accuracy by using external and internal data streams. You'll also support the publishing team and internal studios by delivering analysis on games industry market trends on a regular basis. KEY RESPONSIBILITIES * Maintain market trends reports on various topics e.g. sales performances, publisher performance, genres, platforms, developers, new business and territories, etc. * Monitor and maintain hardware forecast and other digital forecasts reports * Help in the preparation of company presentations for internal and external parties * Collate and analyse relevant market and sales data to input into Forecast review and creation process * Be a key member of strategic forecasting meetings and the product planning group, and present forecast methodologies and findings to the stakeholders * Help in the development of a strategic forecasting tools * Validation of product projections on a weekly and full year basis * Work closely with the consumer research division to ensure the follow up of upcoming internal titles KNOWLEDGE, SKILLS & EXPERIENCE Essential * Knowledge and interest in the video games industry / interest in new business models (F2P, Digital, subscription, etc.) * Strong proficiency at MS Excel e.g. PivotTables, Vlookups and graphs * Experienced in the use of the MS Office & data visualization tools (mainly Powerpoint, Excel) * Proven experience in Data Analysis & reporting * Very high attention to detail and data input accuracy * High level of planning and organisational skills and the ability to work on your own initiative * Proactive communication skills, and the ability to build effective relationships both internally and externally * You'll enjoy developing new systems and processes * You're a starter-finisher... you like to see projects through to the end and takes ownership Desirable * Expert at MS Excel e.g. Macros, Advanced functionality * Data cleaning & Database structuring/querying (SQL) skills