Intelligence Analyst

Job description

Job responsibilities

JOB PURPOSE

• To assist & support the Dorset Intelligence and Insight Service (DiiS) Functions, including data warehousing to ensure the service meets the required standards.
• Ensure the regular production and development of quality intelligence reports and analysis that provide timely, responsive, and accurate business intelligence against key objectives and priorities across the range of core Business Intelligence functions.
• Support the Dorset NHS Integrated Care System (ICS) to enable effective decision making and provide support to programs on business intelligence related matters by the production of a suite of products and intelligence.
• To support the delivery of information and business intelligence commissioning support services to effectively support the Transformational agendas of the ICS, including Elective Care recovery, Urgent Emergency Care, Patient Pathways/services, Primary and Community Care etc.
• To provide Business Intelligence to support the ICS in improving outcomes for the population by utilising and combining multiple information sources, supporting population health management and address health inequalities.

POST SPECIFIC, TASKS AND OBJECTIVES

Personal objectives & principles

• Work corporately, flexibly, and proactively to effectively support the business intelligence functions and provide a positive front for the Dorset Intelligence and Insights Service.
• Work with the Deputy Heads, BI Partners, and other DiiS staff to foster good working relationships and develop a coordinated supportive approach to working across the Business Intelligence Services team, and beyond where appropriate.
• Promote and demonstrate continual professional development and knowledge of local and national data standards and policies including the legal requirements of Information Governance, Data Protection and Freedom of Information.
• Provide a positive front for the DiiS and work flexibly to support the work of the ICS most effectively.
• Demonstrate continual learning and development of technical skills & knowledge to identify and realise efficiencies within all aspects of the teams duties to increase the capacity and capabilities of the BI service.
• Assist and promote the development of a culture of intelligence use within the ICS by appropriately communicating all aspects of the teams functions.

Business Intelligence

• To provide analytical support services across all functions of the ICS and support colleagues with interpretation of data and intelligence to support monitoring of primary, community and secondary care contracts and services.
• To support the cross-provider working to feed into the DiiS and promote a culture of good data quality/consistency in across the Dorset ICS.
• Provide intelligence for budget management and financial planning by analysis of provider datasets including the modelling of future demand. Query and analyse provider data to identify coding and counting errors and resolve these with providers/other commissioners using established contractual processes. Ensure provider datasets meets national definitions and standards where appropriate.
• Provide effective business intelligence to support the CCG/ICS and wider health and care system to enable effective delivery of services to all Dorset patients by:

o Supporting patient pathway redesign & reconfiguration of services

o Specific function analytical support (e.g., Urgent Care, Elective Care, Primary and Community Care, and Mental Health).

o National benchmarking innovation and programmes.

• Work closely with key colleagues within the team and wider to ensure an integrated approach to provider data flows and provision of analytics.
• Assist in the development of acute provider contracts by applying and interpreting the national payment guidance.
• Be a part of a dedicated BI resource enabling effective support on business intelligence-related matters by developing a suite of products and intelligence to support:

o Commissioning decision making

o Population Health Management

o Reducing variation and inequality

o Improving patient care and quality of service (e.g., COPD, AF)

• Support the development primary care commissioning intelligence by assisting with the development of efficient mechanisms of data collection and warehousing of primary care data.

Data Management

• Support the develop intelligence by ensuring efficient mechanisms of collection, processing, and warehousing of a variety of data.
• Interrogate and support the development of the DiiS SQL data warehouse to provide effective and efficient production of BI products.

o SQL queries

o Alternative data sources and ETL processes

• Develop effective and efficient business intelligence products and promote increased and appropriate access via a variety of visualisation tools including.

o Power BI

o GIS Mapping

• Utilise local/national data for analysis ensuring compliance with the latest Information Governance and Data Protection regulations.
• Demonstrate excellent analytical skills combining the ability to manipulate, interrogate and understand complex datasets with the effective use of advanced problem-solving skills to resolve complicated problems and embed good data quality principles into all aspects of your work.
• Increase and develop the teams intelligence by utilising, interpreting and collating information from national, regional, and local information resources across function, directorate and organisational boundaries including Public Health intelligence.
• Provide analytical support services across the ICS to support colleagues with interpretation of data and intelligence.

Engagement & Communications

• Support the development and maintenance of a customer facing Business Intelligence resource accessible across the Integrated Care System (ICS) enabling ease of access to all intelligence products and training materials. Assisting in the development of innovative communication and training methods to improve stakeholder access and understanding to all BI services and products.

o Online Training e.g., webinars, website development.

o Recorded video tutorials.

o Interactive online reports.

o Presenting to non-BI audiences.

o Innovative marketing and communication techniques.

For further information, please see full Job Description attached.

Person Specification

Qualifications

Essential

• Relevant numerical qualification and/or training.
• Evidence of continuing professional development that enhances theoretical and practical skills/knowledge.

Skills, Abilities and Knowledge

Essential

• Knowledge of NHS datasets, flows and information management/ benchmarking tools.
• Knowledge of Primary Care operational system
• Excellent analytical skills combining the ability to manipulate interrogate and understand complex datasets.
• Excellent written & verbal communication skills.
• Excellent knowledge of data quality issues and the approaches taken to improve quality.
• Proficient user of Microsoft Office and Office 365 applications including Power BI
• Working knowledge of data warehousing including SQL Server Management Studio and SSIS
• Understanding of Business Intelligence applications and processes
• Ability to present complex information to a wide range of audiences both verbally and electronically.
• Ability to travel throughout Dorset and surrounding areas.
• Demonstrable ability to prioritise effectively and excellent organisational skills.
• Demonstrable ability to use own initiative within sphere of responsibility to achieve positive results.
• Demonstrable experience of problem solving and developing creative solutions
• Ability to work without supervision and to tight deadlines.
• Ability to work well under pressure.
• Evidence of continual professional development

Experience

Essential

• Recent previous experience within a comparable role
• Recent previous experience of working within a customer focused environment.
• Experience of working in an information analysis environment and in producing management information.
• Experience and knowledge of working with NHS data.
• Expert in interpreting and communicating complex information to all levels of an organisation.
• Experience and knowledge of working with confidential information.
• Experienced in the use of Business Intelligence Systems such as SQL.
• Experience in Business Intelligence Tools Specifically Power BI.

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.

Employer details

Employer name

NHS Dorset

Address

Vespasian House

Barrack Road

Dorchester

Dorset

DT1 1TG

Employer's website

https://nhsdorset.nhs.uk/ (Opens in a new tab)