Job summary
Are you an established Senior Data Engineer who has worked as part of a delivery team looking to work from home and further develop in an outstanding rated Trust? Our development team are looking for an experienced Data Engineer to join them.
As a Senior Data Engineer you will play a key role in developing and maintaining the Trusts data pipelines and data warehouse in line with the business intelligence strategy. You will be responsible for mapping system requirements, and translating these into technical specifications, designing data models and delivering these using an Agile project management methodology.
You will have a full logical, problem-solving mindset and be familiar with on premise server infrastructure as well as awareness of Cloud computing techniques and technologies. The Data Engineer post is a full time, 18-month fixed term position. We would be flexible and welcome part time applications with a minimum of 30 hours. This is a working from home role where we would support national applications.
Using the Microsoft technologies, you will be required to work both independently, and within a team to deliver various project solutions of various sizes and complexities within the envelope of sprints.
For any queries, please contact lee.davies16@nhs.net
Main duties of the job
You will be joining a small development team who together deliver the Trusts data warehouse solution and BI Reporting platform. This is used widely across the Trust to enable data driven decision making from Board level to operational user. As a Senior Data Engineer you will be responsible for running a small project team to deliver set projects.
Design, develop and maintain efficient extract, transform and load pipelines from source systems to the data warehouse.
Form part of the team responsible for the ongoing maintenance and monitoring of the data warehouse ensuring high availability for end users and analysts. Provide technical solutions and data models to enhance the Trusts Data Warehouse and Business Intelligence solutions. Development of statutory returns, standard and bespoke reports utilising data warehouse and data feeds.
Maintain technical, professional and specialist knowledge and understanding -and be competent in the use of a wide range of specialist software packages and programming languages including but not limited to Microsoft SQL Server, T-SQL, SQL Server Integration Services, Azure, Azure Data Factory, Azure Databricks, Azure Synapse, Python and Microsoft Power BI.
Ensure data security, data quality, integrity and compliance are considered at all times, implement high quality solutions which meet project success criteria and support requirements.
About us
At Dorset HealthCare we're on a mission to empower people to make the most of their lives through our outstanding, joined-up healthcare services. We're a dynamic, forward-looking Trust, running 12 community hospitals, specialist inpatient facilities and a wide range of integrated community and mental health services for a population of almost 800,000 people.
We do things differently here - it's one of the reasons the CQC rated us 'outstanding' in 2019. It's also why 95% of patients across our services say they have a good or very good experience of our services and 89% of staff feel they can really make a difference. Whether you're looking to work with us in one of our bustling market towns, vibrant urban locations, thriving seaside spots, or among the rolling hills of Dorset, there are lots of ways you can make a difference in our communities.
Our 7,000-strong workforce is at the heart of what we do and our success is a testament to our brilliant people. We're all about building a workplace for the future, we believe in equal opportunities and we celebrate diversity. We're an inclusive workplace, where everyone is welcome, everyone can be authentic, and we are all encouraged to be the best version of ourselves.
Working with us you'll be part of a strong team, challenge yourself, build a career, and teach us what we don't know. And you'll be working towards our vision to be better every day through excellence, compassion and expertise in all we do.
Job description
Job responsibilities
You will be involved in the process of recommending and implementing strategic improvements to streamline and enhance existing processes and systems, promoting greater efficiency and effectiveness within the DHC Business Intelligence team. Help to determine and implement improvements to data processing and information reporting systems.
For the main duties and responsibilities for this role please read the attached job description and person specification. When completing your application please ensure your supporting statement reflects the criteria set out in these documents by showing how your experience and skills apply to this post.
As part of our vision to have a skilled, diverse and caring workforce, Dorset HealthCare is working in partnership with The Princes Trust to support people getting into work, as part of this partnership, we are offering an employability service to support individuals between 16-30 years old with application writing, interview skills and other employment support. If you would like or know of anyone who would value this support please do contact dhc.wideningparticipation@nhs.net
This is a fixed term role and for those with current NHS service, the role will be offered on a secondment basis only. Please obtain permission to be released on a secondment before submitting an application.
Job description
Job responsibilities
You will be involved in the process of recommending and implementing strategic improvements to streamline and enhance existing processes and systems, promoting greater efficiency and effectiveness within the DHC Business Intelligence team. Help to determine and implement improvements to data processing and information reporting systems.
For the main duties and responsibilities for this role please read the attached job description and person specification. When completing your application please ensure your supporting statement reflects the criteria set out in these documents by showing how your experience and skills apply to this post.
As part of our vision to have a skilled, diverse and caring workforce, Dorset HealthCare is working in partnership with The Princes Trust to support people getting into work, as part of this partnership, we are offering an employability service to support individuals between 16-30 years old with application writing, interview skills and other employment support. If you would like or know of anyone who would value this support please do contact dhc.wideningparticipation@nhs.net
This is a fixed term role and for those with current NHS service, the role will be offered on a secondment basis only. Please obtain permission to be released on a secondment before submitting an application.
Person Specification
Knowledge, Skills and Training
Essential
- Graduate with high level of numeracy
- Educated to degree level in computer or information science
- Educated to master's level or equivalent level of experience of working at a senior level in specialist area.
Desirable
- Evidence of continuous personal and professional development
- Experience of Agile methodologies
- ITIL
Job Specific Experience
Essential
- Proven experience in developing ETL solutions
- Good understanding of Data Quality and ability to develop data quality reporting mechanism
- Experience of being the lead on small project
Desirable
- Knowledge and experience of developing and implementing Power BI reporting solutions
- Knowledge and experience of the Power Platform
- Knowledge and experience in cloud development (Azure)
Managerial/Supervisory Experience
Essential
- Willingness and ability to share knowledge/train staff to a high level in their area of specialist knowledge
- Understand the strategic vision and be able to articulate that vision to other staff and colleagues
Desirable
- Experience of running a team of developers/data engineers or equivalent
Information Technology/ Resources
Essential
- Excellent all-round IT skills
- Knowledge and experience in the full Microsoft Microsoft Stack Primarily SQL, SSIS, SSAS
- Knowledge and experience of working with large scale complex datasets
- Knowledge and experience in Dev Ops
Desirable
- Awareness of PRINCE2 project management methodology
- Knowledge and experience of the SharePoint
- Knowledge and experience of Teamworks
Person Specification
Knowledge, Skills and Training
Essential
- Graduate with high level of numeracy
- Educated to degree level in computer or information science
- Educated to master's level or equivalent level of experience of working at a senior level in specialist area.
Desirable
- Evidence of continuous personal and professional development
- Experience of Agile methodologies
- ITIL
Job Specific Experience
Essential
- Proven experience in developing ETL solutions
- Good understanding of Data Quality and ability to develop data quality reporting mechanism
- Experience of being the lead on small project
Desirable
- Knowledge and experience of developing and implementing Power BI reporting solutions
- Knowledge and experience of the Power Platform
- Knowledge and experience in cloud development (Azure)
Managerial/Supervisory Experience
Essential
- Willingness and ability to share knowledge/train staff to a high level in their area of specialist knowledge
- Understand the strategic vision and be able to articulate that vision to other staff and colleagues
Desirable
- Experience of running a team of developers/data engineers or equivalent
Information Technology/ Resources
Essential
- Excellent all-round IT skills
- Knowledge and experience in the full Microsoft Microsoft Stack Primarily SQL, SSIS, SSAS
- Knowledge and experience of working with large scale complex datasets
- Knowledge and experience in Dev Ops
Desirable
- Awareness of PRINCE2 project management methodology
- Knowledge and experience of the SharePoint
- Knowledge and experience of Teamworks
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.
