# Data Warehouse Developer > NHS job listing from Job Clerk for Lincolnshire Partnership NHS Foundation Trust. ## Canonical URLs - **HTML:** https://www.jobclerk.com/job/data-warehouse-developer/13926364-5fa5-4151-b75a-20703deceea5 - **Markdown:** https://www.jobclerk.com/job/data-warehouse-developer/13926364-5fa5-4151-b75a-20703deceea5.md ## Summary - **Status:** Live - **Employer:** Lincolnshire Partnership NHS Foundation Trust - **Location:** Unit 9, The Point - **Workplace type:** onsite - **Profession:** Administrative and IT - **Grade:** Band 6 - **Salary:** £39,959 - £48,117 per annum - **Contract type:** Permanent - **Employment type:** Full time, Flexible working, Home or remote working, 37.5 hours per week - **Closing date:** 2026-08-30T22:59:00.000Z - **Posted:** 2026-08-11T08:10:36.053Z - **Source information URL:** https://www.healthjobsuk.com/job/UK/Lincolnshire/Sleaford/Lincolnshire_Partnership_NHS_Foundation_Trust/Digital_Data_Services/Digital_Data_Services-v8206231 - **Application URL:** https://apps.trac.jobs/job-advert/8206231?ShowJobAdvert=&feedid=9002 - **Employer website:** https://www.lpft.nhs.uk ## Job Content ### 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. ## Documents - [lpft info (pdf, 44.6kb)](https://www.healthjobsuk.com/documents?edoc=2654) - [staff network (pdf, 321.8kb)](https://www.healthjobsuk.com/documents?ddoc=2459) - [functional requirements (pdf, 400.6kb)](https://www.healthjobsuk.com/documents?vdoc=10516119) - [data warehouse developer (pdf, 264.4kb)](https://www.healthjobsuk.com/documents?vdoc=10516118) - [tips for applicant success (pdf, 670.1kb)](https://www.healthjobsuk.com/documents?ddoc=2299) ## Agent Notes - This Markdown page is generated from the same Job Clerk job record as the HTML job detail page. - Use the canonical HTML URL for user-facing references. - Use the application URL when the user wants to apply on the source NHS site.