Senior BI Developer

Job description

Job responsibilities

The post holder will Support the Head of Digital Intelligence in the delivery of the Performance Management aspects of the Trusts IM&T Strategy using skills in relational databases, SQL Server, and Business Intelligence (BI). They will develop and analyse and interpret business and performance information to ensure the accurate and timely production of reports and dashboards as per the requirements both internally and externally.

To develop dashboards and reports using Business Intelligence tools, primarily SSRS. The role will also be to develop, implement and maintain systems to ensure the efficient and effective collection of all performance management data and wider business intelligence.

Responsible for delivering the build of data tables and identify and address the continued development and maintenance of the Data Warehouse.

The post holder will manage the Junior Information Analysts workload and be responsible for the development of their skill set and any HR issues such as sickness or disciplinary

The post holder will be responsible for documenting all work and ensuring that wikis are created for each package of work and that other members of the team can understand the process

The post holder will be responsible for planning and delivering the B.I Strategy for the trust in conjunction with the Head of Department

The post holder will attend regular meetings to present highly complex, specialist analysis to a variety of audiences including Senior Managers and the Executive Team.

The post holder will be expected to work autonomously, be innovative, delivering work to a high standard within tight deadlines.

Main Duties and Responsibilities

To play a lead role in the development of business intelligence reports to meet the aims of the Business Intelligence Strategy and the needs of the organisation.

Take an instigative role in ensuring that wherever practical and appropriate the Data Warehouse is developed to enable greater and wider use of data / information for Business Intelligence and SLR. This will involve working closely with other developers to ensure co-ordination of developments on the data warehouse.

Work with users to resolve problems and issues with Business Intelligence software.

Aid in the provision of timely and quality assured Monthly Management Information and statutory Korner returns to Management, Department of Health and CCGs.

To be aware of national developments within the NHS wider Business Intelligence community.

To develop reporting integration solutions between multiple operational systems using the SQL.

Assist when required to ensure the timely completion of mandatory quarterly and annual returns for the Department of Health.

Autonomy to act upon, implement and advise where appropriate on new Data Set Change Notices (DSCN) issued by the Department of Health.

Research and recommend innovation, and where possible automated approaches for systems including BI.

Supervisory responsibilities over junior members in the team

Participate in the use of Trusts reporting tools and to develop an EIS for the Trusts Management Staff & train potential users.

Liaison with external agencies to identify and meet their Information requirements.

To assist with adding content to and maintaining the online Business

Intelligence system.

Ensure all departmental documentation is kept up-to-date as possible.

Support the Trusts Committee structure with its information requirements.

Participate at the Trusts Information management Groups as required, and play a key role in the resolution of information issues raised there.

Database design & support to meet users information needs outside of standard Trust systems.

Maintain awareness of national & local IM&T strategies.

Participate in own personal development review and undertake own professional development.

Manage the Junior B.I Member of the teams workload and be responsible for their development

Will be required to deliver projects to timescales and delivery change within 12months

General Duties and Responsibilities

The post holder also has the following general responsibilities:

To actively contribute to the overall development of the IM&T Department and the improvement of its services.

To assist in the development of IM&T policies, standards and procedures.

To identify, agree and monitor measurable performance objectives with the Head of Information or Deputy Head of Information.

Person Specification

Qualifications

• Masters degree or relevant training or experience in information/sql development/business intelligence field
• Evidence of professional development
• IT qualification.

• Working towards a Post-Graduate Degree in a relevant subject.
• Project Management qualification (such as Prince2)
• Microsoft SQL Certification

Experience

• Minimum of 3 Years Experience writing SQL
• Experience Managing/supervising junior members of team
• Experience using Microsoft SQL Server BI Stack
• Experience within the Business Intelligence field.
• Experience of Assisting, Capturing and Documenting Customer Requirements.
• Experience of Identifying, Managing or Communicating Data Quality Issues.
• Experience of web based Business Intelligence reporting software
• Planning, creation and implementation of software developments ideally within a data warehouse
• System design, Data Programming, facilitating Validation
• Track record of developing information outputs through assessment and use of the most efficient analytical tools

• Experience of SQL Server Analysis Services
• Experience of SQL Server Integration Services
• Experience of Designing and Building Relational Databases / Data Warehouses
• Experience of using Scrum Methodology.
• Experience of supporting clinicians and management in the provision and interpretation of information.
• Creation of Programme, Project and Work Plans
• Working with Financial / Performance software
• Experience of working in a busy NHS Information Department

Other

• Motivation and a willingness to learn.
• Drive for Personal and Team Development.
• Willing to adopt a Flexible approach to working hours.
• Challenging and inquiring mindset combined with an aptitude for working within a changing environment.
• Must remain calm under pressure.
• Attend relevant local and regional events.
• Willing to undertake further training

Skills and Attributes

• Microsoft T-SQL (at an Advance level)
• Excellent Numerical and Analytical skills.
• Excellent communication and presentation skills, both oral and written, combined with active participation and the ability to respond and provide direct feedback in sometimes-pressured circumstances.
• Customer focussed with strong business acumen
• Proactive and Responsive to Customer Demands.
• Ability to concentrate for long periods of time on diverse, complex analyses, with frequent interruptions.
• Advance Skills in Microsoft Office (such as Excel)
• Excellent numerical and analytical skills, with the ability to turn raw data into presentable reports and charts.
• Ability to prioritise varied and high volume workloads to tight deadlines, both for self and team members.
• Ability to apply common sense and logical thinking to problem solving.
• Able to identify and document Information needs for an Individual, Role or Service.
• Ability to translate non-technical requirements into technical solutions and to communicate complex analytics to others with little or no analytic background.
• Ability to deal diplomatically with all levels and disciplines of staff.

• Database & Warehouse Design
• Project & Programme Management
• Leadership & People Management
• Microsoft SharePoint
• Microsoft Project
• Experience of Forecasting

Disclosure and Barring Service Check

This post is subject to the Rehabilitation of Offenders Act (Exceptions Order) 1975 and as such it will be necessary for a submission for Disclosure to be made to the Disclosure and Barring Service (formerly known as CRB) to check for any previous criminal convictions.

Certificate of Sponsorship

Applications from job seekers who require current Skilled worker sponsorship to work in the UK are welcome and will be considered alongside all other applications. For further information visit the UK Visas and Immigration website.

From 6 April 2017, skilled worker applicants, applying for entry clearance into the UK, have had to present a criminal record certificate from each country they have resided continuously or cumulatively for 12 months or more in the past 10 years. Adult dependants (over 18 years old) are also subject to this requirement. Guidance can be found here Criminal records checks for overseas applicants.

Employer details

Employer name

The Walton Centre NHS Foundation Trust

Address

The Walton Centre

Liverpool

Merseyside

L9 7LJ

https://www.thewaltoncentre.nhs.uk/