Go back South Warwickshire University NHS Foundation Trust
Senior Power BI EPR Analyst
The closing date is 22 August 2025
South Warwickshire NHS Foundation Trust (SWFT) is an integrated acute and community Trust, and is looking for an outstanding individual to coordinate the implementation of Power BI within the department and wider Trust as part of the upcoming EPR project.
The successful post holder will possess excellent technical skills including Data Modelling, Data Transformation and DAX. The post holder will also be expected to train other staff members.
Your strong Power BI skills will mean you will lead the development, maintenance, continual improvement, and access control of automated Power BI dashboards and reports. The post holder will work closely with the Data Migration team to use Power BI and bespoke analysis to help support a successful DM process.
Main duties of the job
To coordinate the implementation of Power BI within the department and wider Trust, delivering business intelligence reports and dashboards that support organisational performance improvement. Use of Power BI as a tool to assist in highlighting and visualising changes in recorded data and trends during and post Oracle Millenium adoption. To provide expert technical leadership in Power BI development, maintenance, and training while ensuring compliance with all contractual and regulatory information sharing requirements.
About us
Come and join a Trust rated Outstanding by the CQC. South Warwickshire University NHS Foundation Trust have been rated as outstanding following our latest inspection by the CQC and we are recruiting new staff to come and help us improve even further. In addition our staff survey results have placed us 4th in the country for recommended place to work.
We provide services across Warwickshire and beyond ranging from Hospitals in Warwick, Stratford-Upon-Avon, Royal Leamington Spa and Shipston-on Stour to Community Services across the county. We are a progressive, expanding organisation with great ambition around improving quality, integrating pathways and delivering high levels of productivity.Our values can be summed up in one sentence. We are 'Trusted to provide safe, inclusive, effective and compassionate care'. Throughout the recruitment process you will be asked to think about how you demonstrate these values and how they impact on your work. It doesn't matter what role you do, whether it is patient facing or not, we are all working in the same way with our values at the core.
As part of our commitment to Equality, Diversity and Inclusion we encourage all applicants to complete a short survey. This can be accessed via the link below:
https://forms.office.com/e/ahWY3eAGM2
We appreciate you completing the survey.
Job responsibilities
Coordinate the implementation of Power BI within the department and wider Trust
Develop a comprehensive plan for embedding Power BI within the Information Team
Promote the use of Power BI as the default platform of choice for deployment of new reports
Lead the development, maintenance, continual improvement, and access control of automated Power BI dashboards and reports
Business Intelligence Reporting:
Deliver the business intelligence reporting schedule and ad-hoc reports ensuring Trust compliance with all contractual and regulatory information sharing requirements
Produce complex reports for internal Divisions, external commissioners and National Bodies
Undertake follow-up queries to highly complex information requests where solutions are not immediately obvious
Generate statistical analysis and profiles of trends within patient and Trust performance information
Electronic Patient Record Implementation
Take a role to assist in the progression of related EPR BI workstream project tasks. The post holder will lead on the design and delivery of intuitive, effective dashboards that support strategic, operational, and clinical decision-making across the organisation, as well as ensuring that essential organisational and external reporting is properly accounted for as part of the EPR Programme.
Work with the Data Migration team to use Power BI and bespoke analysis to help support a successful DM process.
Technical Excellence & Development:
Maintain expert knowledge of Microsoft Power BI, SQL Server, SSRS, and SSIS in complex organizational environments
Apply NHS Data Dictionary standards to Trust data and ensure compliance with Data Quality Standards
Proactively explore development of new dashboards and reports using SQL and PowerBI
Further develop Trust reporting tools to accommodate new data flows, enhance current flows, and assist in data migration projects
Training & Knowledge Sharing:
Provide Power BI support and training for members of the Information Team
Enhance skills of internal clients enabling them to extract their own reports
Proactively share knowledge of reporting, database and querying techniques, data standards and changes with team members
Interpret data requirements from non-technical staff into technical specifications
Stakeholder Engagement:
Represent the Information Department at meetings advising Divisions and Corporate functions on technical reporting matters
Provide in-depth expertise, interpretation and advice to support Division performance improvement
Communicate Business Intelligence issues to wide range of internal and external staff, providing expert advice to influence decision making
Systems & Infrastructure:
Be familiar with team's software and hardware requirements and advise Head of Information on deficiencies that impede productivity
Support automation of data submissions through Microsoft Power BI software solution
Work within wider Information Team to effect improvements in data quality where necessary
Person Specification
Qualifications
* Degree qualification or equivalent knowledge and experience in a numerate discipline
* Additional specialist knowledge acquired through post graduate diploma level or equivalent relevant experience
* Evidence of continuing professional development
* Management/supervisory qualification or equivalent experience
Experience
* Extensive, advanced experience of Microsoft SQL Server in a complex organisation, including SSRS design/implementation and SSIS data conversion/transformation
* Experience generating reports using webbased reporting services (Microsoft SQL Reporting Services and Microsoft PowerBI)
* Experience of leading on design, development and evaluation of new reporting requirements
* Experience of working with clinical information systems
Skills
* Advanced knowledge of Microsoft Power BI
* databases, especially MS-SQL Server including database design, maintenance, indexes and stored procedures
* Knowledge of SQL Server DML and DDL
* Strong leadership skills with ability to lead and develop team and provide guidance
* Ability to analyse complex technical issues and translate them into workable system solutions
* Ability to manage delivery of projects involving staff from own and other areas, ensuring deadlines and quality standards are met
* Analytical, methodical, innovative, and self-motivated approach
* Ability to liaise with and present information to staff at varying levels including senior management
* Can communicate complex technical information to non-IT staff within meetings and peer groups
* Able to prioritise effectively, work to deadlines and work under pressure
* Excellent written and presentation skills
* Proven analytical and problem solving skills
* Excellent data analysis and interpretation skills, used to inform decision-making processes
* Numerical skills with high attention to detail and ability to produce information to consistently high standard
* Prioritisation skills with ability to manage multiple strands of work
* Ability to work to deadlines in complex and pressured environment
* Plan and organise tasks and activities within team
* Knowledge of NHS information systems, Data Dictionary, Clinical Coding and HRG standards
* Understanding of NHS strategy and policy agendas
* Understanding of local NHS structure, strategy, vision and policy
Personal Qualities
* delivering ad-hoc/project deadlines, balance competing priorities and meet personal and service targets within fluctuating and demanding workload
* Patient, calm and tactful when dealing with people unfamiliar with Information or undergoing change processes
* Adaptable, flexible and innovative approach to work
* Logical and systematic approach to work, with ability to work accurately to strict deadlines
* Proactive approach
Other
* Prolonged concentration for accurate statistical analyses; working on computer for most of day
* Ability to maintain and analyse highly complex patient related activity and information through appropriate database and reporting tools
* High level of experience and skilled use of IT systems and equipment with highly developed keyboard skills
* Ability to deliver complex analytical documents to short deadlines
* Office-based as required with ability to attend meetings across Trust geography
* Ability to work from home for extended periods
* Support and cover other analysts as and when required
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.
South Warwickshire University NHS Foundation Trust
#J-18808-Ljbffr