Job summary
Senior Data Warehouse Developer
Department IT Department
Band 7 £43,742 - £50,056 Per annum
Hours: 37.5 per week, all MKUH roles will be considered for flexibleworking
An exciting opportunity has arisen for a Senior Data Warehouse Developer to join our dynamic Data Engineering Team within the IT Department at Milton Keynes Hospital.
The successful applicant will play a key role in design, develop, and maintain our data warehouse, ensuring the efficient and accurate processing of data as well as the development of the Azure Data Lakehouse used by the trust.
The ideal candidate will be confident with proven experience of data warehousing, SQL and Python or R programming preferably in a healthcare environment with excellent problem-solving skills, and the ability to collaborate effectively with cross-functional teams.
Interview date: 8th July 2024
Main duties of the job
The overall aim of this role is to support the Trust's data warehouse and help enable the effective use of data by Trust stakeholders such as information analysts, managers and clinicians to improve health care delivery at the Trust.
The responsibilities of the post-holder will be diverse and changing depending on the projects the team is working on. The team's core functions are to develop, maintain and enhance the Trust's data capabilities, to ensure the accuracy and robustness of central submissions and information on which the organisation operates
About us
Our staff are the happiest NHS staff; MKUH staff scored highest for 'I look forward to coming to work' (NHS Staff Survey 2023).
You can expect a warm welcome at Milton Keynes University Hospital, our staff are friendly and welcoming. We listen to each other and work together to embed our Trusts values and behaviours. At MKUH we appreciate our staff and reward them with an outstanding benefits package including:
- Free on-site parking
- Free tea and coffee
- Great flexible workingopportunities
- Discounted gym membership
- Lease car scheme
- Generous annual leave and pension scheme
- On site nursery (chargeable)
- Extensive staff health and well-being programme
Milton Keynes University Hospital NHS Foundation Trust, in partnership with the University of Buckingham, is a University Teaching Hospital; we conduct research and teaching on site to improve the care of our patients. The hospital is undergoing significant investment, and we are proud to be rated good by the CQC. Visit our website to catch up on our latest news.
Job description
Job responsibilities
- The post-holder will be required to work in a team responsible for the development, maintenance and performance of the data warehouse.
- Take a lead in ensuring the Trusts data warehouse is appropriately maintained and updated to meet the specific needs of the Trust, as directed by the Database Warehouse Manager. This may include monitoring and analysing highly complex Extract, Transform and Load (ETL) processes and managing the Microsoft SQL databases.
- Investigate and identify complicated database related issues and make suggestions for solutions and implement resolution if agreed with relevant change controls.
- Develop connections to new databases and making data or connections available to systems as required.
- Provide assistance with the timely daily processing of data into the data warehouse processes in a timely manner to allow the reporting of both clinical and management information to aid the smooth running of services and performance management.
- The post holder will be responsible for developing the trust Data Platform in Microsoft Azure as well as managing the existing SQL Server data warehouse. Which includes developing and managing the Microsoft Azure pipelines, SQL Servers, Azure Synapse Analytics.
Please refer to the Job Description for further details
MKUH is committed to equal opportunities and improving the working lives of our staff and as such we offer a range of flexible working practices. We promote an inclusive workforce and encourage applications from applicants from all backgrounds.
We reserve the right to expire vacancies prior to the advertised closing date once a sufficient number of applications have been received.
MKUH uses identification scanning technology to confirm the authenticity of documents; all prospective employees of MKUH will have their original documents verified using this technology.
By applying for this role, you accept if successful, that information from your application will be transferred into the national NHS Electronic Staff Record (ESR) system. Your personal data may be transferred from the Trust to another NHS organisation where your employment transfers within the NHS. This is in accordance with the streamlining programme which aims at saving you time and improving efficiencies within the NHS when your employment transfers.
Upon commencing employment with the Trust, all employees (except Medical & Dental Staff on national terms and conditions) are subject to a probationary period lasting a period of six months with an option to extend for a further six months to a total of 12 months.
Person Specification
Qualifications and knowledge
Essential
- Degree level or equivalent experience (relevant to role). Postgraduate qualification in relevant area or equivalent experience.
- Strong knowledge of RDBMS concepts, database architecture and T-SQL.
- Knowledge of Business Intelligence systems and reporting tools.
- Report writing skills preferably using Power BI.
- Knowledge of Sql Server, Sql Server Integration Services, Sql Server Reporting Services
- Knowledge of Azure Data Factory, Azure Analysis Services
- Advanced use of Microsoft Office 365 suite especially Excel.
- Knowledge of NHS and acute datasets.
- Experience of Data science languages such as R or Python.
Desirable
- Qualification in Project Management
- ITIL certification
- Knowledge of Microsoft Azure Platform.
- Knowledge of patient and data flows in an hospital setting.
- Experience of Azure DevOps Services, CI/CD pipelines.
- Experience of MongoDB
- Microsoft Certification (in Azure or Data Analytics)
Experience
Essential
- Proven Experience of working with Databases
- Experience of database report writing
- Experience of working on data science projects using Python or similar.
- Experience of indexing and database optimization techniques
- Advanced knowledge of SQL Server 2012+ and at least 3 years' experience.
- Experience of Developing SSIS packages
- Knowledge of relevant legal requirements especially around processing personal data.
Desirable
- Experience of developing data platform in Azure and/or SQL Server.
- Experience of working in an acute NHS trust .
- Experience of working with Azure Analysis Services and Azure Data Factory .
- Experience of assisting in infrastructure deployment in Azure
- Advanced knowledge and competent use of Patient Administration System and other HealthCare I.T. systems,
Skills
Essential
- Able to work independently and proactively.
- Numerate, articulate and able to assimilate, analyse, interpret and compare highly complex facts/situations.
- Able to liaise with external system suppliers.
- Working knowledge of NHS Information Governance requirements.
- Ability to Communicate effectively with internal staff and external agencies to ensure compliance with trust objectives.
- Strong administrative and organisational skills
- Good analytical skills for spotting or anticipating weaknesses in processes (manual or system), along with the ability to organise and implement correction
- Structured, diagnostic approach to finding solutions to highly complex data issues.
- Innovative and lateral thinker
- Ability to identify and embrace change in the drive towards continuous improvement
- Ability to present and relay complex or combined datasets and data concepts in a clear manner.
- Ability to deliver sensitive data in a professional and empathetic style including to train staff on a one to one basis
- Ability to operate consistently at high level summary as well as detail levels
- Ability to listen and interpret users' needs and to inspire confidence
Personal and people development
Essential
- Evidence of commitment to Continuous Professional Development.
- Self-motivated and able to work to tight deadlines with a flexible approach to work.
- Good attention to detail.
- Ability to work as a member or a team.
Communication
Essential
- Strong communication skills - written and verbal - able to identify key points from complex issues and explain them appropriately and with clarity across a wide range of stakeholders both within an organisation and externally.
- Experience of communicating complex issues and data concepts to a range of people
Specific requirements
Essential
- Able to perform the duties of the post with reasonable aids and adaptations.
Disclosure and Barring Service Check
This post is subject to the Rehabilitation of Offenders Act (Exceptions Order) 1975 and as such it will be necessary for a submission for Disclosure to be made to the Disclosure and Barring Service (formerly known as CRB) to check for any previous criminal convictions.
Employer details
Employer name
Milton Keynes University Hospital NHS Foundation Trust
Address
Milton Keynes University Hospital
Milton Keynes
MK6 5LD