Reporting Solutions Analyst, Francis Crick

• If you have a degree in Business or Data Analytics, or work-related experience, as well as knowledge of Microsoft Power Platform, this may be the perfect opportunity for you
• An undergraduate degree in Business or Data Analytics, or non-degree equivalent experience considered
• Experience of or Microsoft accreditation in Power BI and Power Platform components
• Software solution engineering using Power Platform components and SQL for data read/write from data sources. Evidence of operational systems deployed and maintained
• Experience extracting data from various sources such as Microsoft SQL Server and APIs
• Experience of building PowerBI reporting solutions (desktop and web versions) including PowerBI DAX skills

• Reports to: Teresa Whitter
• We are looking for an enthusiastic and engaged Reporting Solutions Analyst to join the Data Management & Analytics Platform team
• You will be responsible for Power BI report development, SQL development additionally supporting colleagues in these areas
• You will also be responsible for gathering all the necessary information and requirements for projects and will be the point of contact and liaison between the team and those working on the projects
• This role will also require you to be agile, accommodation to changes and changing requirements of the projects and role
• You will be able to engage with colleagues across various departments and be able to foster positive relationships with various stakeholders, contributing to a collaborative work environment
• There are excessive learning opportunities within this role and you will be working in a diversly skilled team, with opportunities to tap into the wider team’s expertise across the whole department
• We have a very diverse set of data at the Crick, with various requirements and opportunities to learn and develop and understand the environment in which we work
• Working at the Crick and within the Data Management & Analytics Platform team will give you the opportunity to work with heterogeneous and diverse data sets and work with datasets that may not be available elsewhere
• Undertake solution design and engineering using Power Platform components (eg Power BI, Power Apps, Power Automate). Liaising directly with colleagues from across the organisation to gather and refine requirements. Engineer measures and KPIs in Microsoft DAX in support of needs
• Support the Power platform user community as it develops within the Crick
• Contribute to Power Apps decision boards and implementing the governance and control methods designed by this role and the wider PowerApps teams
• Support the licencing of Power Platform components across the Crick – tracking usage, approving licences (assigned by sys admins), gatekeeping Active Directory groups associated with these technologies)
• Clean, transform, and prepare data for reporting, ensuring quality data assurance

• Closing Date: 23/Mar/2025 23.59 GMT

• 28 days of holiday each year, plus three additional days (usually taken over Christmas) and bank holidays
• Defined contribution pension scheme, with the Crick contributing between 3% - 16% of salary
• Life assurance
• Season ticket/car parking loan
• Annual leave purchase
• Childcare support allowance
• Back-up dependent care
• Discounted annual gym membership
• Bike to Work scheme
• Payroll giving
• Shopping discounts

Total funding: $1.3bn

The Francis Crick Institute was founded in 2015 through the merger of the MRC's National Institute for Medical Research and CRUK's London Research Institute. Its mission is to push the boundaries of our understanding of how life works, and it is the largest single-site biomedical research institute in Europe.