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 of natural growth and progression, which 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 Team is not only transitioning to a state-of-the-art Azure data platform, but 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 trust’s new cloud-based data warehouse, alongside being responsible for the migration away from legacy\on-prem solutions and replacing them with state-of-the-art cloud-based technologies (Azure). You will also help to maintain & develop existing on-prem solutions.

Interviews to be held w/c 18th May

Main duties of the job

• You will be working within a team leading 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 trust’s 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 promptly & documented for future reference. Comprehensive knowledge of Data Engineering products such as SSIS, SSRS, and SQL to help triage and signpost solutions to customers, and potential issues to internal teams.
• Work closely with the Senior Data Engineering Manager and team to identify risks and rectify them before they become an issue, particularly those that have a detrimental impact on patients, service users, and the Data Platforms’ reputation.
• Manage / Support the day-to-day operations of the trust’s data warehouse solution, both on-prem & MS Azure, to ensure they are kept running without any errors through our BAU requests portal, dealing with incidents & change through our Agile (Scrum) process, liaising with third-party vendors, internal & external teams to ensure business continuity.
• Design, implement, support, and continually 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 the Data Factory / Pipeline process.