Data Developer

Are you looking for an interesting career in BI in the NHS?
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.
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.
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.
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.
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.
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 planning and delivering the B.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.
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.
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
To assist with adding content to and maintaining the online Business
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.Will be required to deliver projects to timescales and delivery change within 12months
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.
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
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 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
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.
Creation of Programme, Project and Work Plans
Working with Financial / Performance software
Willing to adopt a Flexible approach to working hours.
Attend relevant local and regional events.
Willing to undertake further training
Microsoft T-SQL (at an Advance level)
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.
Database & Warehouse Design
Microsoft SharePoint
Microsoft Project