Job summary
We have a great opportunity within LPFT's Data Warehouse team.
Within Lincolnshire Partnership Foundation Trust, we are seeking to recruit a Data Warehouse Developer. You will be working as part of a small team in a busy environment and will be contribute towards:
The day-to-day management of the trust's data warehouse, using a mix of software solutions such as:
- SQL Server
- Azure DevOps Services
- Visual Studio
- Power Bi
The development of new processes and routines for existing and new data feeds
Development of complex data tables and storage mechanisms for large data sets.
As the organisation seeks to increase it data maturity and reporting capabilities, we are beginning our journey of moving to cloud hosting. This role will contribute to the configuration of this platform allowing you to have a say in how our business data is consumed and presented.
This post is available on a 12 month fixed term contract, this may lead to a permanent post in the future.
No calls from recruitment agencies please.
What we can offer: Job satisfaction and support to learn new skills.
We are currently operating a hybrid working model. Whilst the most of the time this post will be home based there will be an expectation that you are able to travel to our main base in Sleaford from time to time. There could also be opportunities to work at other Trust Locations with agreement from your Line Manager. This may be subject to change in the future.
Main duties of the job
The ideal candidate would have the following:
- Experience of relational database design and architecture
- Experience of implementing and designing new ETL routines
- Experience with Power BI and SSIS
- High level of T-SQL skills
We will consider applicants without specific experience if you have a keen eye for data design and development.
About us
Lincolnshire Partnership NHS Foundation Trust provides mental health services and a number of learning disability, autism and social care services in the county of Lincolnshire. Employing around 2,800 staff, and serving a population of over 766,000, our people lie at the heart of everything we do.
You could be part of a Trust rated by staff as one of the best mental health and learning disability trusts in England, in an area heralded as a fantastic place to live and work. We firmly believe the key to high quality care is a contented workforce. This is reflected in our Care Quality Commission rating of 'outstanding' for well-led and 'good' overall. In the most recent National NHS Staff Survey, our staff rated us as the number one trust nationally for staff morale and one of the top scoring NHS Trusts in the Midlands for being compassionate and inclusive. We're really proud of this!
We are also leading the way in transforming care, with multi-million-pound transformation of patient environments and radical redesign of community services.
This is the time to join and help redesign our services of the future. We offer options for flexible working and provide a wide range of training and promotion opportunities in all professions. We support and celebrate diversity, have active staff networks groups and are always looking at what more we can do to support our staff.
Job description
Job responsibilities
Supports the Senior Data Warehouse Developer in the overall design, technical development and documentation of the data warehouse infrastructure and bespoke ETL solutions covering multiple sources of data.
To carry out specific packages of work, with support, involving the design and development of reporting solutions with particular emphasis on T-SQL, Microsoft SSIS and Business Intelligence tools to meet the emerging needs of LPFT.
Contributing to the maintenance of existing databases and data structures to ensure data is stored efficiently and inline with Information Governance policy.
Using T-SQL, complex stored procedures, views to access data in the data warehouse and in EPR front end.
Review and maintain T-SQL scripts within the trusts EPR to support front end development.
Track down data related issues to their root cause, recommend fixes and be capable of implementing the required changes.
Design, code, test and implement efficient and robust database schemas, T- SQL Queries, views, stored procedures as part of Business Intelligence infrastructure development
Maintain an awareness of the latest software tools, keeping up to date with technological sources and innovations.
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
Liaise with third party IT service to provide support with back up, restoring, and disaster recovery and data warehouse server optimization
Perform strict quality and validation checks of the data sets that form part of the Business Intelligence solution, working closely with operational leads and Information Analysts and Performance team.
Work in collaboration with the Senior Data Warehouse Developer in the development and maintenance of the BI tools to allow the BI Team to create and share reports quickly and efficiently.
Support the development, processing and storage requirements of NHS minimum data sets (MHSDS, CDS, IAPT MDS) including upgrades to new versions.
Work with end users to develop new solutions and effectively communicate ideas across business and technical groups. Interpret complex technical issues and relay these to non/less technical staff/customers in an easily understandable format.
Serve as first point of escalation on user support issues and technical difficulties relating to Business Intelligence platform
Contributes to up-to-date technical documentation, specification and user guides in support of the applications
Prioritise workload, within agreed deadlines for regular data processing, internal and external reporting.
To be proactive in ensuring that good communications exist with customers, colleagues and third parties.
Job description
Job responsibilities
Supports the Senior Data Warehouse Developer in the overall design, technical development and documentation of the data warehouse infrastructure and bespoke ETL solutions covering multiple sources of data.
To carry out specific packages of work, with support, involving the design and development of reporting solutions with particular emphasis on T-SQL, Microsoft SSIS and Business Intelligence tools to meet the emerging needs of LPFT.
Contributing to the maintenance of existing databases and data structures to ensure data is stored efficiently and inline with Information Governance policy.
Using T-SQL, complex stored procedures, views to access data in the data warehouse and in EPR front end.
Review and maintain T-SQL scripts within the trusts EPR to support front end development.
Track down data related issues to their root cause, recommend fixes and be capable of implementing the required changes.
Design, code, test and implement efficient and robust database schemas, T- SQL Queries, views, stored procedures as part of Business Intelligence infrastructure development
Maintain an awareness of the latest software tools, keeping up to date with technological sources and innovations.
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
Liaise with third party IT service to provide support with back up, restoring, and disaster recovery and data warehouse server optimization
Perform strict quality and validation checks of the data sets that form part of the Business Intelligence solution, working closely with operational leads and Information Analysts and Performance team.
Work in collaboration with the Senior Data Warehouse Developer in the development and maintenance of the BI tools to allow the BI Team to create and share reports quickly and efficiently.
Support the development, processing and storage requirements of NHS minimum data sets (MHSDS, CDS, IAPT MDS) including upgrades to new versions.
Work with end users to develop new solutions and effectively communicate ideas across business and technical groups. Interpret complex technical issues and relay these to non/less technical staff/customers in an easily understandable format.
Serve as first point of escalation on user support issues and technical difficulties relating to Business Intelligence platform
Contributes to up-to-date technical documentation, specification and user guides in support of the applications
Prioritise workload, within agreed deadlines for regular data processing, internal and external reporting.
To be proactive in ensuring that good communications exist with customers, colleagues and third parties.
Person Specification
Experience
Essential
- Some experience in managing, designing, developing and querying large corporate databases
- Advanced T-SQL knowledge
- Experience with data warehousing in terms of design, structure and enhancement
- Working with a number of different applications such as SSIS. SSMS, Power B1 Desktop & Service
- Knowledge of ETL process and best practices
- 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
Shills 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.
- Ability to analyse, investigate and resolve complex information queries, detail oriented with strong problem-solving skills.
Desirable
- Experience of working with Power BI and the Power BI Service
Qualifications
Essential
- Relevant IT Degree or equivalent experience
- Evidence of continuous professional development in relevant areas
Desirable
- Relevant training in report building and business intelligence tools
Special Requirements
Essential
- Ability to travel to LPFT bases across the Trust at short notice and nationally for relevant training and user forums
- Ability to produce high quality work under pressure and to tight deadlines
- High levels of self-motivation and ability to take instruction
- Willingness to be flexible in approach in accordance with organisational need
- Participate in identification and evaluation of opportunities of improvement in the service
- Able to recognise limits of self and identify training and development needs
Person Specification
Experience
Essential
- Some experience in managing, designing, developing and querying large corporate databases
- Advanced T-SQL knowledge
- Experience with data warehousing in terms of design, structure and enhancement
- Working with a number of different applications such as SSIS. SSMS, Power B1 Desktop & Service
- Knowledge of ETL process and best practices
- 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
Shills 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.
- Ability to analyse, investigate and resolve complex information queries, detail oriented with strong problem-solving skills.
Desirable
- Experience of working with Power BI and the Power BI Service
Qualifications
Essential
- Relevant IT Degree or equivalent experience
- Evidence of continuous professional development in relevant areas
Desirable
- Relevant training in report building and business intelligence tools
Special Requirements
Essential
- Ability to travel to LPFT bases across the Trust at short notice and nationally for relevant training and user forums
- Ability to produce high quality work under pressure and to tight deadlines
- High levels of self-motivation and ability to take instruction
- Willingness to be flexible in approach in accordance with organisational need
- Participate in identification and evaluation of opportunities of improvement in the service
- Able to recognise limits of self and identify training and development needs
Disclosure and Barring Service Check
This post is subject to the Rehabilitation of Offenders Act (Exceptions Order) 1975 and as such it will be necessary for a submission for Disclosure to be made to the Disclosure and Barring Service (formerly known as CRB) to check for any previous criminal convictions.
