Business Intelligence Developer

North Staffordshire Combined Healthcare NHS Trust; Stoke-on-Trent; On-site; GBP 45,000 - 65,000; Full time

Benefits offered by this job

Flexible working

Job Share welcomed

Job summary

North Staffordshire Combined Healthcare NHS Trust is seeking a Business Intelligence Developer to design, develop and support the Trust's BI platform, delivering accurate information for operational management and strategic planning.

You will work with the Performance Team using SQL Server, SSIS, Power BI and Report Builder to create data warehouses, dashboards and reports, promoting data quality, automation and self-service analytics across clinical and corporate services.

Qualifications

• Degree or equivalent with advanced MS SQL, SQL Server, SSRS, Power BI and MS Excel.
• Substantial experience developing ETL processes, Data Warehouses and SSRS reports with Microsoft BI technologies (SSIS, SSAS, SQL, SSRS, VS2013).
• Experience designing, coding, integrated dashboard scope, design and development.
• Experience analysing and presenting data/findings to varied audiences.
• Demonstrable experience of data transformation and loading of transformed data.
• Knowledge of Data Protection legislation, data protection and Protection Toolkit

Responsibilities

• Design, develop and maintain robust BI solutions using Microsoft technologies.
• Develop data warehouses, ETL processes, dimensional models, databases, reports and dashboards.
• Automate reporting processes and enable self-service reporting.
• Ensure data quality, governance and security across datasets.
• Collaborate with clinical, operational and corporate services to maximise BI value.
• Document developments and provide training and support where appropriate.

Skills

MS SQL

SQL Server

SSRS

Power BI

MS Excel

ETL development

Data modelling

SharePoint

Education

Degree or equivalent relevant experience to achieve advanced status in MS SQL/SSRS/Power BI

Postgraduate qualification

Tools

SSIS

SSAS

SQL Server Report Builder

Power BI Desktop

Job description

Detailed job description and main responsibilities

As a Business Intelligence Developer, you will play a key role in the development, enhancement and support of the Trust's Business Intelligence platform, helping to deliver high-quality information that supports operational management, strategic planning and improvements in patient care.

Working within the Performance Team, you will be responsible for designing, developing and maintaining robust Business Intelligence solutions using Microsoft technologies including SQL Server, SQL Server Integration Services (SSIS), Power BI and Microsoft Report Builder. You will develop data warehouses, ETL processes, dimensional data models, databases, reports and interactive dashboards that provide accurate, timely and accessible information to a wide range of users across the Trust.

You will work closely with Digital and Information colleagues to ensure that reporting solutions are built on reliable and up-to-date datasets, supporting the ongoing development of the Trust's data warehouse and Business Intelligence environment. You will identify opportunities to automate reporting processes, improve data quality and enable self-service reporting, ensuring that solutions are scalable, efficient and aligned with business priorities.

The role requires strong technical expertise in database development, SQL programming and Business Intelligence technologies, together with the ability to analyse complex information requirements and translate them into practical reporting solutions. You will contribute to the design, implementation and testing of new systems and enhancements, ensuring all developments are fully documented, appropriately secured and subject to rigorous quality assurance before release.

Working collaboratively with stakeholders across clinical, operational and corporate services, you will provide technical advice and support, helping users to maximise the value of Business Intelligence products. You will contribute to Trust-wide projects involving data integration, information systems and analytics, while maintaining technical documentation to support future development, maintenance and knowledge sharing.

You will ensure that all information products comply with information governance standards, data protection legislation and Trust policies, maintaining the highest standards of data security and confidentiality. You will also contribute to the continuous improvement of Business Intelligence services by keeping up to date with emerging technologies, promoting best practice and sharing knowledge with colleagues through training and support where appropriate.

The successful candidate will be an analytical and proactive problem solver with excellent communication skills, capable of managing a varied workload and working independently while building effective relationships with colleagues, system suppliers and other stakeholders across the organisation.

Person specification

Qualifications

Essential criteria

• Degree or equivalent relevant experience to achieve advanced status in the use of MS SQL, SQL Server, SSRS, Power BI, MS Excel.

Desirable criteria

• Post graduate qualification

Experience

Essential criteria

• Substantial experience, or equivalent, developing ETL processes, Data Warehouses, and SSRS reports with Microsoft BI technologies (SSIS, SSAS, SQL, SSRS, VS2013).
• Experience of designing, coding, integrated dashboard scope, design and development.
• Experience of analysing and presenting data/findings to varied audiences
• Demonstrable experience of data transformation and loading of transformed data.
• Knowledge of Data Protection legislation, data protection and protection toolkit

Desirable criteria

• Experience of working in the NHS.
• An understanding of Performance Management An understanding of CQC Compliance.
• Experience of project work and ownership responsibility.

Knowledge & Skills

Essential criteria

• A logical and analytical approach to problem solving demonstrated in an information systems environment.
• Development skills working with BI analytics tools, such as MS Power BI, SSRS, Qlikview, Tableau.
• Sound in depth knowledge of database design principles, Microsoft BI stack technologies is essential.
• Experienced in writing SQL.
• Management and development of an MS SharePoint environment.
• Testing and implementation of efficient and robust reports and database schemas.
• Demonstrable experience of data transformation and loading of transformed data.
• Knowledge of Data Protection legislation, Data Security and Protection Toolkit

Desirable criteria

• Familiarity with benchmarking & comparative analysis tools.
• Familiarity with R and Python

Other

Essential criteria

• Ability to meet the travel requirement for the post.

North Staffordshire Combined Healthcare NHS Trust is an equal opportunities employer and values diversity. We offer a variety of flexible working opportunities for both full and part time staff. Job Share applicants will be fully considered and applications are particularly welcomed from current and previous service users

All correspondence at each stage of the process (including any offer packs) will be sent to you via the email address you applied from, please ensure you check your emails regularly.

PLEASE NOTE THE FOLLOWING POINTS

• In the event of exceptionally high levels of response, we reserve the right to close the post before the date stated above in order to prevent the number of applications received being unmanageable. You are advised to submit your completed application form as soon as possible to have the best chance of being considered.

• Priority will be given to NHS staff across the region who are at risk of redundancy, where the vacancy is at the same band or one below their current band and candidates meet the essential criteria for this post.
• All employees new to the Trust will be subject to a 6 month probationary period.
• All clinical staff bands 2-4 that are new to the Trust will be required to complete a Care Certificate.

Canvassing of members of the Trust or of any Committee of the Trust directly or indirectly for any appointment under the Trust shall disqualify the candidate for such appointment. The Trust does not pay travel expenses for candidates attending interviews.

ALL POSTS INVOLVING ACCESS TO PERSONS IN RECEIPT OF HEALTH SERVICES WILL BE SUBJECT TO A DISCLOSURE & BARRING SERVICE DISCLOSURE.

Please provide full contact details for all referees, especially their email addresses where possible. Failure to do may result in significant delays in your application. There may also be a requirement to provide additional referee details.