Job description
An exciting opportunity for a Senior Information Analyst has arisen within the Information Services Team. You will need to have excellent knowledge of T-SQL, including experience of writing advanced SQL queries. You will also need to be an advanced user of Microsoft excel. Knowledge of SSRS, SSIS and Power BI would be beneficial.
The post holder will need to present complex data and analysis to non-information staff at all levels within the organisation and provide expert advice on the interpretation of this information. The position is primarily office based with the opportunity to work from home as appropriate
The post holder will provide expert advice regarding the effective and appropriate use of analytical tools, BI applications (Power BI) and
statistical methods.
Demonstrate experience and understanding of a breadth and depth of analytical methods and their application.
Support the development of corporate planning and performance reporting systems to ensure that the Trust delivers long and short-term plans and results.
Develop appropriate analytical solutions, analysing and reporting data in innovative and user friendly ways. Use analytical judgement in dealing with complex problems or missing data.
Be highly proficient in the use of T-SQL, SSRS, BI tools (Power BI) and advanced Excel.
See Job Description for Full details
We are committed to ensure a work-life balance to all our staff by offering full time and part time roles, flexible working hours on a shift pattern to fit around your family life.
We welcome and encourage applications from people of all backgrounds. We particularly encourage applications from disabled, Black, Asian and Minority Ethnic (BAME) and candidates form our local communities.
Benefits to you
- 27 days annual leave for new starters, rising to 29 days after five years of service and 33 days after 10 years of service, plus 8 Bank Holidays (pro-rata for part time staff);
- NHS Pension Scheme:
- Flexible working opportunities;
- Increased hourly rates for unsociable hours e.g. night shifts, weekends, bank holidays;
- Career development and training;
- Wellbeing support and activities;
- In-house physiotherapy Service;
- On-site canteens with subsidised meals;
- Subsidised staff parking (currently free).
- Free Stagecoach Bus Travel to and from work within Cambridgeshire and Peterborough
- Operations Delivery Support Team
- Divisional Triumvirates
- Divisional clinicians and wider teams
- Divisional Finance and HR Business Partners
- Contracts Team
- Digital Teams – Information governance and Information technology, Cost Improvement Programme Management Office
- Service Managers, Lead Nurses and ACDs
- Business Development Teams working in the Trust’s other service directorates
- Health Care teams and system partners external to the Trust
To provide complex analysis of data and performance related information to ensure it is readily available and in a presentable, usable manner to ensure achievement of national and local indicators. This will include development of BI (business intelligence) reports for Key Performance Indicators including access Targets, Cancer pathways, Diagnostic standards, efficiency and productivity metrics that include financial management and cost improvements.
The post holder will potentially handle and manage highly complex and sensitive information about staff, patients, work processes, other organisations, strategic objectives and barriers to change, and will ensure that communication about transformation or change projects is presented diplomatically, honestly and with political sensitivity so that working relationships are maintained and developed. Additionally the post holder may be required to present this highly complex, sensitive or contentious information to large stakeholder audiences.
Provide expert advice regarding the effective and appropriate use of business intelligence, analytical tools, statistical methods, databases and spread sheets and also how best to interpret and use information
To maintain up-to-date knowledge of the NHS Data Dictionary and Data Models including the varied and highly complex datasets in use within acute, community and primary care systems.
To develop and maintain a good understanding of the data, data structures and data relationships used within the Trusts’ databases and applications.
To maintain and develop clear, concise, and comprehensive documentation to support all regular and routine procedures and processes.
Deputising for the Information Manager when required
The job description and person specification are an outline of the tasks,
responsibilities and outcomes required of the role. The job holder will carry out any other duties as may reasonably be required by their line manager.
Overview of Main Responsibilities:
Business Intelligence
Perform interrogation and analysis on a range of data sets, using BI products as appropriate, in order to deliver insight and intelligence to partners within the Trust and .
To provide expert knowledge, business intelligence and data reports in conjunction with the wider Information Analyst team
Support the Transformation team to identify and provide information metrics that informs operational and programme management decision making.
Gather and analyse baseline data for forecasting purposes, to enable the Trust to be proactive rather than reactive.
Business Support
Act as subject matter expert in a range of NHS data sets as collected through different health care provider settings and to support the teams in developing their understanding and knowledge.
Develop and implement robust and standardised processes for development and maintenance of all reporting systems assigned to the team
To ensure that the team monitor the quality and completeness of data items used in reports and dashboards
To ensure all developed systems are documented and operational responsibilities are passed to the correct teams
Training and Staff Management
The post holder will be responsible for direct management of Information Analysts and Specialists to ensure work is allocated and progressed in a planned and timely way
The post holder will ensure that the analyst team gain expertise in the Trust BI tool and will also cascade skills and knowledge to the team, also ensuring that they keep their own development up to date and relevant. He/she will keep full and accurate records on developments and issues.
To manage, motivate and develop staff within the team to ensure that they are able to deliver the new responsibilities of the NHS. Including the management of disciplinary procedures as required, undertake staff consultation and consider welfare and safety matters, taking into account instructions and guidelines issued
To ensure the team complete all mandatory training
To ensure the team have a yearly MPA