Data Warehouse Developer
At a glance
- Band
- Band 6
- Contract
- Permanent
- Pattern
- Full-time, Flexible working, Home or remote working
- Posted
- 11/08/2026
- Closes
- 30/08/2026
Sponsorship verdict
Sponsorship is not clearly stated in this advert.
The advert didn't contain a clear role-specific sponsorship line, so HiveMind can't confirm eligibility. Verify with the recruiting manager or trust HR before you apply.
Role summary
This role is for a Data Warehouse Developer within LPFT's Data Warehouse team. You will be responsible for maintaining the trust's data warehouse, building and maintaining data pipelines, and managing existing databases and data structures. The position involves designing, coding, testing, and implementing database schemas and T-SQL queries, as well as building integrations between systems. You will contribute to improving data quality and the organisation's data maturity.
Essential criteria
- Extensive experience in managing, designing, developing and querying large corporate databases
- Extensive T-SQL knowledge
- Proven experience with data warehousing in terms of design, structure and enhancement
- Working with a number of different applications such as SSIS, SSMS, Power BI Desktop & Service
- Knowledge of ETL process and SSIS
- Interpreting user requirements to develop effective business solutions
Desirable criteria
- Experience working in Informatics
- Experience of working with complex datasets
- Experience of working within NHS Mental Health Services
- Experience of working with Trust specific EPR (Currently RiO - Mental Health).
- Experience of working in an Azure Environment
- Skills and Competences
- Demonstrated skills in Microsoft T-SQL development and working knowledge of data presentation and data warehousing.
- Strong database management skills using TSQL and SSIS.
- Experience data visualisation tools like SSRS
- Ability to analyse, investigate and resolve complex information queries, detail oriented with strong problem-solving skills.
- Relevant IT Degree or equivalent experience
- Evidence of continuous professional development in relevant areas
- Relevant training in report building and business intelligence tools
- Extensive experience in managing, designing, developing and querying large corporate databases
- Extensive T-SQL knowledge
- Proven experience with data warehousing in terms of design, structure and enhancement
- Working with a number of different applications such as SSIS, SSMS, Power BI Desktop & Service
- Knowledge of ETL process and SSIS
- Interpreting user requirements to develop effective business solutions
- Experience working in Informatics
- Experience of working with complex datasets
- Experience of working within NHS Mental Health Services
- Experience of working with Trust specific EPR (Currently RiO - Mental Health).
- Experience of working in an Azure Environment
- Skills and Competences
- Demonstrated skills in Microsoft T-SQL development and working knowledge of data presentation and data warehousing.
- Strong database management skills using TSQL and SSIS.
- Experience data visualisation tools like SSRS
- Ability to analyse, investigate and resolve complex information queries, detail oriented with strong problem-solving skills.
- Relevant IT Degree or equivalent experience
- Evidence of continuous professional development in relevant areas
- Relevant training in report building and business intelligence tools
Useful to know
Agenda for Change 2024/25 pays Band 6 at £37,338 – £44,962 a year, across England.
This advert: £39,959 – £48,117 — outside the standard scale; check for HCAS/London weighting.
Posted 19d ago · Closes in 1d
Applications close soon — apply now if this is a fit.
Full advert · preview
Lincolnshire Partnership NHS Foundation Trust
Data Warehouse Developer
The closing date is 30 August 2026
Job summary
We have a great opportunity within LPFT's Data Warehouse within Lincolnshire Partnership Foundation Trust. You will be working alongside a developer in a busy Data Services Team and will be responsible for:
The maintenance of the trust's data warehouse, using a mix of software solutions such as:
o SQL Server
o Azure DevOps Services
o Visual Studio
o Power Bi
o Python
As the organisation seeks to increase it data maturity and reporting capabilities, further integration work is being undertaken between the different systems to improve data quality. This role will heavily contribute to the maintenance and configuration of these integrations allowing you to have a say in how our business data is consumed and presented.
You should possess the following:
o Experience of relational database design and architecture
o Experience of implementing and designing new ETL routines
o Experience with SQL, Python, PowerBI, SSIS
o Good communication and team working skills
We will consider applicants without specific experience if you have a keen eye for data design and development.
No calls from recruitment agencies please.
What we can offer: Job satisfaction and support to learn new skills. Hybrid working is available (home and office working) and the main base is i
Join the community to read the full pack, responsibilities and person-specification in one place.
Your seat is reserved — activate it
CareerHive is included with your CareerHive Skool community membership. If you haven't claimed your account yet, join the community (or sign in with the same email you joined with) to unlock the full advert, the apply link, HiveMind AI interview & application suite, your private vault, and daily sponsorship alerts.