Job Title: Management Information and Business Intelligence Trainee Analyst/Developer

Job Description

Job Title: Management Information and Business Intelligence Trainee Analyst/Developer

Faculty/Department: ICTD

Reporting to: MI/BI Service Manager

Duration: Continuing

Job Family: Specialist (IT)

Pay Band: 5

Benchmark Profile: Specialist (IT) Band 5

DBS Disclosure requirement: N/A

Vacancy Reference: IT0058

Details Specific to the Post

Background and Context

The Information and Communication Technology Department (ICTD) is based on the Hull campus of the University within the Applied Science building.

The purpose of ICTD is to support, improve and transform the way ICT is used across the University of Hull. The University ICT Strategy has 8 key objectives and the ICTD is working in partnership with the rest of the University to:

•Significantly improve the University ICT infrastructure as part of the ICT Transformation Programme.

•Upgrade or replace key University software systems through a focussed core systems refresh within the ICT Transformation Programme.

•Monitor and maximise benefits delivered from the upgraded infrastructure and core systems programmes.

•Develop and implement a University of Hull ICT governance model.

•Provide clearly defined support for research.

•Improve support of teaching and learning and the audio-visual development programme.

•Improve and articulate service quality.

•Improve the student experience.

The University has developed an Information Systems and Technology Transformation Roadmap that has been approved by the University Executive Group. The majority of the University’s information systems are being replaced, with concurrent review and standardisation of business processes. The ICT Department is providing a systems integration, data warehousing, and Management Information & Business Intelligence service alongside these Information Systems projects and requires an Analyst/Developer, reporting to the MI/BI Service Manager.

The post holder will have an important role in provision of a Management Information and Business Intelligence service to the University.

Specific Duties and Responsibilities of the post

The primary purpose of the role is the analysis, design, implementation, testing, documenting and maintenance of new and amended management information assets. These activities will be carried out using a variety of Software Development methodologies appropriate to the task, but likely including Waterfall and Agile methodologies. The intricacies of certain methods will vary depending upon the system and software development methodology.

The University’s current development approach is to use the Microsoft BI stack. This may change in the future and depending upon business case other tools may be employed.

The main objectives of the post are to:

Successfully complete training and pass examination to obtainMicrosoft Certified Solutions Associate (MSCA) level qualification.

• Assist in team based IT Systems development and be involved in pre- and post-implementation phases of IT Systems Development including: maintenance and release processes, software configuration, change and release management and production support; Adhere to good software programming practices and standards to ensure the IT System’s maintenance is efficient, especially in a team development environment;
• Assist in the operation, maintenance and management of software tools used to support efficient and effective software development, including Source Code and build management tools, software test management tools, requirements engineering and solution documentation tools.
• Work with internal ICT specialists to assist in determining optimal data models from which analysis and reporting can be carried out.
• Assist in the design, development and maintenance of reporting and analysis data marts
• Assist with the resolution of data quality issues.
• Assist in the design, development and maintenance of the University Data Warehouse.
• Assist in the develop methods within the data warehouse that provide the ability to combine disparate datasets for the purpose of analysis, including, but not limited to; Student Information System, HR System, Virtual Learning System, Student Engagement System, Student Accommodation System and Finance System.
• Create documentation and user guides for management information and business intelligence solutions.

GENERIC JOB DESCRIPTION

The job duties and responsibilities listed below are intended to describe the general nature of the role. The duties and responsibilities and the balance between the elements in the role may change or vary over time depending on the specific needs at a specific point in time or due to changing needs in the department. Candidates should note that there may not be an immediate requirement to carry out all the activities listed below.

Overall Purpose of the Role

The role holder:

•Assist MI/BI Team with IT support, directly or indirectly, to faculty and/or department and students as appropriate to their level of development and understanding.

•Will work towards gaining the professional qualification Microsoft Certified Solutions Associate (MSCA).

•Will use skills learnt through formal training and hands of practical experience to influence decisions or events by working collaboratively internally and externally to the University.

•Will evaluate and analyse information and use initiative and creativity to solve non-standard problems.

