Job summary At Mid Yorks, we're evolving how we think about Data & Analytics. When it comes to reporting, dashboards and self-service analytics - we believe that less is more. We're migrating away from our legacy data infrastructure into the cloud and we are holistically redesigning our reporting estate to provide a golden thread of intelligence from board-to-ward in alignment with the Trust's objectives. The Analytics Engineer will play a pivotal role in this professionalisation, brining deep PowerBI expertise and analytics development frameworks to the service to ensure consistency, usability, impact and relevance across the analytics estate. If you love PowerBI and you're passionate about doing it right & for the long term - please apply Due to the high volume of applications we anticipate, we reserve the right to close this advert early. We encourage you to apply promptly to avoid disappointment. Main duties of the job The Analytics Engineer works as part of the Intelligence Team whose purpose is to provide a Single Version of the Truth for all the reporting, analytical and business intelligence needs of Mid Yorkshire Teaching NHS Trust. The Intelligence Team falls within The Office of Data and Analytics. The Analytics Engineer fosters strong relationships with their customers and works hard to understand their requirements with a view to incorporating them into the analytics platform through the understanding and interpretation of business questions. The post-holder is an expert in the field of Analytics Development within the Microsoft PowerBI environment and supports colleagues across the Trust in this domain. The Analytics Engineer values teamwork and agrees and adheres to best practice to facilitate this. About us We are an acute trust caring for over half a million people in Wakefield and Kirklees. Our 10,000 staff work in patients homes, the community, and our three hospitals in Pontefract, Dewsbury, and Pinderfields (Wakefield). We prioritise our people and values so we can deliver the best possible care to patients. Our team is friendly, passionate, and innovative, always seeking better ways to work. We support work-life balance and foster a diverse, inclusive environment where everyone belongs. Our staff networks offer safe spaces to share ideas and concerns so we can increase awareness and appreciation of equality, diversity, and inclusion. We welcome applicants from all backgrounds and especially encourage members of the LGBTQ community, ethnic minority groups, and people with disabilities or neurodivergence to apply, as they are currently underrepresented in the Trust. If you value caring, high standards, improvement, and respect, join the MY team to make a difference every day. Application guidance: We understand that more applicants are using AI technology to help with their applications. While these tools can be useful, they cannot fully capture your skills, knowledge, and experience. Its important that you personalise your application. Relying solely on AI is not recommended, as it may reduce your chances of success. Our screening process is thorough, so if you have used AI, please make sure to disclose this on your application form. Date posted 07 April 2025 Pay scheme Agenda for change Band Band 7 Salary £46,148 to £52,809 a year Contract Permanent Working pattern Full-time, Flexible working Reference number C9377-CORP0763 Job locations Dewsbury Hospital Halifax Road Dewsbury West Yorkshire WF13 4HS Job description Job responsibilities The design, development, testing and maintenance of processes & products using Microsoft PowerBI. The design, documentation & development of dimensional & relational data structures to represent data from the Data Warehouse architecture using PowerBI. Work with Data Engineering colleagues to align PowerBI Datasets & Data Models with the Data Warehouse. Manage Gateways & Dashboards on an ongoing basis. To create, maintain & support others in the development of analytics solutions. To agree & develop against Intelligence Team best practices & to design elegant and re-usable solutions in line with the teams development principles. To contribute and adhere to development patterns, frameworks & best practices to standardise analytical solutions. The timely & effective debugging of urgent system faults to solve complex technical problems & restore services. The creation & application of thorough re-usable testing plans to assure the quality of developments. To work within the teams development sprint framework and to meet agreed deadlines but be flexible enough to respond to urgent requests to meet the changing needs of the business. To work with the Intelligence Teams customers to identify their requirements and translate into formal, technical specifications. The implementation of global PowerBI security and data governance policy & provision. To manage and maintain the PowerBI Premium Capacity Licence, ensuring equality of service across the place. To work comfortably within the team, mentor teammates, be mentored by others, share knowledge and learn. Provide clear and concise documentation, which meets best practice and clearly describes complex processes, leveraging existing diagramming techniques & house styles as appropriate. To be subject matter expert on matters concerning the Trusts Analytics Platform and Microsoft PowerBI. Be driven to continually learn & improve professional technical skills & maintain up to date specialist knowledge. Provide cover and support across the Intelligence Team as required. Be aware of changes to relevant NHS standards, guidance, and specifications & suggest changes to maintain compliancy. To follow standard operating procedures where appropriate whilst challenging their relevance, accuracy and candidacy for automation. Be a protagonist in the DevOps movement in the Intelligence Team, contribute to and adhere to the process to provide consistent, reliable & fast deployments. Any other duties commensurate to the post. Job description Job responsibilities The design, development, testing and maintenance of processes & products using Microsoft PowerBI. The design, documentation & development of dimensional & relational data structures to represent data from the Data Warehouse architecture using PowerBI. Work with Data Engineering colleagues to align PowerBI Datasets & Data Models with the Data Warehouse. Manage Gateways & Dashboards on an ongoing basis. To create, maintain & support others in the development of analytics solutions. To agree & develop against Intelligence Team best practices & to design elegant and re-usable solutions in line with the teams development principles. To contribute and adhere to development patterns, frameworks & best practices to standardise analytical solutions. The timely & effective debugging of urgent system faults to solve complex technical problems & restore services. The creation & application of thorough re-usable testing plans to assure the quality of developments. To work within the teams development sprint framework and to meet agreed deadlines but be flexible enough to respond to urgent requests to meet the changing needs of the business. To work with the Intelligence Teams customers to identify their requirements and translate into formal, technical specifications. The implementation of global PowerBI security and data governance policy & provision. To manage and maintain the PowerBI Premium Capacity Licence, ensuring equality of service across the place. To work comfortably within the team, mentor teammates, be mentored by others, share knowledge and learn. Provide clear and concise documentation, which meets best practice and clearly describes complex processes, leveraging existing diagramming techniques & house styles as appropriate. To be subject matter expert on matters concerning the Trusts Analytics Platform and Microsoft PowerBI. Be driven to continually learn & improve professional technical skills & maintain up to date specialist knowledge. Provide cover and support across the Intelligence Team as required. Be aware of changes to relevant NHS standards, guidance, and specifications & suggest changes to maintain compliancy. To follow standard operating procedures where appropriate whilst challenging their relevance, accuracy and candidacy for automation. Be a protagonist in the DevOps movement in the Intelligence Team, contribute to and adhere to the process to provide consistent, reliable & fast deployments. Any other duties commensurate to the post. Person Specification Experience Essential Experienced in the design, development, testing and maintenance of complex technical analytics solutions. Experienced in development across Microsoft PowerBI at an expert level across various versions. Experience of design, development, testing, deployment, reverse engineering and documentation of complex processes & products using PowerBI. Experienced in the design, documentation & development of dimensional and relational data models. Experience of debugging & problem solving of complex technical issues under time pressure. Experience of creating & applying repeatable testing plans to assure quality of developments. Experience of building advanced PowerBI solutions. Experience of working to and meeting deadlines. Experienced translator of non-technical, colloquial requirements into formal technical specifications. Experienced in the complexities of working within a technical team. Experience of teaching & mentorship. Previous experience of working within an information related department. Desirable Experienced in the development & maintenance of QlikSense & QlikView solutions. Other Desirable An interest & passion about technology and how it can be leveraged to improve the NHS into the future and an appreciation about how data (& data warehousing) is fundamental to this. Skills & Abilities Essential Expert level of skill within Microsoft PowerBI for development purposes. Able to work within development sprints to meet tight deadlines. Able to effectively manage competing priorities. Able to communicate well with all colleagues. Able to negotiate effectively with a wide range of partners with tact and persuasion. Knowledge & Awareness Essential Solid knowledge of analytics, particularly within an NHS setting. Deep knowledge and understanding of DAX (Data Analysis Expressions) for data modelling, report creation and dashboard development in PowerBI. An awareness of the levels of normalisation and its use-cases. Knowledge and awareness of Data Flow Diagrams and an appreciation for their importance. Knowledge of the relationships within datasets and the use of Entity Relationship Diagrams to describe these. Knowledge and awareness of Star Schema data models and how these can be implemented in a data warehouse. Knowledge of NHS information standards and guidance. Knowledge of NHS data manual and definitions. NHS reporting standards and requirements. Understanding of Data Protection and Caldicott Security and Confidentiality, Data Protection Act. Desirable An awareness & appreciation of the roles and responsibilities of Data Engineers. An awareness of SQL internals and how SQL functions under the covers and how this can be leveraged to aid development. An awareness of SQL statements and or how these actions can be carried out through SQL Server Management Studio. Knowledge of Local Patient Information Systems/Databases. Knowledge or awareness of DevOps processes. Qualifications Essential Postgraduate qualification or ability to demonstrate equivalent level of experience. Personal Attributes Essential Driven to continually learn and improve professional technical skills. Flexible approach to working hours to meet the needs of the service. Desirable An imaginative and creative approach. A self-starter with a degree of independence. A finisher who maintains the same level of enthusiasm throughout each project. A bias towards collaborative team work. Team player with a willingness and impulse to help others within the team. Look to disrupt traditional ways of working through your technical ability. A predisposition to question the status-quo, share opinions and contribute to the teams continued progression. Enthusiastic and passionate about Microsoft PowerBI development within the NHS. Person Specification Experience Essential Experienced in the design, development, testing and maintenance of complex technical analytics solutions. Experienced in development across Microsoft PowerBI at an expert level across various versions. Experience of design, development, testing, deployment, reverse engineering and documentation of complex processes & products using PowerBI. Experienced in the design, documentation & development of dimensional and relational data models. Experience of debugging & problem solving of complex technical issues under time pressure. Experience of creating & applying repeatable testing plans to assure quality of developments. Experience of building advanced PowerBI solutions. Experience of working to and meeting deadlines. Experienced translator of non-technical, colloquial requirements into formal technical specifications. Experienced in the complexities of working within a technical team. Experience of teaching & mentorship. Previous experience of working within an information related department. Desirable Experienced in the development & maintenance of QlikSense & QlikView solutions. Other Desirable An interest & passion about technology and how it can be leveraged to improve the NHS into the future and an appreciation about how data (& data warehousing) is fundamental to this. Skills & Abilities Essential Expert level of skill within Microsoft PowerBI for development purposes. Able to work within development sprints to meet tight deadlines. Able to effectively manage competing priorities. Able to communicate well with all colleagues. Able to negotiate effectively with a wide range of partners with tact and persuasion. Knowledge & Awareness Essential Solid knowledge of analytics, particularly within an NHS setting. Deep knowledge and understanding of DAX (Data Analysis Expressions) for data modelling, report creation and dashboard development in PowerBI. An awareness of the levels of normalisation and its use-cases. Knowledge and awareness of Data Flow Diagrams and an appreciation for their importance. Knowledge of the relationships within datasets and the use of Entity Relationship Diagrams to describe these. Knowledge and awareness of Star Schema data models and how these can be implemented in a data warehouse. Knowledge of NHS information standards and guidance. Knowledge of NHS data manual and definitions. NHS reporting standards and requirements. Understanding of Data Protection and Caldicott Security and Confidentiality, Data Protection Act. Desirable An awareness & appreciation of the roles and responsibilities of Data Engineers. An awareness of SQL internals and how SQL functions under the covers and how this can be leveraged to aid development. An awareness of SQL statements and or how these actions can be carried out through SQL Server Management Studio. Knowledge of Local Patient Information Systems/Databases. Knowledge or awareness of DevOps processes. Qualifications Essential Postgraduate qualification or ability to demonstrate equivalent level of experience. Personal Attributes Essential Driven to continually learn and improve professional technical skills. Flexible approach to working hours to meet the needs of the service. Desirable An imaginative and creative approach. A self-starter with a degree of independence. A finisher who maintains the same level of enthusiasm throughout each project. A bias towards collaborative team work. Team player with a willingness and impulse to help others within the team. Look to disrupt traditional ways of working through your technical ability. A predisposition to question the status-quo, share opinions and contribute to the teams continued progression. Enthusiastic and passionate about Microsoft PowerBI development within the NHS. Certificate of Sponsorship Applications from job seekers who require current Skilled worker sponsorship to work in the UK are welcome and will be considered alongside all other applications. For further information visit the UK Visas and Immigration website (Opens in a new tab). From 6 April 2017, skilled worker applicants, applying for entry clearance into the UK, have had to present a criminal record certificate from each country they have resided continuously or cumulatively for 12 months or more in the past 10 years. Adult dependants (over 18 years old) are also subject to this requirement. Guidance can be found here Criminal records checks for overseas applicants (Opens in a new tab). Additional information Certificate of Sponsorship Applications from job seekers who require current Skilled worker sponsorship to work in the UK are welcome and will be considered alongside all other applications. For further information visit the UK Visas and Immigration website (Opens in a new tab). From 6 April 2017, skilled worker applicants, applying for entry clearance into the UK, have had to present a criminal record certificate from each country they have resided continuously or cumulatively for 12 months or more in the past 10 years. Adult dependants (over 18 years old) are also subject to this requirement. Guidance can be found here Criminal records checks for overseas applicants (Opens in a new tab). Employer details Employer name The Mid Yorkshire Teaching NHS Trust Address Dewsbury Hospital Halifax Road Dewsbury West Yorkshire WF13 4HS Employer's website https://www.midyorks.nhs.uk/ (Opens in a new tab)