Creative Assembly is looking for a PowerBI and SQL ninja with experience in agile project management reporting to come and help drive Production Intelligence at CA.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 crucial role that will help ensure SEGA, Studio Leadership and our Development Managers (DMs) have the best tooling, analysis and insights possible to understand how development of our new games is progressing.The role is hybrid, and you will typically work from the Horsham Studio three days per week. This will be discussed during the interview process. CA has the right to change requirements based on the needs of the business.Come help us build our upcoming titles!Key responsibilitiesOn a day-to-day basis, you will:

• Build relationships with SEGA, Studio Leadership and DMs
• Work with project DMs to understand each team's approach to development
• Collect requirements for and plan new project management reporting, tooling and automations
• Build and maintain dashboards using PowerBI and Databricks SQL
• Work with our Data Engineers to design, build and maintain reporting data pipelines
• Produce ad-hoc analysis about the state of production for various stakeholders and produce high-impact insights
• Be able to organize 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 game, financial or feedback data

The stack you'll work with is:

• JIRA
• Runn.io
• Workday
• Power BI
• Databricks

Knowledge, Skill and ExperienceEssential

• You love video games and are highly motivated by the chance to play a key role in their production
• You have 4 years of experience working as an analyst/BI engineer or with agile software projects
• Are curious, with keen attention to detail and low tolerance for errors and can spot trends, risks and opportunities
• You know what Agile and Jira are and how software dev teams use them to manage large projects
• Know descriptive statistics, when to use a median instead of a mean and can explain at least one kind of error-bar
• You're a pro in all aspects of PowerBI and DAX
• You make good looking, clean and easy to understand data visualizations
• You know your way around a PowerPoint deck, are comfortable presenting to audiences, can explain complex things in simple terms, and construct compelling data stories
• Can write complex and efficient SQL queries like a pro
• Good soft skills – you communicate well in person or online, and are comfortable talking to all different kinds of people across our Production teams
• Creative problem solver – you come up with and suggest creative ways to tackle problems
• Comfortable writing Python scripts for data wrangling and API interaction
• You've worked with Databricks as an analyst in the past
• You're familiar with DataOps and know how to use Git in conjunction with PowerBI or Databricks
• Experience with scenario modeling
• Knowledge of time-series forecasting techniques
• Know the difference between descriptive and inferential statistics and when to use them
• Familiar with the game development lifecycle or previous experience at a studio
• Previous experience in consulting or academic research

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 holidays
• 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.

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 befound here .