Analytics Engineer

Mid Cheshire Hospitals NHS Foundation Trust; Crewe; On-site; GBP 45,000 - 55,000; Full time

Job summary

A prominent healthcare organization in the United Kingdom is seeking a Senior Analytics Engineer to enhance its data and analytics capabilities. You will lead initiatives for the Central Cheshire Integrated Care Partnership, designing and implementing dashboards and data reporting solutions using SQL Server and Power BI. The ideal candidate will possess strong leadership skills, a solid understanding of data governance, and proficiency in agile methodologies. This role is pivotal in improving data quality and decision-making processes across various teams.

Benefits

Flexible working arrangements

Professional development opportunities

Healthcare benefits

Qualifications

• Experience in leading data and analytics projects in a healthcare setting.
• Strong technical skills in SQL and data modeling techniques.
• Proficiency with Power BI including DAX and Power Query.

Responsibilities

• Lead the delivery of data and analytics for CCICP.
• Collaborate with teams to design and maintain high-quality dashboards.
• Ensure data quality and governance practices are followed.

Skills

Leadership

SQL Server

Power BI

Data Warehousing

Data Governance

Agile Delivery

Education

Relevant degree in Data Science or similar field

Tools

Microsoft Forms

Power Automate

Python

R

Job description

We are looking for a highly motivated and technically skilled Senior Analytics Engineer to join our Information Services department at Mid Cheshire Hospitals NHS Foundation Trust. This is an exciting opportunity to take the lead for Central Cheshire Integrated Care Partnership (CCICP) data and reporting requirements, delivering the full lifecycle of data and analytics products that help our clinicians and managers make informed, data‑driven decisions. You'll work across our Data Warehouse and Business Intelligence Development teams, leading the design, development, and maintenance of data models, dashboards, and reports using SQL Server and Power BI. The role combines hands‑on technical delivery with leadership and collaboration, contributing to improved data quality, governance, and continuous improvement across the Trust.

Responsibilities

• Lead on data and analytics delivery for CCICP, working collaboratively with analysts, developers, and performance teams.
• Work with the Data Engineering team to design, build, and optimise data models and pipelines for performance and scalability.
• Design, build, and maintain high‑quality Power BI dashboards, data models, and reporting solutions that provide clear, actionable insights.
• Work with the Data Warehouse team to optimise queries, validate ETL processes, and maintain the Trust's data warehouse.
• Ensure data quality issues are identified and highlighted through reporting processes, working with Data Quality Leads and operational teams to ensure issues are corrected at source.
• Collaborate with clinical and corporate teams to ensure analytics products support national submissions and local performance priorities.
• Lead service area Data Governance Group meetings, recording and monitoring actions, risks and issues.
• Share knowledge and best practice to build resilience across the team and support the Trust's data improvement agenda.
• Occasionally support early‑morning or out‑of‑hours monitoring of data warehouse loads as part of a rota arrangement.
• Act as the lead point of contact for data and analytics for the allocated service area (CCICP).
• Build and maintain effective relationships with clinicians, managers, and corporate colleagues to understand and translate business requirements.
• Lead the development of data and analytics solutions, managing requirements end‑to‑end.
• Work with analysts to ensure they have the data needed for operational and strategic reporting.
• Collaborate with performance teams to ensure BI products support national submissions, compliance with standards, and the Trust's data quality agenda.
• Agree development ownership, deliverables and responsibilities for new solutions with colleagues in BI, Digital Services and wider teams.
• Initiate work by profiling data, identifying solutions, presenting options, proof of concepts and translating service needs into technical terms.
• Apply Agile delivery methods (Scrum, DevOps) and project management techniques.
• Plan and execute testing (unit, integration, acceptance) to ensure quality and accuracy of all outputs.

Data Warehouse & Engineering

• Support maintenance and integrity of the Trust's data warehouse and reporting infrastructure, including monitoring, troubleshooting and performance tuning.
• Participate in the out‑of‑hours rota for monitoring data warehouse processes and troubleshooting issues.
• Validate ETL processes, including during source system software upgrades, to ensure continuity and data integrity.
• Design and maintain the reporting layer, including dimensional modelling, to support efficient and reusable analytics.
• Apply expert T‑SQL and SQL Server skills for query optimisation and advanced data manipulation.
• Support adoption of automation, APIs and modern data platform techniques.
• Accountable to the Data Warehouse Manager.

