Role: Business Information Analyst

JOB PROFILE

Salary: c£25,524 to £29.580 per annum (pro rata where applicable)

Accountable to:MIS Systems and Reporting Manager

Accountable for:n/a

To work with people at all levels of the organisation to understand their information needs and develop high quality, effective solutions in a timely fashion, primarily using Microsoft Reporting services 2015 and above using data from various database systems, mainly the student data system, currently based on Microsoft SQL Server 2016.

To work with the team to develop data warehouse and BI dashboard-style reporting solutions to improve performance and usability.

Development Environment

The main report development environment is Microsoft SQL Server Management Studio v5 and above for developing SQL queries, views, stored procedures and functions, and Microsoft SQL Server Reporting Services (SSRS) 2015 and above for developing tabular reports for deployment to the SSRS report server.

Some ad hoc reporting is done in Microsoft Excel, and occasionally, Microsoft Access.

We plan to implement data warehousing to improve report performance and allow for advanced reporting solutions – this will be implemented using Microsoft SQL Server 2016 and above.

We plan to implement a BI dashboard-style reporting facility – this is likely to be Microsoft Power BI.

Portfolio of responsibilities:

To collaborate with Reporting Team members and people across the college to analyse reporting requirements large and small, agree solutions, develop, test, document, and implement usable and effective reports in a timely fashion.

To work with Reporting Team members to help design, implement and maintain an effective data warehouse solution to improve performance and allow for advanced reporting solutions.

To work with Reporting Team members to implement, maintain, and develop a BI dashboard-style reporting facility to enable improved data presentation and reporting interface usability.

To adhere to the Reporting Team development and organisational standards.

To work within agreed project and development deadlines.

Corporate responsibilities

To contribute to the strategic direction and operational effectiveness of the College.
To ensure the responsibilities of the post are carried out in a way that reflects the standards, vision and values of the college.
To deliver on key performance indicators across the College, aiming to deliver continuous improvement.
To promote the College with employers, sector bodies, schools and the local community, developing effective partnerships with employers, the funding agencies and other representative bodies.
To proactively promote Safeguarding practice, EDI and Health and Safety.

PERSON SPECIFICATION

Role: Business Information Analyst / E/D / A / I / T
Qualifications:
1 / A degree or equivalent experience in computing / E / X
2 / Demonstrable recent relevant professional development and training / E / X
Experience and Skills:
3 / Experience of analysing data and producing data reports / E / X / X
4 / Experience of working with people to produce effective report specifications / E / X / X
5 / To have developed SQL queries, views, stored procedures and functions using Microsoft SQL Server 2016 and above, or equivalent / E / X / X / X
6 / To have developed and delivered reports using Microsoft SQL Server Reporting Services 2015 and above, or equivalent / E / X / X / X
7 / To have used Microsoft Excel and Access to deliver ad hoc reports. / E / X / X
8 / Experience of working to and meeting deadlines / E / X / X
9 / Experience of delivering support and training / E / X / X
10 / Experience of working in an education institution / D / X / X
11 / Experience of working with student data systems / D / X / X
12 / Experience of or interest in data warehousing / D / X / X
13 / Experience of or interest in BI dashboard-style reporting solutions / D / X / X
Personal Attributes
14 / Excellent interpersonal and communication skills / E / X / X
15 / Good organisational skills / E / X / X
16 / Strong problem solving skills and use of initiative / E / X / X
17 / Able to work effectively as a member of a team and as an individual / E / X / X
18 / A respectful and inclusive attitude to learners and colleagues / E / X / X
19 / Commitment to quality and excellence through evidence of relevant continuing professional development / E / X / X
20 / A flexible approach to working hours and ability to attend meetings and work at various sites across the city. / E / X
21 / Demonstrates a knowledge and understanding of Safeguarding /Child Protection issues relevant to the post / E / X
Equality of opportunity:
22 / A commitment to uphold and promote Equality of Opportunity / E / X

KEY:

E / Essential
D / Desirable
A / Assessed by Application Form
I / Assessed by Interview
T / Assessed by Test

Business Information Analyst March 2018Page 1