Description Position at Creative Assembly

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 SEGARead game design documentation to understand the core loops of our gamesCollect requirements for and plan new game, finance, and brand reporting, tooling and automationBuild and maintain dashboards using PowerBI and Databricks SQLProduce analysis and insights for our Launch Report and Key Player Metrics processesWork with our data engineers to design, build and maintain reporting data pipelinesProduce ad-hoc analysis on everything from player preferences, balancing, sentiment, title ownership and beyondBe 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 BIDatabricks  

Knowledge, Skill and Experience 

Essential 

Love video games and are highly motivated by the chance to play a key role in their productionHave 4 years of experience working with data as an analyst or BI engineerAre curious, with keen attention to detail and low tolerance for errors and can spot trends, risks and opportunitiesAre an expert in PowerBI and DAX and understand efficient data modellingMake good looking, clean and easy to understand data visualizationsKnow 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 storiesCan write complex and efficient SQL queriesUnderstand key game KPIs like DAU, MAU, ARPU, Steam Scores, Attach rates, etcGood soft skills – you communicate well in person and online, and are comfortable talking to all different kinds of people across our project teamsAre well organized – you get stuff doneAre a creative problem solver – you come up with and suggest creative ways to tackle problems 

Desirable

Are a Total War or Alien: Isolation superfanUnderstand the game development cycle and are familiar with different monetization models or have previous experience in the industryAre comfortable writing Python scripts for data wrangling and API interactionHave previously worked with Databricks as an analystKnow how to do CI/CD with data products built on Databricks or FabricUnderstand how to use Jira and ConfluenceKnow the difference between descriptive and inferential statistics and when to use themHold a valid PL-300 or Databricks Certified Data Analyst AssociateHave previous experience in consulting or research experience  

About Creative Assembly
Creative Assembly crafts deep and detailed games that last, entertaining millions of players across the globe for decades.

We are all game makers and we care deeply about the experiences we create. We empower our teams to make significant contributions to our games, supported by skills development and growth opportunities.

We are located in Horsham, UK and Sofia, Bulgaria.

Most roles at Creative Assembly are hybrid; what this looks like will be discussed during the interview process. For many teams this is 3 days a week in the studio. CA has the right to change requirements based on the needs of the business.

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 holidaysBespoke relocation package for you and your dependentsPrivate medical and dental insurance, life insurance, permanent health insurance, critical illness cover and free health care screeningGenerous holiday allowance plus full studio closure over the Christmas and New Year period, and all Bank holidaysJoin our Diversity and Inclusion Network – an employee-led groupSeason ticket travel loans and cycle to work scheme with free bike servicing and discounted car valet service on siteWellbeing support and virtual confidential counsellingCommunity activities including parties, football and more.Our studio sites have disabled access.Hybrid working

We are an equal opportunities employer and encourage applications from suitably qualified and eligible candidates regardless of sex, race, disability, age, sexual orientation, gender reassignment, marriage or civil partnership, pregnancy or maternity, religion or belief.

Note to Recruitment Agencies: SEGA Europe Limited and our studios do not accept unsolicited candidate introductions from unauthorized third parties. For the avoidance of doubt, SEGA Europe is not liable for any fees, compensation or any other costs associated with the introduction of a candidate or recruitment services unless and until an agreement has been duly executed. Further details can be found here.