Senior BI Developer

Job Reference: 351-CS969-SD-C
Lancashire Care NHS Foundation Trust Department:
Business Intelligance Location:
L7F9 L9329 Planning & Performance, Trust HQ, Sceptre Point
31,696 to 41,787 pa
Lancashire Care NHS Foundation Trust is a great place to work and has a sound future as a leading provider of excellent services. The Trust invests in its staff and seeks to provide them with opportunities for training and personal development.
Lancashire Care NHS Foundation Trust was established in April 2002 and authorised as a Foundation Trust on 1st December 2007. The Trust provides health and wellbeing services for a population of around 1.5million people. The services provided include community nursing, health visiting and a range of therapy services including physiotherapy, podiatry and speech & language. The Trust specialises in inpatient and community mental health services. Lancashire Care NHS Foundation Trust covers the whole of the county and employs around 7,000 members of staff across more than 400 sites.
Lancashire Care NHS Foundation Trust is currently implementing a programme of transformation underpinned by technology. The performance & information department is at the forefront of enabling this transformation and has a bold and exciting strategy to deliver innovative business intelligence and information solutions to support clinicians and service users.
To help us develop the information infrastructure we are looking to recruit a Senior Business Intelligence Developer post to be part of the Business Intelligence team working with Microsoft BI tools to develop the Trust data warehouse and business intelligence platform
This is an exciting opportunity for a highly motivated candidate to join the BI Team with responsibility for the daily operational support and development of the Trusts in house data warehouse and BI systems.
You will support the new EPR Project (RIO) that is rolling out a new Clinical system throughout the Trust, with Data warehouse and Reporting Solutions.
Working closely with other BI developers and the information analysts you will be expected to translate internal and external business requirements into BI solutions using the Microsoft BI stack.
Please also note that the BI Team operates a Flexible Agile working Policy, including remote working via Skype/VPN.
You will need to be educated to degree level or be able to demonstrate the appropriate level of experience and knowledge. You will need an in depth knowledge of Microsoft SQL server 2008/2012 (Reporting Services, Integration Services, Analysis Services). Being skilled in the practical applied knowledge of using SQL/T-SQL is also essential.
You will need to have significant experience of developing business intelligence solutions, leading BI projects, developing regular information/reports/datasets and demonstrable experience of developing BI solutions that meet customer requirements.
Interviews will provisionally take place on Monday 16th July 2018. If you are not invited to interview within a week of the closing date then please assume that on this occasion you have been unsuccessful, as it is not possible to contact all unsuccessful candidates. It is important that applicants log in to the website and check their NHS Jobs account on a regular basis to read and respond to any emails they may have received. If you do not have regular access to email/internet please advise the team of suitable contact details.
For further details / informal visits contact:
For an informal discussion please contact Dean Wild on 01772 773829 or Michael Lally on 01772 773839
Please ensure that you read the Person Specification attached below as your application will be measured against this document. Applications from job share partners are welcome and other forms of flexible working will be considered for all posts.
For all posts which require a Disclosure & Barring Service (DBS) check please be aware of the DBService Code of Practice, a copy of which is available by logging on to the DBS website.
You are advised to consider applying for LCFT vacancies as soon as possible as in some instances vacancies are closed as soon as a sufficient number of applications have been received. If you are not invited to interview within 3 weeks of the closing date then please assume that on this occasion you have been unsuccessful, as it is not possible to contact all unsuccessful candidates.
We welcome applications from people regardless of age, disability (especially people who have experience of accessing mental health, or Learning Disability Services or caring for someone who has accessed mental health services or Learning Disability Services), ethnicity, gender, religion or belief or sexual orientation.
After applying via NHS Jobs, your submitted application will be imported into our preferred Third-party recruitment system – TRAC systems. All subsequent information regarding your application will be generated from You will not be able to track the progress of your application or receive messages through the NHS Jobs website, and furthermore, as an employer, we will not be able to respond to any e-mails sent to us via the NHS Jobs website. By applying for this post, you are agreeing to LCFT transferring the information contained in this application to its preferred applicant management system. If you are appointed to a post information will also be transferred into the national NHS Electronic Staff Records system
Tier 2 Certificate of Sponsorship
Applications from job seekers who require Tier 2 sponsorship to work in the UK are welcome and will be considered alongside all other applications. However, non-EEA candidates may not be appointed to a post if a suitably qualified, experienced and skilled EU/EEA candidate is available to take up the post as the employing body is unlikely, in these circumstances, to satisfy the Resident Labour Market Test. The UK Visas and Immigration department requires employers to complete this test to show that no suitably qualified EEA or EU worker can fill the post. For further information please visit the UK Visas and Immigration website.
From 6 April 2017, Tier 2 skilled worker applicants, applying for entry clearance into the UK, must present a criminal record certificate from each country they have resided continuously or cumulatively for 12 months or more in the past 10 years. Adult dependants (over 18 years old) will also be subject to this requirement.
Guidance can be found here Criminal Records Checks For Overseas Applicants
To stay safe in your job search we recommend that you visit SAFERjobs (, a non-profit, joint industry and law enforcement organisation working to combat job scams. Visit the SAFERjobs website for information on common scams and to get free, expert advice for a safer job search.