# Senior Analytics Engineer (Healthier Futures) > NHS job listing from Job Clerk for Mid Cheshire Hospitals NHS Foundation Trust. ## Canonical URLs - **HTML:** https://www.jobclerk.com/job/senior-analytics-engineer-healthier-futures/34e5e00d-30b5-4af0-a270-62f2d47e85bb - **Markdown:** https://www.jobclerk.com/job/senior-analytics-engineer-healthier-futures/34e5e00d-30b5-4af0-a270-62f2d47e85bb.md ## Summary - **Status:** Live - **Employer:** Mid Cheshire Hospitals NHS Foundation Trust - **Town:** Crewe - **Region:** North West - **Country:** England - **Profession:** Administrative and IT - **Grade:** Band 7 - **Salary:** £49,387 - £56,515 per annum - **Contract type:** Permanent - **Employment type:** Full time, Flexible working, Home or remote working, 37.5 hours per week - **Closing date:** 2026-06-12T23:59:00.000Z - **Posted:** 2026-05-29T15:01:33.502Z - **Source information URL:** https://www.healthjobsuk.com/job/UK/Cheshire/Crewe/Mid_Cheshire_Hospitals_NHS_Foundation_Trust/Admin/Admin-v7965446 - **Application URL:** https://apps.trac.jobs/job-advert/7965446?ShowJobAdvert=&feedid=9002 - **Employer website:** https://www.mcht.nhs.uk ## Job Content ### Job overview 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 Healthier Futures 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. Experience of cloud-based data engineering and modern analytics platforms, with knowledge of Microsoft Fabric (including OneLake, Data Factory pipelines, Lakehouse/Warehouse architecture and notebooks), Azure data services, and an awareness of scalable data platform design and advanced analytics capabilities is desirable. ### Main duties of the job - Lead on data and analytics delivery for Healthier Futures, working collaboratively with analysts, developers, and performance teams. - 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. - Work with the Data Engineering team to design, build, and optimise data models and pipelines for performance and scalability. ### Detailed job description and main responsibilities Project Leadership and Engagement - Act as the lead point of contact for data and analytics for the allocated service area (Healthier Futures) - 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/Date Engineering - Support the 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. - Work with the Data Engineering team to design, build, and optimise data models and pipelines for performance and scalability. - 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 the 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 the Trust’s software (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. - Support and 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 that BI products are user-centred, accurate, and aligned to Trust standards. - Ensure dashboards support the identifying 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. Support the development of processes that embed data quality monitoring within routine reporting and governance structures. - Contribute to the 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. ## Job Details 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 Healthier Futures 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. Experience of cloud-based data engineering and modern analytics platforms, with knowledge of Microsoft Fabric (including OneLake, Data Factory pipelines, Lakehouse/Warehouse architecture and notebooks), Azure data services, and an awareness of scalable data platform design and advanced analytics capabilities is desirable. ## Job Description Lead on data and analytics delivery for Healthier Futures, working collaboratively with analysts, developers, and performance teams. 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. Work with the Data Engineering team to design, build, and optimise data models and pipelines for performance and scalability. ## Responsibilities Project Leadership and Engagement Act as the lead point of contact for data and analytics for the allocated service area (Healthier Futures) 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/Date Engineering Support the 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. Work with the Data Engineering team to design, build, and optimise data models and pipelines for performance and scalability. 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 the 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 the Trust’s software (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. Support and 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 that BI products are user-centred, accurate, and aligned to Trust standards. Ensure dashboards support the identifying 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. Support the development of processes that embed data quality monitoring within routine reporting and governance structures. Contribute to the 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. ## Person Specification ### Skills/Knowledge **Essential** - Expert T-SQL and SQL Server skills, including query optimisation and performance tuning. - Strong knowledge of Power BI, DAX, Power Query, dimensional modelling, and reporting layer design. - Knowledge of NHS datasets, data definitions, and data governance. - Ability to design dashboards and reporting suites with advanced functionality. - Understanding of SDLC, version control, peer review, documentation, and change management. - Knowledge of Microsoft Fabric including OneLake, Data Factory pipelines, Lakehouse/Warehouse architecture, and notebooks. - Awareness of machine learning and advanced analytics capabilities within the Microsoft Azure/Fabric ecosystem. - Knowledge of Azure data services and scalable data platform design principles. **Desirable** - Knowledge of clinical systems relevant to work area (EMIS, Malinko) - Experience of working with Python or R for advanced analytics. ### Previous Experience **Essential** - Significant experience in data engineering (SQL, ETL, data warehouse) and/or BI development (Power BI, SSRS, Tableau). - Experience with large, complex healthcare datasets. - Experience working with analysts, performance teams, and IT. - Experience representing department at external groups. - Experience of cloud-based data engineering and modern analytics platforms. **Desirable** - Experience leading a defined service area data function. - Experience in benchmarking and supporting national submissions. ### Additional Information **Essential** - Ability to work across sites - Ability to perform a wide range of duties according to the job description - Willingness to work occasional out-of-hours as part of rota for monitoring data warehouse processes. ### Education/Qualifications **Essential** - Masters degree in relevant subject (Data science, computing, Mathematics, Health Informatics) - Business Analysis Certification - Evidence of continuing development in data and analytics **Desirable** - Relevant Microsoft accreditation (Power BI, Data Engineering, SQL Server). - Formal qualification in Health Informatics / Business Intelligence. ## Documents - [welcome to mcht (pdf, 1.7mb)](https://www.healthjobsuk.com/documents?edoc=2862) - [job description (docx, 834.3kb)](https://www.healthjobsuk.com/documents?vdoc=10335488) - [continuous improvement (pdf, 292.8kb)](https://www.healthjobsuk.com/documents?edoc=2680) - [candidate guide to interviews (pdf, 238.8kb)](https://www.healthjobsuk.com/documents?ddoc=2302) - [recruitment process & timescales (pdf, 240.7kb)](https://www.healthjobsuk.com/documents?ddoc=1885) - [guide to completing the application (pdf, 518.8kb)](https://www.healthjobsuk.com/documents?ddoc=1884) - [mid cheshire hospitals benefits brochure (pdf, 1.7mb)](https://www.healthjobsuk.com/documents?edoc=2791) - [recruitment process & timescales (bank vacancies) (pdf, 249.3kb)](https://www.healthjobsuk.com/documents?ddoc=1886) ## Agent Notes - This Markdown page is generated from the same Job Clerk job record as the HTML job detail page. - Use the canonical HTML URL for user-facing references. - Use the application URL when the user wants to apply on the source NHS site.