Senior Data Analyst

Description

Creative Assembly is looking for a PowerBI and SQL ninja with deep knowledge of games and our products to come and support our Game Data Analytics & Insights.

As part of the Analytics & Insights team, you’ll report to the Analytics & Insights Manager and work across all our projects in the studio. It’s a critical role that will help ensure SEGA, Studio Leadership, Game Designers, Brand and Community/PX teams have the best tooling, analysis and insights possible to understand how people play, buy, and talk about our games.

Come and help us build our upcoming titles!

Key responsibilities

On a day-to-day basis, you will:

• Build relationships with stakeholders across the studio and at SEGA
• Read game design documentation to understand the core loops of our games
• Collect requirements for and plan new game, finance, and brand reporting, tooling and automation
• Build and maintain dashboards using PowerBI and Databricks SQL
• Produce analysis and insights for our Launch Report and Key Player Metrics processes
• Work with our data engineers to design, build and maintain reporting data pipelines
• Produce ad-hoc analysis on everything from player preferences, balancing, sentiment, title ownership and beyond
• Be able to organise and plan your workload semi-independently, managing multiple responsibilities and demands at once.

From time to time, you may:

• Be asked to produce analysis, insights, or viz/dashboarding for our Production Intelligence data

The stack you’ll work with is:

• Power BI
• Databricks

Knowledge, Skill and Experience

Essential

• Love video games and are highly motivated by the chance to play a key role in their production
• Have 4 years of experience working with data as an analyst or BI engineer
• Are curious, with keen attention to detail and low tolerance for errors and can spot trends, risks and opportunities
• Are an expert in PowerBI and DAX and understand efficient data modelling
• Make good looking, clean and easy to understand data visualizations
• Know your way around a PowerPoint deck, are comfortable presenting findings to senior people, and can explain complex things in simple terms by crafting compelling data stories
• Can write complex and efficient SQL queries
• Understand key game KPIs like DAU, MAU, ARPU, Steam Scores, Attach rates, etc
• Good soft skills – you communicate well in person and online, and are comfortable talking to all different kinds of people across our project teams
• Are well organized – you get stuff done
• Are a creative problem solver – you come up with and suggest creative ways to tackle problems

Desirable

• Are a Total War or Alien: Isolation superfan
• Understand the game development cycle and are familiar with different monetization models or have previous experience in the industry
• Are comfortable writing Python scripts for data wrangling and API interaction
• Have previously worked with Databricks as an analyst
• Know how to do CI/CD with data products built on Databricks or Fabric
• Understand how to use Jira and Confluence
• Know the difference between descriptive and inferential statistics and when to use them
• Hold a valid PL-300 or Databricks Certified Data Analyst Associate
• Have previous experience in consulting or research experience

We offer many benefits to support you and your family including:

• Work from Anywhere for a temporary period each year (restrictions apply such as VISAs)
• Enhanced holiday allowance, maternity and paternity breaks, flexibility with our core hours, and no-notice holidays
• Bespoke relocation package for you and your dependents
• Private medical and dental insurance, life insurance, permanent health insurance, critical illness cover and free health care screening
• Generous holiday allowance plus full studio closure over the Christmas and New Year period, and all Bank holidays
• Join our Diversity and Inclusion Network – an employee-led group
• Season ticket travel loans and cycle to work scheme with free bike servicing and discounted car valet service on site
• Wellbeing support and virtual confidential counselling
• Community activities including parties, football and more.
• Our studio sites have disabled access.
• Hybrid working