Position at Creative AssemblyCreative 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 DMsWork with project DMs to understand each team's approach to developmentCollect requirements for and plan new project management reporting, tooling and automationsBuild and maintain dashboards using PowerBI and Databricks SQLWork with our Data Engineers to design, build and maintain reporting data pipelinesProduce ad-hoc analysis about the state of production for various stakeholders and produce high-impact insightsBe 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 dataThe stack you'll work with is:JIRARunn.ioWorkdayPower BIDatabricksKnowledge, Skill and ExperienceEssentialYou love video games and are highly motivated by the chance to play a key role in their productionYou have 4 years of experience working as an analyst/BI engineer or with agile software projectsAre curious, with keen attention to detail and low tolerance for errors and can spot trends, risks and opportunitiesYou know what Agile and Jira are and how software dev teams use them to manage large projectsKnow descriptive statistics, when to use a median instead of a mean and can explain at least one kind of error-barYou're a pro in all aspects of PowerBI and DAXYou make good looking, clean and easy to understand data visualizationsYou know your way around a PowerPoint deck, are comfortable presenting to audiences, can explain complex things in simple terms, and construct compelling data storiesCan write complex and efficient SQL queries like a proGood soft skills – you communicate well in person or online, and are comfortable talking to all different kinds of people across our Production teamsWell organized - you get stuff doneCreative problem solver – you come up with and suggest creative ways to tackle problemsDesirableComfortable writing Python scripts for data wrangling and API interactionYou've worked with Databricks as an analyst in the pastYou're familiar with DataOps and know how to use Git in conjunction with PowerBI or DatabricksExperience with scenario modelingKnowledge of time-series forecasting techniquesKnow the difference between descriptive and inferential statistics and when to use themFamiliar with the game development lifecycle or previous experience at a studioPrevious experience in consulting or academic researchAbout Creative AssemblyCreative 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 holidaysPrivate 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 workingWe 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.