Business Intelligence Analyst

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.

Criteria

Essential or desirable

Stage(s) assessed at

Experience of interpreting business requirements and successfully translating them into appropriate reporting solutions

Essential

Application and interview

Demonstrable experience of using database query languages, e.g. T-SQL

Essential

Application and test

Experience of using software for developing ETL routines, e.g. SSIS

Essential

Application and interview

Experience of using data visualisation and reporting software, e.g. Power BI, Tableau, SSRS

Essential

Application, test and interview

Experience of influencing and collaborating with stakeholders, managing expectations and developing good working relationships

We offer a fantastic range of benefits including a highly competitive annual leave entitlement (with the ability to purchase more), a generous pensions scheme, flexible working opportunities, a commitment to your development and wellbeing, a wide range of retail discounts, and much more., 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 document systems and process, including data dictionaries and entity relationship diagrams, Experience of contributing to and working within wider strategic planning

Pulled from the full job description

• Annual leave
• Employee discount
• Company pension, £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, 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 (for example, 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; 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

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 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 (www.sheffield.ac.uk/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.