Senior Data Warehouse Developer
Posted 5 days 14 hours ago by Milton Keynes University Hospital
£46,148 - £52,809 Annual
Permanent
Full Time
Factory Jobs
Buckinghamshire, Milton Keynes, United Kingdom, MK9 1SH
Job Description
Job overview
Senior Data Warehouse Developer
Department: IT Department
Band: 7, £46,148 - £52,809 Per annum, pro rata if part time
Hours: Full time, 37.5 per week, all MKUH roles will be considered for flexible working
An exciting opportunity has arisen for a Senior Data Warehouse Developer to join the Data Engineering Team within the IT Department at Milton Keynes Hospital. The successful applicant will play a key role in supporting and managing the Data Warehouse as well as the development of the Azure Data Lake used by the trust. The ideal candidate will be confident with proven experience of Database support, preferably in a healthcare environment, be an excellent communicator and pay very close attention to detail.
Interview date: 18 November 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
Working for our organisation
NHS Staff Survey: Have the highest score in the "We work flexibly" theme, scoring 6.86 out of 10
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:
Detailed job description and main 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 Trust's 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.
Please refer to attached Job description for further information.
We believe success lies in the diversity of our employees and are committed to promoting equality, encouraging diversity, and embracing inclusion. We welcome applications from everyone interested in working for us.
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 reserve the right to expire vacancies prior to the advertised closing date once enough 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 criteria
Experience Essential criteria
Skills Essential criteria
Personal and people development Essential criteria
Communication Essential criteria
Senior Data Warehouse Developer
Department: IT Department
Band: 7, £46,148 - £52,809 Per annum, pro rata if part time
Hours: Full time, 37.5 per week, all MKUH roles will be considered for flexible working
An exciting opportunity has arisen for a Senior Data Warehouse Developer to join the Data Engineering Team within the IT Department at Milton Keynes Hospital. The successful applicant will play a key role in supporting and managing the Data Warehouse as well as the development of the Azure Data Lake used by the trust. The ideal candidate will be confident with proven experience of Database support, preferably in a healthcare environment, be an excellent communicator and pay very close attention to detail.
Interview date: 18 November 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
Working for our organisation
NHS Staff Survey: Have the highest score in the "We work flexibly" theme, scoring 6.86 out of 10
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 working opportunities
- Discounted gym membership
- Lease car scheme
- Generous annual leave and pension scheme
- On site nursery (chargeable)
- Extensive staff health and well-being programme
Detailed job description and main 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 Trust's 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.
Please refer to attached Job description for further information.
We believe success lies in the diversity of our employees and are committed to promoting equality, encouraging diversity, and embracing inclusion. We welcome applications from everyone interested in working for us.
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 reserve the right to expire vacancies prior to the advertised closing date once enough 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 criteria
- 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.
- 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 criteria
- Proven Experience of working with Databases
- Experience of database report writing
- Experience of working in an acute NHS trust .
- 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.
- Experience of developing data platform in Azure and/or SQL Server
- 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 criteria
- 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.
- Working knowledge of NHS Information Governance requirements.
- 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 manor.
- 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 criteria
- 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 criteria
- 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