Data Engineer
Search here to find a new job, a new career, an opportunity
to up skill or to simply change your career direction.
Become part of our team.
We care for you as much as you care for others.
There’s a place for you at CNWL.
We’re passionate about delivering first-class patient-centred, safe and effective care, whether it is in a hospital setting, in a community clinic or in the patient’s own home. Patients are at the heart of everything we do.
Providing top quality care depends on our ability to employ the best people.
We’re always looking to recruit outstanding people who will go the extra mile to support our patients, colleagues, teams and the Trust. With every new employee we’re hoping to find our future leaders and we’ll support our staff by providing opportunities to develop your career.
With a diverse culture and equally diverse range of opportunities across mental health, community services, addictions, eating disorders, learning disabilities and more – whatever stage of your career you're at, there's always a place for you at CNWL.
Fraud alert: Please be cautious if you are asked for a fee at any stage in the recruitment process. CNWL does not charge fees for job applications, recruitment processes, sponsorship arrangements or employment offers. Always check with the recruitment contact or team if you are asked.
Main area Information and Performance Grade NHS AfC: Band 7 Contract 12 months (12 months Fixed Term (Secondment)) Hours
- Full time
- Flexible working
- Home or remote working
Site CNWL HQ Town London Salary £58,133 - £65,261 per annum inc HCAS (pro rata if P/T) Salary period Yearly Closing 19/08/2026 23:59
CNWL (Central and North West London NHS Foundation Trust) has almost 8,000 staff providing integrated healthcare to a third of London's population, Milton Keynes and areas beyond. We involve service users, carers, the public, staff and partner organisations in the way that we are run.
Our catchment area spans diverse communities, with over 100 first languages spoken. It contains areas of great affluence as well as areas of much deprivation. We are committed to providing services that meet the needs of the people who use them, and we actively encourage involvement from local people who can help make a difference. We’re proud of our diversity and we continue to undertake new initiatives to advance equality for LGBT+, BME and people with disabilities to promote good relations and understanding between our staff.
We are recognised locally, nationally and internationally for providing high quality, innovative healthcare. We aim to employ only the best people, and our experts are frequently called upon to contribute to national health strategy and policy, and many models of our care have been adapted for use in other countries.
We offer a generous relocation package (subject to eligibility assessment) and flexible working options, including bank assignments for most roles. For more information on these and other benefits of working for us, see our Benefits, Reward and Wellbeing page
Become part of our team. We care for you as much as you care for others.
CNWL NHS Foundation Trust are committed to safeguarding all children and vulnerable adults and expect all staff and volunteers to share this commitment. We follow safe recruitment practices to protect children and vulnerable adults.
Job overview
To assist in the design, implementation, and optimization of data pipelines to load and maintain thedatawarehouses,to support theTrust'sdata and analytics needs.
The post holder will be a technical expert in data engineering tools and practices and will drive the development of robust and scalable data architectures to enable advanced analytics and reporting capabilities across the organization.
The post holder will be responsible for the development and deployment of the Trust’s data within the data warehouse environment, which consists of multiple SQL Server databases that capture data from the Trust’s multiple data sources including Clinical systems, Electronic Patient Record systems, Electronic Staff Records, Finance, and other disparate internal and external data sources.
Main duties of the job
Job Summary
· Develop, test & implement solutions built in the SQL Server Environment and business intelligence (BI) reporting software ensuring that it meets the requirements of the end users and the Data Engineering team’s development standards.
· Supporting the development of technical BI skills across the wider Insight & Analytics department including, but not limited to T‑SQL, ETL Tools (SSIS, Python or dbt) and Visualisation (Tableau, Power BI).
· Work with the analytical teams and business users to develop high-quality data models for reporting and dashboarding purposes.
· Establish and manage metadata repositories to support development pipelines and processes.
· Ensure data quality across the data platform by managing assurance and providing guidance to resolve data quality issues with regional partners and divisional teams.
· Support the Data Platform Modernisation (DPM) Programme, including migration of data pipelines, models and reporting objects from SQL Server to Snowflake, and contribute to Data Quality Improvement Project deliverables
Working for our organisation
Are you looking for an exciting opportunity to develop your data engineering skills while helping shape the future of healthcare analytics?
We are seeking a motivated individual to join our Central Business Intelligence (BI) Data Engineering Team on a 12-month development secondment. This is an excellent opportunity to gain hands‑on experience working with both our established SQL Server data warehouse and modern cloud platform as we migrate to Snowflake.
Working alongside experienced Data Engineers, you will help develop and maintain data pipelines and warehouse solutions that support reporting and analytics across the Trust. You’ll gain exposure to clinical, operational and corporate data while developing experience in enterprise data architecture and information management.
As part of the role, you will contribute to the Trust’s Data Platform Modernisation Programme, developing skills in SQL, ETL/ELT, Python, dbt and cloud technologies. You will also support the development of key National Operating Framework (NOF) metrics and nationally mandated datasets, gaining experience in NHS performance reporting.
This secondment offers an opportunity to broaden your technical expertise, work on transformation projects and develop the skills needed for the next stage of your career within a supportive and collaborative team.
If you are looking to challenge yourself, gain valuable experience and make a meaningful contribution across CNWL, we would love to hear from you.
Detailed job description and main responsibilities
Please note:This vacancy doesnotmeet the criteria for Skilled Worker sponsorship, unless you meet the criteria by temporary exemption from current changes to immigration rules put in force on 22/07/2025. “Separate provisions are applied to workers who have been sponsored and held continuously Skilled Worker visa since prior to 04/04/2024.