Data Warehouse Developer
Job summary
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:
o SQL Server
o Azure DevOps Services
o Visual Studio
o Power Bi
o 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:
o Experience of relational database design and architecture
o Experience of implementing and designing new ETL routines
o Experience with SQL, Python, PowerBI, SSIS
o 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.
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 . Visit beinlincolnshire.com to find out more.
Job description
Job 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
- 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
- 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
- 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
- Relevant IT Degree or equivalent experience
- Evidence of continuous professional development in relevant areas
- Relevant training in report building and business intelligence tools
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.
Employer details
Employer name
Lincolnshire Partnership NHS Foundation Trust
Address
Unit 9, The Point
Lions Way
Sleaford
NG34 8GG
United Kingdom
Employer's website
https://www.lpft.nhs.uk/