Business Intelligence Analyst

Job responsibilities

Please refer to the attached Job Description for full duties of the role

Business Intelligence (BI) and big data analytics is pivotal to the delivery of high-quality efficient healthcare provision and organisational performance. The Business Intelligence Team provides information, analysis, applied analytical intelligence and insights to support the Trust including facilitating effective decision making, best use of resources, understanding performance, and providing information required to focus on areas of greatest opportunity for improvement.

The post holder is accountable to one of the Business Intelligence Team Managers and is responsible for providing a high-quality Business Intelligence service to specific aligned Divisional/Directorate teams to inform the decision-making ability of relevant clinicians, staff and managers at all levels of the organisation (from ward to board) and improve services and patient care.

The post holder is responsible for ensuring the relevant Divisions and Directorates have sufficient information to robustly monitor achievement of the agreed national, regional and local performance standards as well as providing statistical and predictive analytics to support delivery of the Trust strategies and decision making.

The post holder will provide a high standard of corporate information, analysis and intelligence to facilitate proactive management and improvement of performance and quality, as well as supporting business planning across the respective Division(s).

The Business Intelligence Analyst will be expected to make a positive contribution to the delivery of the Directorate agenda, to support the strategic vision of the Trust.

To comply with the Trusts vision, values and behavioural compact.

Qualifications

Essential

• Educated to at least degree level or Health Informatics Qualification equivalent to level 6 (or significant and demonstrable experience in a Business Intelligence, Performance or Information Management setting).
• Evidence of continued professional development.

Desirable

• Level 6 qualification or above in relevant discipline.
• Project/Programme management qualification.
• Relationship management/ customer service training.
• Management or leadership qualification.
• Service improvement certification/training.
• Microsoft SQL/SSRS certification/training.
• Microsoft Power BI certification.
• Microsoft Excel certification.

Experience

Essential

• Significant experience working within a data orientated environment/team.
• Worked with big data and employ data interrogation, transformation and visualisation techniques using relevant software, such as Power BI.
• Advanced data analysis experience including statistical analysis techniques.
• Reported organisational performance/information/BI, compliant with guidance and reporting specifications.
• Reverse-engineered existing analyses and replicate the method and results.
• Worked as part of a multidisciplinary team.
• Worked in partnership with key stakeholders to achieve goals and objectives.
• Applied understanding of Information Governance and Data Security principles.

Desirable

• NHS analytical experience.
• Awareness of the current NHS environment and its key policies, including the NHS Oversight Framework and NHS Planning Guidance.
• Experience of working with an operational area in a provider Trust.
• Experience of working with Senior Managers and organisational leaders.
• Understanding of NHS datasets and NHS data dictionary.
• Experience of clinical patient administration systems.
• Knowledge of Lean/Service improvement tools and techniques.
• Experience of developing reports using SQL and SSRS.
• Experience of developing reports and analysing data using Power BI.
• Experience of performance measurement regimes.
• Line management, supervisory or mentoring experience.

Physical Skills

Essential

• Possess a good knowledge of relevant tools, applications and systems used in your organisation and able to determine which tools and techniques to use to explore or solve business issues.
• Ability to adopt the most appropriate tool for the tasks.
• Ability to maintain a high standard of work.
• Ability to engage with your team and the wider analytical community to learn about new tools and techniques.
• Possess good knowledge of predictive, prescriptive and evaluative analytical techniques and explicative statistics, and the application of statistical practices.

Skills and Knowledge

Essential

• Ability to import data into underlying data models, understand the relational structure and use appropriate visualisation method.
• Ability to employ a number of problem-solving techniques to identify the reason for unexpected problems within the data and utilise a range of skills to solve these.
• Ability to apply a range of techniques to transform data into valid and purposeful information using appropriate technology/tools.
• Ability to use appropriate information to analyse a range of common types of problem.
• Ability to apply a range of techniques to analyse data and provide insight.
• Ability to work with requestors to examine the underlying question and apply knowledge to generate an approach to the visualisation/analysis, look beyond initial requirements, challenge assumptions and generate insight.
• Ability to participate in discussions determining which performance measures are appropriate and turn business needs and goals into performance measures.
• Understanding of how to structure a reasoned argument to influence the decisions of others, negotiate simple exchanges to achieve a specific result and appeal to those in authority to facilitate influence.
• Sound knowledge and understanding of underlying code such as SQL, Power Query M formula language, DAX etc and the application to create reports/analysis using the likes of SSRS and Power BI.
• Understand how geographical data can be displayed to show geographical features such as simple choropleth.
• Understand XmR charts and knowledge of the other types of SPC charts for different data types.
• Understand the role of descriptive analytics and the difference between this and inferential / predictive analysis.
• Ability to use key techniques in predictive analytics and select the appropriate technique for the subject.
• Knowledge of the key data protection principles.
• Understand timeliness of data and the need for data to flow with minimal interaction. Identify where automation would improve processes.
• Ability to gather requirements and identify the "to be" state of processes.
• Ability to work collaboratively and foster positive relationships with others and initiate work with others in your team to bring about a generally agreed outcome.
• Understand how interpersonal skills such as kindness and compassion can increase peoples desire to support you.
• Advanced Microsoft Office skills including MS Word and Excel, along with a high level of experience of other Microsoft Office applications.
• Ability to work on own initiative and respond to and manage competing pressures and deadlines.
• Highly organised and structured approach, with the ability to maintain documentation like action plans to ensure timely delivery of objectives.

Desirable

• Power BI and SSRS report development.
• Awareness of the national NHS Strategy and Policies.
• Knowledge of contracting processes.
• Data extraction, transformation and load principles and the implications for downstream report development.
• Skills relating to process automation such as Microsoft Power automate.
• Knowledge of performance improvement techniques and methodologies.
• Understand the difference between predictive and prescriptive analysis and have knowledge of tools and techniques for prescriptive analysis including business modelling and algorithms. Aware of the link to machine learning.
• Understanding and application of reliability and validity assessments.
• Able to respond sensitively to organisational and political complexities.
• Ability to motivate staff and build collaborative relationships.