Job overview
• Demonstrate expert application of advanced analytical and technical skills to interpret complex healthcare data, identifying trends, risks and opportunities to support operational and strategic decision-making across the Trust.
• Lead the design, development and optimisation of dashboards and reports using Microsoft Power BI to deliver accurate and quality-assured reporting.
• Automate reporting processes, reducing manual workload, improving data quality and increasing efficiency
• Experience in data interrogation and data linking, being able to analyse large, complex data sets from multiple clinical systems and data warehouse to produce accurate and robust reports
• Act as a highly motivated and self-directed professional, combining excellent communication, analytical and leadership skills to influence decision-making and support service improvement initiatives.
This role requires advanced expertise in the development and maintenance of reports and dashboards using Microsoft Power BI, with the ability to translate and present complex analytical information in a clear, accessible and actionable format for a wide range of shareholders. The post holder must demonstrate advanced T-SQL proficiency, including querying, joining, aggregating and optimising large, relational data tables, as well as designing and developing robust ad hoc datasets to support operational and strategic reporting requirements.
Main duties of the job
·Responsible for developing, supporting and maintaining the extraction of data from Trust Clinical Systems and Data Warehouse
·Being able to work on a number of different projects simultaneously and independently that will vary in scale and complexity and take all necessary decisions to see projects through to a highly satisfactory conclusion
·Provide and receive highly complex, sensitive or contentious information and be able to present them using advanced analytical skills in such a way that shareholders without an informatics background can understand.
·Have the ability to influence people with different perspectives to get the most out of shareholders relationships.
·Lead the continuous development of various analytical methods, ensuring consistency and best practice across the team.
·Provide expert advice to the team, department and wide-Trust colleagues.
·Proactively identify data issues and working collaboratively with other teams to implement sustainable improvements.
·Deputise for the Analytics Engineering Manager as required, representing the team at senior meetings with internal and external shareholders.
·Support the Analytics Engineering team through mentoring, training and promoting a culture of continuous professional development.
Working for our organisation
Bedfordshire Hospitals NHS Foundation Trust provides hospital services to a growing population of around 700,000 people living across Bedfordshire and the surrounding areas across two busy hospital sites in Bedford and Luton. Both hospital sites offer key services such as A&E, Obstetrics-led Maternity and Paediatrics. You will be joining a friendly, high performing Trust committed to ensuring the health and wellbeing of staff. As one of the largest NHS Trusts in our region you will have access to a programme of high quality training and development to help you grow your career. The Trust continues to be committed to delivering the best patient care using the best clinical knowledge and technology.
Our Values
We not only recruit based on qualifications and experience - we recruit individuals who demonstrate the behaviours which underpin our Trusts core values. We achieve this by using values based recruitment. We are dedicated to making our recruitment practices as inclusive as possible for everyone, we are committed to promoting equality and diversity, and creating a culture that values differences.
Please note that vacancies may close prior to the advertised closing date when sufficient number of applications have been received. All new staff will be subject to a probationary period covering first 6 months in post. Travel between hospital sites may be required. Please review all documents attached to ensure you familiarize yourself with all requirements of the job.
Detailed job description and main responsibilities
Staff Management, Support and Development
1. Support the Analytics Engineering Manager in mentoring, coaching and developing junior staff, developing technical skills in areas including T-SQL and Microsoft Power BI.
2. Provide expertise and guidance across the Information Department, acting as a senior point of contact for complex analytical queries.
3. Lead on project and assignments, monitoring progress and ensuring delivery to agreed deadlines and quality standards.
4. Ensure adherence to internal SOPs and documentation to maintain consistency, governance and auditability across the Analytics Engineering team.
5. Promote equality, diversity, and inclusion in line with Trust values. Foster a supportive, fair, and open culture that encourages innovation, continuous improvement, and professional development.
6. Act as a role model for professionalism, integrity and technical excellence within the team.
Financial Management
7. Ensure Trust resources are used appropriately and effectively
Analysis and Judgement
·Analyse and translate highly complex datasets to identify trends and risks, providing expert interpretation to inform shareholders using automated reports or dashboards.
·Lead in Trust-wide projects, often managing multiple jobs simultaneously across different data systems.
·Show own initiative to tight deadlines where there are often conflicting requirements and requests for support from various shareholders.
·Exercise independent judgement when interpreting data, determine appropriate methodologies, assumptions and analytical approaches.
·Have a keen eye for quality assurance and be able to perform rigorous testing on both your own scripts and the scripts of others.
·Assess data quality issues, investigate and identify corrective actions to ensure reports and dashboards display accurate, validated and reliable information.
·Develop reporting processes to support both internal and external Data Assurance and Information Governance requirements.
·Lead the design and implementation of new and improved analysis and reporting streams.
Leadership
·Represent Analytics Engineering team at internal and external meetings independently, being able to take actions without the supervision of senior staff.
·Facilitate or chair meetings with shareholders and act as a senior representative for the Analytics Engineering Team, ensuring decisions are taken in the Trust’s best interests.
·Demonstrate autonomy and initiative, making decisions and judgements related to each assignment or project proactively.
·Make autonomous decisions regarding prioritisation of workload balancing demands and organisational pressures.
·Manage own workload, making informed decisions in the absence of required information, working to tight and often changing timescale ensuring work is completed to a high standard within given deadlines and delays are fully communicated.
·The post holder will have to plan, document and prioritise their own work in a proactive manner.
·To cover work, as directed by the Analytics Engineering Manager for other members of the team in periods of reduced capacity - i.e. Annual leave/Sickness - as appropriate to the grade.
Communication and Relationships (Internal/External)
·Develop and maintain effective relationships with colleagues across Performance & Information, Digital Services and operational teams, as well as external shareholders, suppliers, and partners.
·Represent the Analytics Engineering team by maintaining strong networks, contributing to meetings and providing advice, guidance, and leadership that supports delivery of the team objectives.
·Present complex analytical findings to senior clinical and managerial audiences in a clear, concise and accessible manner, adapting communication style to suit the audience.
·Communicate technical concepts, data limitations and project risks effectively to non-technical shareholders to support informed decision-making.
·Contribute to multidisciplinary project groups, representing the Analytics Engineering team and ensuring analytical considerations are incorporated into service developments.
·Foster a culture of openness, professionalism and collaborative working within the team and across the wider Trust.
Governance and Data Assurance
·Contribute to working collaboratively with colleagues to ensure that effective governance arrangements and performance management systems are in place.
·Contribute to working collaboratively with colleagues to address complaints and incidents appropriately – lead the learning from such events to ensure that learning is achieved across the department.
·Lead the development, maintenance and governance of comprehensive test and validation plans for reports, dashboards and data extracts, ensuring outputs are robust, quality assured, fully auditable and aligned to organisational and national standards at implementation and through ongoing review.
·Take overall responsibility for monitoring data outputs for accuracy, consistency and integrity, proactively identifying anomalies, leading investigations into root causes and implementing corrective actions in collaboration with relevant stakeholders.
·Ensure all work complies with Information Governance requirements, Data Protection legislation and Trust policies, including when working remotely.
·Follow Trust Health & Safety policies and safe remote working practices as applicable.
Personal/Professional Development
·Develop an understanding of organisational pathways, goals, and constraints, keeping up to date with national and local reporting requirements to assist with data needs.
·Take responsibility for own professional development through agreed action plans with the line manager and by fostering a culture of life-long learning and skills development.
·Develop and implement changes to the Information provision in order to meet national guidelines and the needs of the Trust.
·Support the implementation of computer system applications within the Trust where these have a bearing on information provision.
·Responsible for redeveloping and improving current processes to ensure maximum income, data quality and reducing timescales for data production.
·Keep abreast of national and local reporting requirements and ensure necessary changes in reports management fit the needs of the business.
·Support the strategic planning and business development of the Trust.
·Participate in mandatory training and actively engage in learning opportunities to maintain and develop professional competence.
·Keep up to date with new developments which affect the system’s design and application development appropriate to the Trust, including researching and evaluating new technologies.
Person specification
Qualifications
Essential criteria
8. Educated to degree level or equivalent experience
9. Expert in T-SQL and scripting language - training and experience
10. Expert in Microsoft Power BI including advanced dashboard development - training and experience
Desirable criteria
11. Further relevant technical or professional training.
Experience
Essential criteria
12. Proven track record of working within an Informatics environment within the NHS
13. Significant experience developing, configuring and maintaining highly complex databases and manipulating large, multi-source datasets from clinical systems and data warehouse.
14. Extensive experience in advanced T-SQL development, including writing, optimising and troubleshooting complex queries across large datasets.
15. Experience developing and maintaining automated reporting solutions (including Visual Studio or equivalent tools) and interactive dashboards using Microsoft Power BI, including complex DAX calculations.
16. Experience in system testing, quality assurance, validation and structured problem-solving.
17. Experience leading analytical input into complex projects, managing multiple projects simultaneously and independently.
18. Experience presenting complex, sensitive or contentious information to senior clinical and managerial shareholders.
19. Experience identifying data quality issues and implementing sustainable data assurance improvements.
20. Experience mentoring or supporting junior staff and contributing to team development.
Desirable criteria
21. Experience of Line Management
22. Experience within an NHS Acute Trust
Knowledge, Skills & Abilities
Essential criteria
23. Developed specialist knowledge of data collection and analysis to design and develop reports
24. Extensive working knowledge of Microsoft SQL Server Management Studio
25. Extensive working knowledge of Microsoft Office package - particularly Word, Access and Excel
26. In depth knowledge in developing and maintaining automated reports using Visual Studio
27. Extensive experience in developing and maintaining dashboards using Microsoft Power BI and DAX
28. Knowledge and understanding of NHS Data Dictionary and Trust clinical systems with the ability in interpreting national guidance
29. Strong understanding of governance, risk management, data protection and confidentiality requirements.
30. Lead project
31. bility to balance competing organisational priorities and make autonomous decisions regarding workload and delivery.
32. Strong quality assurance capability, including rigorous testing, validation and documentation of analytical outputs.
Desirable criteria
33. Knowledge of Python
34. NHS IT Systems
Personal Skills
Essential criteria
35. Highly developed written and verbal communication skills, with the ability to translate complex technical information into clear, accessible and actionable insight for non-technical audiences.
36. Strong communication skills both written and verbal – able to provide and receive highly complex, sensitive information and use persuasion, influencing and negotiation with individuals and shareholders
37. Self-motivated, proactive, multitasking and able to work autonomously on various projects within agreed governance frameworks.
38. Ability to lead and drive change, including supporting the implementation and roll-out of new functionality and technologies.
39. Experience representing Analytics Engineering Team at meetings with knowledge and professional authority.
40. Able to work flexibly to meet the demands of the role but still maintain a high degree of accuracy.
41. Demonstrates professional leadership and acts as a role model for technical excellence, integrity and high performance.
42. Flexible and adaptable in response to changing organisational and national priorities.
43. Committed to fostering a culture of continuous improvement, innovation and knowledge sharing