Senior BI Developer

Are you looking for an interesting career in BI in the NHS?

Are you looking to develop your skills and knowledge?

Do you want to help to improve the health care we provide? The health care that you, your family, and friends may need one day.

Are you enthusiastic, with great attention to detail and accuracy?

If you have answered yes to the above questions, we may have the opportunity you are looking for.

We are offering a Senior BI Developer position to join our Information and BI team. As part of this role, you will Support the Head of Information and BI in the delivery of the Performance Management reporting using skills in relational databases, SQL Server, and Business Intelligence (BI). You will develop, 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. You will also be responsible for delivering the build of data tables and identify and address the continued development and maintenance of the Data Warehouse.

27 days annual leave, plus bank holidays - rising to 33 days (depending on the trust).

Equality, Diversity and Inclusion networks.

Blue Light Card, NHS discounts.

Access to Learning and Development, including funded training.

Sustainability.

Main duties of the job

To develop dashboards and reports using Business Intelligence tools, such as Power BI and 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.

About us

The Walton CentreNHS Foundation Trust is the only NHS trust to hold dual accreditation for theInvestors in People we invest in people and we invest in wellbeingstandards and has been awarded Gold status for both. TheWalton Centre is a leader in the treatment and care of neurology andneurosurgery, placing the patient and their family at the heart of everythingwe do. As the only specialist hospital trust in the UK dedicated to providingcomprehensive neurology, neurosurgery, spinal and pain management services weare proud to be rated as an Outstanding Trust by the Care Quality Commission(CQC), and champion change throughout the field of neuroscience. Originallyformed in 1992, the Trust received Foundation Trust status in 2009.

Witharound 1,450 staff, The Walton Centre treats more than 127,000 outpatients and18,000 inpatients each year. We have leading specialists and incrediblydedicated staff delivering excellent clinical outcomes for brain, spinal andneurological care nationally and internationally. Teams across our site inFazakerley, Liverpool, offer a world-class service in diagnosing and treatinginjuries and illnesses affecting the brain, spine and peripheral nerves andmuscles, and in supporting people suffering from a wide range of long-termneurological conditions.

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

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
• 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
• 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
• 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.

#J-18808-Ljbffr

---