Job summary
This is open to new applicants only. Previous applicants need not apply.
As Senior BI Developer, you will develop, analyse and interpret business and performance information to ensure the accurate and timely production of reports and dashboards, primarily using Power BI and SSRS.
The role will also be to develop, implement and maintain systems to ensure the efficient andeffective collection of all performance management data and wider business intelligence.
You will be responsible for delivering the build of data tables and identify and address thecontinued development and maintenance of the Data Warehouse, with a focus on databaseadministration, performance tuning, optimisation, source control and the recording of technicaldocumentation.
Main duties of the job
- 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 investigative 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.
About us
The Walton Centre NHS Foundation Trust is the only NHS trust to hold dual accreditation for the Investors in People. We invest in people and we invest in wellbeing standards and have been awarded Gold status for both. The Walton Centre is a leader in the treatment and care of neurology and neurosurgery, placing the patient and their family at the heart of everything we do. As the only specialist hospital trust in the UK dedicated to providing comprehensive neurology, neurosurgery, spinal and pain management services we are proud to be rated as an Outstanding Trust by the Care Quality Commission (CQC), and champion change throughout the field of neuroscience. Originally formed in 1992, the Trust received Foundation Trust status in 2009.
With around 1,450 staff, The Walton Centre treats more than 127,000 outpatients and 18,000 inpatients each year. We have leading specialists and incredibly dedicated staff delivering excellent clinical outcomes for brain, spinal and neurological care nationally and internationally. Teams across our site in Fazakerley, Liverpool, offer a world-class service in diagnosing and treating injuries and illnesses affecting the brain, spine and peripheral nerves and muscles, and in supporting people suffering from a wide range of long-term neurological conditions.
Job description
Job responsibilities
Please see the job description and person specification document for detailed information about the job description for this vacancy
Job description
Job responsibilities
Please see the job description and person specification document for detailed information about the job description for this vacancy
Person Specification
Qualifications
Essential
- Masters degree or relevant training or experience in information/SQL development/business intelligence field.
- Evidence of professional development.
- IT Qualification.
Desirable
- Working towards a Post-Graduate Degree in a relevant subject.
- Project Management qualification (such as Prince2)
- Microsoft SQL Certification.
Knowleghe and Experience
Essential
- Minimum of 3 years' experience writing SQL.
- Experience of 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 dealing 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.
Desirable
- Experience of SQL Server Analysis Services.
- Experience of SQL Server Integration Services.
- Experience of Designing and Building Relational Databases / Data Warehouses.
- Experience of using agile 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.
Skills& Attributes
Essential
- Advanced use of Microsoft T-SQL.
- Excellent analytical and numerical 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 focused 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
- Advanced 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.
- Ability 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.
Desirable
- Database and Warehouse Design
- Project and Programme management
- Leadership and People Management
- Microsoft SharePoint.
- Experience of Forecasting.
- Microsoft Power Automate and Power Apps.
Other
Essential
- Motivation and a willingness to learn.
- Drive for personal and team development
- Willing to adopt a flexible approach to working hours
- Challenging and inquring mindset combined with an aptitude for working within a changing environment
- Attend relevant and local regional events
Desirable
- Member of Informatics Professional body such as AphA
Person Specification
Qualifications
Essential
- Masters degree or relevant training or experience in information/SQL development/business intelligence field.
- Evidence of professional development.
- IT Qualification.
Desirable
- Working towards a Post-Graduate Degree in a relevant subject.
- Project Management qualification (such as Prince2)
- Microsoft SQL Certification.
Knowleghe and Experience
Essential
- Minimum of 3 years' experience writing SQL.
- Experience of 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 dealing 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.
Desirable
- Experience of SQL Server Analysis Services.
- Experience of SQL Server Integration Services.
- Experience of Designing and Building Relational Databases / Data Warehouses.
- Experience of using agile 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.
Skills& Attributes
Essential
- Advanced use of Microsoft T-SQL.
- Excellent analytical and numerical 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 focused 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
- Advanced 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.
- Ability 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.
Desirable
- Database and Warehouse Design
- Project and Programme management
- Leadership and People Management
- Microsoft SharePoint.
- Experience of Forecasting.
- Microsoft Power Automate and Power Apps.
Other
Essential
- Motivation and a willingness to learn.
- Drive for personal and team development
- Willing to adopt a flexible approach to working hours
- Challenging and inquring mindset combined with an aptitude for working within a changing environment
- Attend relevant and local regional events
Desirable
- Member of Informatics Professional body such as AphA
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.
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 (Opens in a new tab).
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 (Opens in a new tab).
Additional information
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.
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 (Opens in a new tab).
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 (Opens in a new tab).
