Job overview
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:
- SQL Server
- Azure DevOps Services
- Visual Studio
- Power Bi
- 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:
- Experience of relational database design and architecture
- Experience of implementing and designing new ETL routines
- Experience with SQL, Python, PowerBI, SSIS
- 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 in Sleaford with office locations around the county. There will be a requirement to attend the office base on some occasions.
Main duties of the job
Building and Maintaining Data Pipelines to support the accurate and timely flow of data in and out of the Trusts Data Warehouse
Management of existing databases and data structures to ensure data is stored efficiently and inline with Information Governance policy.
Design, code, test and implement efficient and robust database schemas, T- SQL Queries, views, stored procedures as part of Business.
Intelligence infrastructure development.
Building Integrations that support the transfer of data between systems and the Data Warehouse.
Working with other members of Data Services and wider stakeholders to help deliver data driven projects and onboarding of new systems
Adhere to robust change management procedures for data warehouse and EPR development, including but not limited to version control, writing of technical guidance and adoption of best practices.
Detailed job description and main responsibilities
Support the development, processing and storage requirements of NHS minimum data sets (MHSDS, CDS, IAPT MDS) including upgrades to new versions.
Serve as first point of escalation on user support issues and technical difficulties relating to Business Intelligence platform
Develops up to date technical documentation, specification and user guides in support of the applications
Provide mentorship and informal support to junior members of the team.
Working through product lifecycle to design, implement, maintain and improve on systems currently implemented and those planned in for the future.
Please view the attached Job Description and Person Specification documents for complete details regarding this post.
When completing your application, please demonstrate how you meet the role criteria.
We can also offer you many staff benefits to help support you which include:
- Early access to Psychological Therapies and Physiotherapy
- Competitive annual leave allowance
- Car leasing scheme
- NHS pension scheme
- Free eye tests
- Money saving options through our salary sacrifice scheme
- Discounts on major high street retailers and restaurants
Person specification
Experience
Essential
- 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
- 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
Qualifications
Essential
- Relevant IT Degree or equivalent experience
- Evidence of continuous professional development in relevant areas
- Relevant training in report building and business intelligence tools
Skills and Competences
Essential
- 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.
WhatsApp job alerts
Get instant WhatsApp alerts for Band 6 Administrative and IT roles in Sleaford
Create your Job Clerk account first. We'll collect your alert preferences during onboarding and help you turn on WhatsApp notifications for matching healthcare roles.
Applying for this NHS job
This advert is for Data Warehouse Developer with Lincolnshire Partnership NHS Foundation Trust in Unit 9, The Point. It is listed as a Band 6 Administrative and IT role. The advertised salary is £39,959 - £48,117 per annum. The contract type is Permanent. The application deadline is 30 Aug 2026.
Before you apply, compare the job description with the person specification and mirror the employer's essential criteria in your supporting information. Use the vacancy title, employer, location, salary, contract type, closing date and posted date (11 Aug 2026) to decide whether this role fits your current NHS job search. If the employer can close applications early, prepare the application before the stated deadline rather than waiting for the final day.
For more context, review related Job Clerk pages for the same profession, band or location where they exist, then use the application-support guides to tailor your statement and prepare for interview.