Senior Power BI EPR Analyst

Job responsibilities

Power BI Leadership & Implementation:

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

Qualifications

Essential

• Degree qualification or equivalent knowledge and experience in a numerate discipline
• Additional specialist knowledge acquired through post graduate diploma level or equivalent relevant experience

Desirable

• Evidence of continuing professional development
• Management/supervisory qualification or equivalent experience

Experience

Essential

• 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

Desirable

• Experience of working with clinical information systems

Skills

Essential

• 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

Desirable

• 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

Essential

• 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

Essential

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

Certificate of Sponsorship

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