Warning
This job advert has expired and applications have closed.
Data Engineer | Central and North West London NHS Foundation Trust
| Posting date: | 04 June 2024 |
|---|---|
| Salary: | Not specified |
| Additional salary information: | £51,488 - £57,802 per annum inc. Inner HCAS (pro rata if P/T) |
| Hours: | Full time |
| Closing date: | 04 July 2024 |
| Location: | London, NW1 3AX |
| Company: | CNWL NHS Foundation Trust |
| Job type: | Contract |
| Job reference: | 6336380/333-C-HQ-0690 |
Summary
We're on the lookout for an experiencedData Engineerto join our vibrant Performance, Information & BI team. In this role, your responsibilities will include designing, implementing & optimizing data pipelines for loading & maintaining the data warehouse to support the Trust's data & analytics needs. Join us at this exciting time as we delve into new data driven projects & work towards modernizing our data warehouse.
The perfect fit for this role would have technical expertise in data engineering tools, strong data analysis skills, excellent problem-solving abilities & strong communication skills.
A successful candidate will have:
• Extensive experience in data engineering, with expertise in designing, building & maintaining data pipelines, data warehouses, and/or data lakes.
• Significant experience in using ETL tools such as SQL Server Integration Services (SSIS) or an equivalent ETL/ELT tool, as well as T-SQL querying abilities, including writing stored procedures, views, tables & database design.
• Experience working within the NHS or social care services, and/or knowledge of the key performance indicators for NHS & social care mental health services.
• Knowledge of data modelling, database design & data integration patterns, with familiarity with DevOps practices and tools for collaborative development, testing & deployment.
If you are passionate about data & want to advance your career in the NHS, we encourage you read the detailed Job Description attached & apply.
To assist in the design, implementation, and optimization of data pipelines to load and maintain the data warehouses, to support the Trust's data and analytics needs.
The post holder will be a technical expert in data engineering tools & practices and will drive the development of robust and scalable data architectures to enable advanced analytics & reporting capabilities across the organisation.
The post holder will be responsible for the development & deployment of the Trust’s data within the data warehouse environment, which consists of multiple SQL Server databases that capture data from the Trust’s multiple data sources including Clinical systems, Electronic Patient Record systems, Electronic Staff Records, Finance & other disparate internal and external data sources.
• Develop, test & implement solutions built in the SQL Server Environment and business intelligence (BI) reporting software ensuring that it meets the requirements of the end users & the Data Engineering team’s development standards.
• Supporting the development of technical BI skills across the wider Insight & Analytics department including, but not limited to T-SQL, ETL (SSIS and/or DTS) & Tableau.
• Work with the analytical teams & business users to develop high-quality data models for reporting & dashboarding purposes.
• Ensure data quality across the SQL platform by managing assurance & providing guidance to resolve data quality issues with regional partners & divisional teams.
At Central and North West London (CNWL) NHS Foundation Trust we’re passionate about delivering first-class patient-centred, safe and effective care, whether it is in a hospital setting, in a community clinic or the patient’s own home. Patients are at the heart of everything we do.
Providing top-quality care depends on our ability to employ the best people. We’re always looking to recruit outstanding people who will go the extra mile to support our patients, colleagues, teams and the Trust. With every new employee we’re hoping to find our future leaders and we’ll support our staff by providing opportunities to develop your career.
With a diverse culture and equally diverse range of opportunities across mental health, community services, addictions, eating disorders, learning disabilities and more – whatever stage of your career you're at, there's always a place for you at CNWL.
The successful applicant may have contact with patients or service users. As an NHS Trust we strongly encourage and support vaccination as this remains the best way to protect yourself, your family, your colleagues and of course patients and service users when working on our healthcare settings.
Job Summary
· Develop, test & implement solutions built in the SQL Server Environment and business intelligence (BI) reporting software ensuring that it meets the requirements of the end users and the Data Engineering team’s development standards.
· Supporting the development of technical BI skills across the wider Insight & Analytics department including, but not limited to T-SQL,ETL (SSIS and/or DTS) and Tableau.
· Work with the analytical teams and business users to develop high-quality data models for reporting and dashboarding purposes.
· Establish and manage metadata repositories to support development pipelines and processes.
· Ensure data quality across the SQL platform by managing assurance and providing guidance to resolve data quality issues with regional partners and divisional teams.
Information Management
· Take lead responsibility for ensuring that the key mandatory NHS national returns (CSDS, CDS, IAPT and MHSDS) are submitted in line with the requirements and timescales of NHS England.
· Manage the Trust’s NHS Dataset Change Notice (DSCN) Procedure and ensure that all relevant parties are notified as to the nature, impact and timetable for any changes.
· Keep abreast of all national reporting developments and respond appropriately to new and/or revised statutory reporting requirements.
· Reviewing the NHS England website for changes to dataset requirements regularly and ensuring that these changes are reflected appropriately in the Trust’s reporting.
Planning and Organisation
· Demonstrate and champion how the new the data engineering tools can be used to develop and run ‘intelligent information’ reports that draw upon, integrate, analyse and make links between different information sources to support more effective service planning, monitoring and delivery.
· Design, build, and maintain scalable data pipelines to ingest, transform, and load data from various sources (e.g., clinical systems, external data feeds) into the Trust's data platforms.
a. To develop and extend expertise in database design concepts and SQL server language, including T-SQL, ETL (SSIS and/or DTS) and Tableau.
b. To ensure high quality data warehouse security, putting in place robust security measures to allow adequate access for the required users whilst protecting sensitive patient-identifiable data.
· Develop expert understanding of the IT systems operated by CNWL with regard to data models and structures so as to facilitate work to develop new and more complex reporting objects that require effective and intelligent linkage between sources of information held on different systems.
· Ongoing requirement to act with minimum guidelines, setting standards for others, establishing how professional and administrative policies should be interpreted and implemented
· To provide training and demonstration and ensure provision and translation of complex analytical information to non-specialist users and provision of support in their understanding of the analysis
· Provision of technical support to business intelligence managers for the purpose of developing release schedules of required data items
· Ensure all documentation relating to own area is complete and fit for purpose and all releases are controlled.
· Lead in the development and maintenance of a culture of service provision and continuous improvement for own areas.
· Supporting team members to maintain an up to date knowledge and understanding of NHS information requirements and IT developments as they apply to Trust systems.
· Contribute to the strategic planning of team projects, identifying interdependencies across projects/functions, potential impacts on wider organisation, resource requirements and building in contingency and adjustments as necessary.
Collaboration
· Create strong and sustainable business relationships with senior colleagues both internally and externally. Establish and use a network of peers to ensure consistent and accurate information and approaches are used. Share and promote the sharing of information and knowledge.
· Coordinate discussion within the team to solve a problem and utilise the knowledge and experience of team colleagues.
· Participate and present in meetings as directed by BI colleagues, providing information advice and support where requested.
· Seek out development opportunities for you to learn, both as an individual and as a team, sharing your knowledge with your peers
· Working with and assisting Data Base Administrators (DBAs) ,to design and develop the
structure, procedures and functions of the Trust’s data warehouse data models.
Including data security, responsibility for the administration of permissions to the Trust’s
data warehouse datasets.
Learning and Development
· Provide ongoing support, training and guidance to key internal stakeholders (and, potentially, some external stakeholders) so that they are able to use the new BI system to build and run their own information reports, adjusting the information content, parameters and presentation so as best to meet their needs.
· Proactively identify appropriate training / development opportunities that could enhance the skills of the team to the benefit of the team’s stakeholders.
· Plan, develop and evaluate methods and processes for gathering, analysing, interpreting and presenting data and information.
Management and Leadership Responsibilities
· Develop and empower all members of your team to perform to high standards and innovate.
· Proactively participate in monthly 1:1 management supervision, annual objective setting and PDR / appraisal processes.
· Develop staff knowledge and skills to promote equality and diversity and address inequalities both in employment and service delivery. Ensure specific equality objective is included in PDRs.
· Develop a culture that ensures that the standards of Improving Working Lives and Investors in People are achieved and maintained for all staff and that staff’s perception about their working lives are measured and improvements made.
· Coordinate and ensure all aspects of work within the team (or project team) are well managed and delivered on time, helping to resolve day-to-day issues and provide immediate and detailed support to all levels within the team.
· Provide relevant and timely specialist advice and guidance on own portfolio of projects and analytical areas.
Rider Clause
This is an outline of the post holder’s duties and responsibilities. It is not intended as an exhaustive list and may change from time to time to meet the changing needs of the Trust and Department.
Each application will be reviewed by the interview committee and carefully shortlisted within two weeks of the submission deadline. We aim to review every application manually, without the use of ATS software so if we shortlist a sufficient number of candidates, we may close this posting before the deadline. If your application is shortlisted, you will be invited for a face-to-face interview, which may be followed by a coding test on the same day. Successful candidates will be contacted within a week of the interview date.
This advert closes on Tuesday 18 Jun 2024
Proud member of the Disability Confident employer scheme
Disability Confident
About Disability Confident
A Disability Confident employer will generally offer an interview to any applicant that declares they have a disability and meets the minimum criteria for the job as defined by the employer. It is important to note that in certain recruitment situations such as high-volume, seasonal and high-peak times, the employer may wish to limit the overall numbers of interviews offered to both disabled people and non-disabled people. For more details please go to Disability Confident.