Job summary
The Data Warehouse Engineer role will deputise the Data Warehouse Manager. The role will be hands on in the management and continuous development of the Trust's on-premise, Private cloud and Azure public cloud SQL data warehousing environment.
Main duties of the job
The use of Microsoft tools within the data stack will be common. These include but are not limited to SSIS and SSMS. This role is not just confined to Data Warehouse administration but will be heavily involved in dataset development for use within the organisation and in support of projects outside of the organisation.
About us
Why colleagues think we are "a great place to work!"
What does Buckinghamshire Healthcare NHS Trust offer you?
As part of our BHT family, you'll benefit from learning and development opportunities to support your career progression.
Alongside NHS benefits of generous annual leave entitlement and pension scheme, you'll have access to NHS discount schemes.
We provide a range of health and wellbeing services to promote a healthy, happy workforce.
What do we stand for?
Our vision is to provide outstanding care, support healthy communities and be a great place to work.
Our mission is to provide personal and compassionate care every time.
We are working hard to increase diversity at all levels within the trust. We believe a diverse workforce can have a positive effect on both staff wellbeing and patient outcomes.
We welcome applications from black, Asian and minority ethnic candidates, LGBTQ+ candidates, candidates with disabilities and care-experienced candidates.
We are proud to achieve the Gold award for the Armed Forces Covenant and support applications from the Armed Forces Community. Please contact Pam.Daley@nhs.net (our Armed Forces Covenant Lead) if you would like guidance or assistance with your application.
We make employment decisions by matching our service needs with the skills and experience of candidates, regardless of age, disability, gender, gender identity, marriage and civil partnership, pregnancy and maternity, race, religion or belief, or sexual orientation.
Job description
Job responsibilities
For a comprehensive list of responsibilities and duties, please kindly refer to the Job Description and Person Specification by downloading the JD and PS attachment in the advert.
If you are an internal applicant there is the option for secondment, all applicants must have the endorsement/support of their line manager prior to application.
If you have a disability that makes submitting this online application difficult and would like assistance, please contact us on bht.recruitment@nhs.net quoting the vacancy reference number.
Job description
Job responsibilities
For a comprehensive list of responsibilities and duties, please kindly refer to the Job Description and Person Specification by downloading the JD and PS attachment in the advert.
If you are an internal applicant there is the option for secondment, all applicants must have the endorsement/support of their line manager prior to application.
If you have a disability that makes submitting this online application difficult and would like assistance, please contact us on bht.recruitment@nhs.net quoting the vacancy reference number.
Person Specification
Education, Qualifications & Training
Essential
- Evidence of continuous professional development
- Industry certifications (Microsoft Azure Data Engineer, Databricks Certified Data Engineer)
Desirable
- Degree in Computer Science, Data Engineering, Information Systems or related discipline
Experience
Essential
- Hands-on experience developing and maintaining SQL-based data pipelines or ETL workflows
- Experience of automating data transfers or extract creation
- Experience working with relational databases, especially SQL Server
- Experience transforming raw datasets into analysis-ready structures
- Experience managing and governing access to SQL Server and SQL Databases
Desirable
- Exposure to cloud data tools (e.g. Azure Data Factory, Synapse)
- Experience working with APIs or Integration Engines
- Experience with NHS Commissioning and income processing
Person Specification
Education, Qualifications & Training
Essential
- Evidence of continuous professional development
- Industry certifications (Microsoft Azure Data Engineer, Databricks Certified Data Engineer)
Desirable
- Degree in Computer Science, Data Engineering, Information Systems or related discipline
Experience
Essential
- Hands-on experience developing and maintaining SQL-based data pipelines or ETL workflows
- Experience of automating data transfers or extract creation
- Experience working with relational databases, especially SQL Server
- Experience transforming raw datasets into analysis-ready structures
- Experience managing and governing access to SQL Server and SQL Databases
Desirable
- Exposure to cloud data tools (e.g. Azure Data Factory, Synapse)
- Experience working with APIs or Integration Engines
- Experience with NHS Commissioning and income processing
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.
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
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.
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).
