Reporting Solutions Analyst

This is a full-time, permanent position on Crick terms and conditions of employment.

About us… The Francis Crick Institute is Europe’s largest biomedical research institute under one roof. Our world-class scientists and staff collaborate on vital research to help prevent, diagnose and treat illnesses such as cancer, heart disease, infectious diseases and neurodegenerative conditions. The Crick is a place for collaboration, innovation and exploration across many disciplines. A space where the brightest minds can pursue big and bold ideas and discover answers to crucial scientific questions. We support them in a dynamic environment which fosters excellence with state-of-the-art infrastructure, cutting-edge facilities, and a creative and curious culture. We’ve removed traditional boundaries of departments, divisions and disciplines and instead have an open approach that supports every researcher. This gives us the freedom to take risks and carry out high-quality, pioneering research. Creating a space for discovery without boundaries helps us to turn our science into benefits for human health and the economy.

About the role… We are looking for an enthusiastic and engaged Reporting Solutions Analyst to join the Data Management & Analytics Platform team. 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. 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, accommodating 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 diversely 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. At the Crick we believe in science without boundaries, and we encourage trying new ways of working; there will be scope in this role to develop in this aspect.

What you will be doing… As a Reporting Solutions Analyst at the Crick, you will:

• Undertake solution design and engineering using Power Platform components (e.g., 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 licensing of Power Platform components across the Crick – tracking usage, approving licenses (assigned by sys admins), gatekeeping Active Directory groups associated with these technologies.
• Clean, transform, and prepare data for reporting, ensuring quality data assurance.

About you… You will bring…

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

About Working at the Crick… Our values Everyone who works at the Crick has a valuable role to play in advancing the Crick’s mission and shaping our culture! We are bold. We make space for creative, dynamic and imaginative ideas and approaches. We’re not afraid to do things differently. We are open. We’re highly collaborative and interactive, and make sure our activities are visible to the outside world. We are collegial. We show respect for one another, work cooperatively and support the wider community.

At the Francis Crick Institute, we believe that diversity and inclusion are essential to driving innovation and scientific discovery. We are committed to creating a workplace where everyone feels valued, respected, and empowered to succeed, regardless of their background, identity, or personal circumstances. We actively encourage applications from individuals of all genders, ethnicities, abilities, and experiences. We want to ensure that everyone can apply and be part of our recruitment processes and so we'll make reasonable adjustments if you need them - just let us know when you apply. If you need assistance with applying (i.e., would like to apply by phone or post) please email.

What will you receive? At the Francis Crick Institute, we value our team members and are proud to offer an extensive range of benefits to support their well-being and development:

• Visas: Applicants for this role will be eligible for sponsorship to work in the UK.
• Generous Leave: 28 days of annual leave, plus three additional days over Christmas and bank holidays.
• Pension Scheme: Defined contribution pension with employer contributions of up to 16%.
• 24/7 GP consultation services.
• Occupational health services and mental health support programs.
• Eye care vouchers and discounted healthcare plans.
• Work-Life Balance: Childcare support allowance. Annual leave purchase options. Discounted gym memberships, bike-to-work scheme, and shopping discounts.
• Subsidised on-site restaurant and social spaces for team interaction.
• Development & Recognition: Comprehensive training, mentoring, and a pay structure with performance-linked progression.