Senior Data Engineer | Northern Care Alliance NHS Foundation Trust
An exciting opportunity has arisen in the Data and Analytics Team, at Northern Care Alliance, for a Senior Data Engineer to help migrate the current on-premises solution to a cloud-based solution in Azure.
The Data and Analytics Team has recently undergone a period natural growth and progression which has resulted in the opportunity for two Senior Data Engineers to join the existing Data Platform Team.
This is a fantastic opportunity to join a team that is looking to be one of the first hospitals in the country to have a complete Cloud Based Data Warehouse Solution.
The Data and Analytics Team is not only transitioning to a state-of-the-art Azure data platform we are also implementing an agile multi-disciplinary, product focused approach to delivering cutting edge insights, data science and visualisations to the organisation.
The Senior Data Engineer is pivotal to the delivery of high-quality efficient healthcare provision, robust information to operational, clinical and corporate decision makers through the use of on-demand reporting through our current Data Warehouse and moving forward our cloud-based data warehouse.The successful candidate will help to design, develop & implement the trusts new cloud-based data warehouse, alongside be responsible for the migration away from legacy/on-prem solutions and replacing them with state-of-the-art cloud based technologies (Azure), alongside this you will also help to maintain & develop existing on-prem solutions.
- You will be working within a team leading in the specification, development and implementation of a Hybrid on-premise and Azure cloud Data warehouse and reporting platform.
- Work closely with members of the Data & Analytics Team to proactively develop / improve the trusts Data Warehouse platform / function into a highly efficient architecture.
- Ensure you are proactive rather than reactive when there are issues within the data warehouse to be fixed in a timely manner & documented for future references.Comprehensive knowledge of Data Engineering products such as SSIS, SSRS, SQL to help triage and signpost solutions to customers, and potential issues to internal teams.
- Work closely with Senior Data Engineering Manager and team to identify risks and rectify them before they become an issue, particularly those that have a detrimental impact to patients, service users and Data Platforms reputation.
- Manage / Support the day-to-day operations of the trusts data warehouse solution both on-prem & MS Azure to ensure they are kept running without any errors through our BAU requests portal, dealing incidents & change through our Agile (Scrum) process, liaising with third-party vendors, internal & external teams to ensure business continuity.
- Design, implement, support, and continual improve the new Microsoft Azure based Data Warehouse, from bringing in new systems through to staging, data warehouse and reporting layer using the Kimball methodology within Data Factory / Pipeline process.
As a large NHS trust we are committed to enhancing the health of our local population by delivering consistently high standards of care and working closely with local authorities and key partners. We believe in our power and potential to make a difference and we’re always looking for people who demonstrate our three core values - care, appreciate and inspire – to join our team.
In return, we can offer you a job role with purpose and flexibility. The size and scale of the NCA means we can provide more challenge and opportunities so your career can always be moving in the right direction. By joining us you can also access a competitive benefits package, including, a fantastic annual leave allowance, flexible working opportunities and protected hours for health and wellbeing activities, helping you to achieve more personal downtime and a better work-life balance.
To read more information about the advertised role, and the main job duties/responsibilities please open the Job Description and Person Specification located under the supporting documents heading. You can also read more information about working at the Northern Care Alliance within the attached Candidate Information Pack or by visiting our careers website:http://www.careers.northerncarealliance.nhs.uk
This advert closes on Tuesday 4 Feb 2025