Business Intelligence Analyst in Sheffield

The University of Sheffield is a remarkable place to work. Our people are at the heart of everything we do. Their diverse backgrounds, abilities and beliefs make Sheffield a world‑class university. We offer a fantastic range of benefits including a highly competitive annual leave entitlement, a generous pensions scheme, flexible working opportunities, a commitment to your development and wellbeing, a wide range of retail discounts, and much more.

As part of the Business Intelligence Team, you will work collaboratively to develop and maintain the University’s Data Warehouse and successfully deliver the University Reporting Service. You will lead on the development of key reporting areas to translate stakeholder requirements into technical specifications and deliver a solution relevant to the needs of the business, either through reporting or statutory returns. You will use your existing technical and analytical skills, whilst actively developing further in the application and knowledge of SQL, data warehousing and industry‑leading reporting tools.

Main duties and responsibilities:

• Lead on the delivery of key areas of Business Intelligence or Statutory Returns, ensuring timeliness and accuracy of data.
• Work with stakeholders across the University and statutory regulators to gather detailed user requirements and translate them into appropriate reporting specifications.
• Set up ETL processes to develop and mature the University’s Data Warehouse, using an agreed, methodical, and well‑documented approach.
• Design and deliver key strategic dashboards and complex analysis based on business requirements, using your own initiative and expertise to provide innovative solutions to reporting challenges.
• Lead on the training and development of the Reporting Service to University colleagues and promote best practices in Business Intelligence.
• Develop and maintain an understanding of the University’s corporate systems, the data held within them and the onward use of the data.
• Develop and maintain a specialist understanding of data rules or statutory guidance and the impact any changes have on the University’s data.
• Contribute to the development and maintenance of documentation to support robust processes, including a data dictionary, requirements documentation, and reports specifications.
• Support good data management in the University by identifying and highlighting data quality issues that impact on reporting, GDPR, and Business Intelligence.
• Monitor use and engagement of reporting, including periodic report reviews that take into account feedback and the changing needs of the University.
• Carry out other duties, commensurate with the grade and remit of the post.

Person Specification:

Our diverse community of staff and students recognises the unique abilities, backgrounds, and beliefs of all. We foster a culture where everyone feels they belong and is respected. Even if your past experience doesn't match perfectly with this role’s criteria, your contribution is valuable, and we encourage you to apply. Please ensure that you reference the application criteria in the application statement when you apply.

Essential Criteria:

• Experience of interpreting business requirements and successfully translating them into appropriate reporting solutions.
• Demonstrable experience of using database query languages, e.g. T‑SQL.
• Experience of using software for developing ETL routines, e.g. SSIS.
• Experience of using data visualisation and reporting software, e.g. Power BI, Tableau, SSRS.
• Experience of influencing and collaborating with stakeholders, managing expectations and developing good working relationships.
• Excellent communication skills and the ability to present complex analysis to a diverse audience.
• The ability to plan work, manage several projects at once and a consideration for future proofing.
• An understanding of Data Protection (including GDPR) and the ability to apply data governance principles to all areas of work.
• The ability to understand and apply business rules or statutory guidance to data.

Desirable Criteria:

• The ability to document systems and process, including data dictionaries and entity‑relationship diagrams.
• Experience of contributing to and working within wider strategic planning.

Further Information:

Grade: 7
Salary: £38,784 – £47,389 per annum. Potential to progress to £51,753 per annum through sustained exceptional contribution.
Work arrangement: Full‑time, hybrid (2 days minimum in office)
Duration: Open ended
Line manager: Business Intelligence Manager

For informal enquiries about this job contact Hugh Mather, Business Intelligence Manager, on h.mather@sheffield.ac.uk.

Next steps in the recruitment process:

It is anticipated that the selection process will take place during the week commencing 20 July. This will consist of an interview panel and a test of your analysis skills. We plan to let candidates know if they have progressed to the selection stage on the week commencing 13 July. Contact Leigh Gibson (leigh‑ann.gibson@sheffield.ac.uk) if you require any reasonable adjustments.

What we offer:

• A minimum of 41 days annual leave including bank holiday and closure days (pro rata) with the ability to purchase more.
• Flexible working opportunities, including hybrid working for some roles.
• Generous pension scheme.
• A wide range of discounts and rewards on shopping, eating out and travel.
• A variety of staff networks, providing opportunities for social interaction, peer support and personal development (Race Equality, LGBT+, Women’s and Parent’s networks).
• Recognition Awards to reward staff who go above and beyond in their role.
• A commitment to your development access to learning and mentoring schemes; integrated with our Academic Career Pathways and Professional Services Shared Skills Framework.
• A range of generous family‑friendly policies.
• Paid time off for parenting and caring emergencies.
• Access to menopause support in the workplace.
• Paid time off and support for fertility treatment and more.

More details can be found on our benefits page: sheffield.ac.uk/jobs/benefits.

We are a Disability Confident Leader. If you have a disability and meet the essential criteria for this job you will be invited to take part in the next stage of the selection process.

We are a research university with a global reputation for excellence. Our ideas and expertise change the world for the better, making a real difference to society. We know that when people come together with different views, approaches and insights it can lead to richer, more creative and innovative teaching and research and the highest levels of student experience. Our University Vision outlines our commitment to building a diverse community of staff and students that recognises and values the abilities, backgrounds, beliefs and ways of living for everyone.