Main Work Activities Communication

•Explains IT procedures, technical processes, equipment and software operation to students, staff and visitors.

•Gives advice and guidance to staff and students on various IT related topics.

•Presents information to staff and colleagues through PowerPoint presentations and/or practical demonstration.

•Creates technical instructions and user guides.

Teamwork and Motivation

•Provides day-to-day support to other members of staff and members of staff new to the work area.

•Provides advice and guidance to the team pertaining to new initiatives/services and processes and procedures.

Service Delivery

• Provides IT, computing and network and AV support to staff and students.
• Install, configure, maintain and support applications and systems software and associated peripheral equipment.

Planning and Organisation

• Plans and prioritises own work in order to meet deadlines.
• Checks and monitors equipment is in good working order and produce schedules to manage this.

Analysis/Reporting

• Fault diagnosis, test and maintain equipment
• Keep up to date with latest developments/software/equipment
• Analyses data, for example:
• Event logs
• Network traffic logs

Teaching and Learning Support

• May be required to instruct students and staff on the use or configuration of a range of software and IT/AV equipment.

Additionally the post holder will be required to:

•Fulfil the employees’ duties described in the University’s health and safety policies and co-operate with the health and safety arrangements in place within the department. May be required to undertake specific health and safety roles on request e.g. Display screen equipment assessor, departmental safety officer, fire warden

•Show a commitment to diversity, equal opportunities and anti-discriminatory practices This includes undertaking mandatory equality and diversity training

•Comply with University regulations, policies and procedures

COMPETENCY SPECIFICATION

To fulfil your role, you will need certain knowledge, skills and competencies. The following competency specification provides a framework within which your performance will be assessed. The interview assessment may include, for example, testing on IT skills.

The Competencies set out below are essential and are core requirements needed to perform the role and any candidate who fails the requirement will not be taken forward for further assessment or to interview.

Competency / Identified by

Knowledge and Experience

Can demonstrate a broad range of IT knowledge. / Application/Interview
Is capable of learning new concepts, ideas, procedures and systems. / Application/Interview
Have gained a relevant professional qualification and / or a relevant academic qualification or can demonstrate substantial experience with experiential learning and continuing professional development which is equivalent. / Application/Interview
Can demonstrate knowledge of software development, and associated methodologies, preferably including Information Systems development. / Application/Interview
Can demonstrate a knowledge of SQL and the ability to develop complex SQL queries. / Application/Interview/Test
Has knowledge of data modelling techniques, being competent to design and implement fully normalised data models in relational databases and star schemas in data warehouse. / Application/Interview/Test
Can demonstrate a willingness to learn the Microsoft Business Intelligence Stack, including Integration Services, Analysis Services, Reporting Services and end user analytics tools. / Application/Interview/Test
Communication (Oral and Written)
Can demonstrate the ability to provide information in a suitable format so that the others’ needs are met and adjusts the level of content to help others understand. / Application/Interview
Teamwork and Motivation
Can demonstrate the ability to work effectively as part of a team. Is willing to provide cover for colleagues and acts in a supportive manner. / Application/Interview
Liaison and Networking
Can demonstrate the ability to work with others outside the immediate area to ensure that accurate information is passed on promptly to the most appropriate people to improve working practices. / Application/Interview
Service Delivery
Has knowledge and understanding of services available to users of this and related areas of work and ensures that the experience of each customer is positive and satisfactory. / Application/Interview
Planning and Organisation
Can demonstrate the ability to create realistic plans to achieve own deadlines and objectives. Monitors progress of self and/or others and can prioritise tasks/activities effectively. Suggests ways of improving working practices and use of resources. / Application/Interview
Initiative and Problem Solving
Can demonstrate the ability to use initiative to recognise problems and offer solutions. / Application/Interview
Analysis/Reporting
Can demonstrate the ability to use appropriate sources of data to answer questions, gather data systematically and carry out basic analysis accurately and methodically. / Application/Interview

Specialist (IT) Band 5 (Generic)

4 June 2011

Version 6