Job summary
Within Lincolnshire Partnership Foundation Trust, we are seeking to recruit a Data Warehouse Developer.
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 are essential
We will consider applicants without specific experience if you have a keen eye for data design and development.
No calls from recruitment agencies please.
Just to make you aware we are not accepting applications which are generated by AI.
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. We will consider both flexible working and condensed hours for this post.
Main duties of the job
You will be working alongside a developer in a busy Data Services Team and will be responsible for:
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
- SQL Server Reporting Services (SSRS)
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 heavily contribute to the maintenance and configuration of this platform allowing you to have a say in how our business data is consumed and presented.
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,900 staff, and serving a population of over 768,400, 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. 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 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.
Whether you're taking the first exciting steps in your career, itching for a new challenge or searching for a better place to raise a family, Lincolnshire has arange of rewarding health and social care careers in a county that's friendly, fascinating, affordable and brimming with everything you need to live a happy life.Visitbeinlincolnshire.comto find out more.
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 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.
Management 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.
Develop and maintain complex 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 in implementing 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
Develops 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 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.
Management 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.
Develop and maintain complex 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 in implementing 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
Develops 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
- 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
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.
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
Special Requirements
Essential
- Ability to travel to LPFT bases across the Trust at short notice and nationally for relevant training and user forums
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
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.
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
Special Requirements
Essential
- Ability to travel to LPFT bases across the Trust at short notice and nationally for relevant training and user forums
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.