Dashboard Development (Power BI) and Analytics

• Design, develop and maintain advanced dashboards and reporting suites using Power BI, adopting all available functionality such as data models, drill‑throughs, apps and self‑service features.
• Apply strong knowledge of DAX and Power Query for data transformation, advanced calculations and performance optimisation within Power BI.
• Leverage wider technologies, including Microsoft Forms, Power Automate and Power Platform tools, to enhance efficiency.
• Incorporate benchmarking and comparative analysis into reports and dashboards.
• Ensure BI products are user‑centred, accurate and aligned to Trust standards.
• Ensure dashboards support identification and monitoring of activity to support digital and operational transformation projects.
• Accountable to the Principal BI Developer.

External Engagement & Continuous Improvement

• Represent the department at internal, regional and other external NHS data and analytics forums.
• Share best practice across the department and with other NHS trusts, learning from others to improve local approaches.
• Keep abreast of national NHS data developments, policy changes and best practice.
• Ensure that data quality issues are effectively identified, highlighted and reported through dashboards, validation processes and automated checks; work closely with Data Quality Leads and operational teams to ensure issues are understood, prioritised and corrected at source, supporting development of processes that embed data quality monitoring within routine reporting and governance structures.
• Contribute to implementation of advanced analytics methods such as predictive analytics, modelling including AI, Python and R, to help drive innovation.

The postholder will be line managed by the Principal BI Developer and will work closely with the Data Warehouse Manager and other members of the Data teams.

Key Messages

Not all NHS roles are eligible for sponsorship. Candidates that require sponsorship to work in the UK are strongly advised to check the government website for up‑to‑date and job specific information. The salary threshold for sponsorship is £25,000 for Health and Care Visas and £41,700 (with limited exceptions) for Skilled Worker visas. The Trust will not sponsor where the starting salary does not meet these immigration rules.

Please let us know if you require an adjustment to our recruitment process and we'll be happy to discuss this with you. We actively promote flexible working so please discuss any requirements you may have with us. Secondments will be considered for fixed‑term positions when both parties agree. Candidates should seek approval from their current line manager before application.

All correspondence will be sent via the email address you have registered as your TRAC account. Selection is based on the Trust's values, and the criteria outlined in the Job Description for the role. Staff recruited from outside the NHS will usually be appointed at the entry point (bottom) of the pay band. Appointments are subject to a 6‑month probationary period. LED Doctors are subject to a 3‑month probationary period. You are required to pay for a DBS disclosure where the post requires one, and we encourage applicants to join and remain registered with the DBS update service. We do not reimburse travel to interview expenses. Some posts may have implications on existing NHS Pension Scheme arrangements. For further information please visit the NHS Pensions Agency website: https://www.nhsbsa.nhs.uk/nhs-pensions.

About Mid Cheshire Hospitals NHS Foundation Trust

Mid Cheshire Hospitals NHS Foundation Trust provides comprehensive hospital and community services for East Cheshire (population 399K) and West Cheshire and Chester (population 357K). Our services include planned and unplanned/emergency care, cardiac and critical care, child health, maternity, and intermediate care across Leighton Hospital in Crewe, Victoria Infirmary in Northwich, and Elmhurst Intermediate Care Centre in Winsford. Through our community arm, Central Cheshire Integrated Care Partnership, we deliver extensive services in 26 medical centres and schools in collaboration with Cheshire and Wirral Partnership NHS FT and the South Cheshire and Vale Royal GP Alliance. With 500 beds and around 5,500 staff, we are one of the area's largest employers. Since the formation of Integrated Care Systems in July 2022, the Trust has become a key partner in Cheshire East & Cheshire West and Chester and in two provider collaboratives, aligning our strategic goals with the Cheshire & Merseyside Integrated Care System. As part of the national New Hospital Programme, we're reimagining Leighton Hospital to create a new health and care neighbourhood, transforming healthcare delivery for a healthier future. Learn more on our Healthier Futures website. At Mid Cheshire, our mission is to inspire hope and provide unparalleled care for the people and communities of Cheshire, helping them to enjoy life to the fullest.