Job summary
An exciting opportunity has risen for a Principal Infrastructure/ Data Engineer to join the Health Education England (HEE) National Data Service. This team is responsible for a joined up approach to the development, acquisition management, and use of data across the organisation.
To be successful in this role, the post holder will work closely with developers within the Data Service and across HEE to identify infrastructure requirements for the National Data Warehouse.
You will also have intensive skills and experience in:
- DevOps process automation (we use Azure DevOps)
- Configuring, deploying and managing Azure data infrastructure using PowerShell and ARM templates.
- Microsoft Azure services, particularly with reference to cloud data warehouse architecture, networking and security
- Database development using SSMS version 17 or higher
- ETL configuration / development / deployment (Azure Data Factory / SSIS, plus support for repeatable analytical pipelines)
- Configuration / deployment of Azure analysis services
- Data modelling / validation
- DBA skills (server management, SQL jobs management, scheduling, scaling, backup / restore, security, account management / permissions, server objects, replication)
- Source control / DataOps (preferably Azure DevOps/Git)
- Collaboration tools (e.g. MS Teams / Slack / JIRA)
Main duties of the job
The Principal Infrastructure / Data Engineer will be responsible for:
- Development and maintenance of the HEE National Data Warehouse infrastructure in the Azure cloud using DevOps methods (Bicep, ARM templates, PowerShell etc.)
- Maintenance, testing and extension of our Geo-Redundant disaster recovery plan / data centre infrastructure migration
- Upgrade SharePoint data storage to Azure DataLake
- Extension of the Azure Managed Instance solution architecture to cope with predicted additional capacity demands(scaling, additional storage, housekeeping etc.)
- Azure Active Directory / network integration
- Security hardening of the National Data Warehouse components (adapting the current configuration to use private endpoints, managed identities, service principals etc where necessary)
- Collaboration with external consultancy on the production / development of test and prod environments to support data science / machine learning activities (DataBricks, Azure ML services etc.)
- The incorporation of metadata management services, linking with NHSD’s Collibra product
- The incorporation of a data cataloguing tool to facilitate discovery of / access to data (solution tbc)
- Staff training and documentation to ensure resilience of services / configuration
About us
Health Education England exists to support the delivery of excellent healthcare and health improvement to the patients and public of England by ensuring that the workforce for today and tomorrow have the right numbers, skills, values, and behaviours, at the right time in the right place. The HEE National Data Service aims to provide high quality, robust and trusted data from one central source to enable HEE to efficiently achieve its strategic objectives.
HEE is a friendly and high performing organisation. You can find out more about our workvia our website or via the attached “important information about HEE and your application” document.
At Health Education England, we realise that many applicants have busy and have demanding commitments outside of their working lives and so may be unable to commit to a traditional working pattern. Options such as job sharing, flexible start and finish times and part-time hours are available, and we welcome a conversation to explore any of these should you wish something different.
Please note that HEE is currently working from home due to the COVID-19 pandemic. Longer term flexible working requests, including remote working, will be considered. Please note Remote/Flexible working is only available for UK Based applicants as there may still be a requirement to attend a HEE base in the future
Job description
Job responsibilities
You can find further details about the job, organisational structure, recruitment profile, expected outcomes and benefits information in the attached Job Description and other supporting documents
Salary Progression Applicants will commence at the bottom of Band 8c with a full-time starting salary of £67,064, with a pay step increase after 5 years service. For posts based in Inner London, the above salaries will include the additional supplement of 20% of basic salary, subject to a minimum payment of £4,888 per annum and a maximum payment of £7,377 per annum. This is offered in accordance with NHS Terms and Conditions and is based on office location.
Job description
Job responsibilities
You can find further details about the job, organisational structure, recruitment profile, expected outcomes and benefits information in the attached Job Description and other supporting documents
Salary Progression Applicants will commence at the bottom of Band 8c with a full-time starting salary of £67,064, with a pay step increase after 5 years service. For posts based in Inner London, the above salaries will include the additional supplement of 20% of basic salary, subject to a minimum payment of £4,888 per annum and a maximum payment of £7,377 per annum. This is offered in accordance with NHS Terms and Conditions and is based on office location.
Person Specification
Qualifications and Training
Essential
- Educated to degree level or equivalent in computing or related engineering discipline
- Post-graduate / specialist technical qualification(s)
Desirable
- Evidence of relevant continous personal and professional development throughout career
Skills and Abilities
Essential
- Skills in DevOps process automation (Azure DevOps) and configuring, deploying and managing Azure data infrastructure using PowerShell and ARM templates
- Skills in Microsoft Azure services, particularly with reference to cloud data warehouse architecture, networking and security
- Skills in Database development using SSMS version 17 or higher
- Skills in ETL configuration / development / deployment (Azure Data Factory / SSIS, plus support for repeatable analytical pipelines
Desirable
- Abilities to use collaboration tools (e.g. MS Teams / Slack / JIRA)
Key Working Relationships
Essential
- Evidence of a strong focus on customers/service delivery, including managing expectations, service level agreements and effective problem resolution
- Experience of managing a team and achieving objectives
- bility to maintain a constructive relationships with a broad range of internal an external stakeholders
Experience and Knowledge
Essential
- DBA experience (server management, SQL jobs management, scheduling, scaling, backup / restore, security, account management / permissions, server objects, replication)
- Experience of configuration / deployment of Azure analysis services
- Experience in Data modelling / validation
Person Specification
Qualifications and Training
Essential
- Educated to degree level or equivalent in computing or related engineering discipline
- Post-graduate / specialist technical qualification(s)
Desirable
- Evidence of relevant continous personal and professional development throughout career
Skills and Abilities
Essential
- Skills in DevOps process automation (Azure DevOps) and configuring, deploying and managing Azure data infrastructure using PowerShell and ARM templates
- Skills in Microsoft Azure services, particularly with reference to cloud data warehouse architecture, networking and security
- Skills in Database development using SSMS version 17 or higher
- Skills in ETL configuration / development / deployment (Azure Data Factory / SSIS, plus support for repeatable analytical pipelines
Desirable
- Abilities to use collaboration tools (e.g. MS Teams / Slack / JIRA)
Key Working Relationships
Essential
- Evidence of a strong focus on customers/service delivery, including managing expectations, service level agreements and effective problem resolution
- Experience of managing a team and achieving objectives
- bility to maintain a constructive relationships with a broad range of internal an external stakeholders
Experience and Knowledge
Essential
- DBA experience (server management, SQL jobs management, scheduling, scaling, backup / restore, security, account management / permissions, server objects, replication)
- Experience of configuration / deployment of Azure analysis services
- Experience in Data modelling / validation
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) .
