Job summary
You will work under the remit of the Head of Data Engineering as part of the Digital Directorate and will be a key member of the Data Engineering team working primarily on day to day ETL operations, as-well as working with the wider Performance Team and Digital Team to meet the data management needs of the Trust.
As a Data Engineer you will be fundamental in developing and constructing data models for our services data warehousing needs as-well as integrating them into systems and business processes to support self-serve reporting, compliance reporting and third-party data integrations.
You will provide specialist advice across a range of IM&T areas e.g. applications, information interpretation, data analysis, information reporting, information governance.
You will investigate a range of specialist or complex IM&T issues and be responsible for strategic planning within specialised areas.
You may need to analyse complex data and produce information reports or develop and deliver specialised training or design, develop, adapt complex software / web pages / information reports.
You may manage an IM&T project or develop training programmes.
Please see the attached job description for full details.
Main duties of the job
Key Responsibilities
You will report to a Lead Data Engineer and/or the Head of Data Engineering and have personal responsibility for:
- implementing data flows to connect operational systems, data for analytics and business intelligence (BI) systems
- document source-to-target mappings
- re-engineer manual data flows to enable scaling and repeatable use in an automated way
- support the build of data streaming systems
- write ETL scripts and code to make sure the ETL process performs optimally
- build accessible data for analysis
In order to fulfil these responsibilities, you will require specialist knowledge across range of procedures underpinned by theory Specialist knowledge and expertise across one or more specialised areas, acquired through degree level or equivalent qualification/ industry experience plus additional specialist knowledge.
Main Tasks
You will gain exposure to a number of databases / datasets within the Trust and will deal with NHS specific Datasets at both a local and national level requiring sensitivity and information governance controls to be upheld.
In this role, your primary focus will be all about Data, and treating it with a level of sophistication and clarity at all levels, ensuring where possible that quality and completeness is high and made available in an appropriate manner to those that require it.
About us
We are the main provider of NHS community services across East and West Sussex. Our 6,000 staff serve a population of 1.3 million providing essential medical, nursing, and therapeutic care to adults and children.
Our Trust vision is to provide excellent care at the heart of the community, helping people plan, manage, adapt to changes in their health, supporting avoidable hospital admissions and reducing hospital stay times.
We have opportunities for everyone across our wide variety of services including medical, clinical, support and corporate services.
Why work for us?
- Positive 2023 NHS Staff Survey results, scoring highly in compassionate culture & leadership, and staff wellbeing support
- Variety of working environments across the community, in patients' homes, within our community hospitals and bases across the county
- Supportive flexible working patterns such as: part time, flexi time, annualised hours, and flexi retirement options
- Excellent training and development opportunities
- Research opportunities
- Cost-effective workplace nurseries in Crawley, Hove and Brighton
- Thriving BAME, Disability and Wellbeing, LGBT+ and Religion and Belief staff networks
- Level 3 accredited Disability Confident Leader, committed to creating inclusive workplaces
- Veteran Aware Trust, achieving accreditation from Veterans Covenant Healthcare Alliance (VCHA)
- Located in stunning Sussex, with easy access to the South Downs and the coast
- Access to a wide range of benefits and discounts for NHS staff
Job description
Job responsibilities
You will gain exposure to a number of databases / datasets within the Trust and will deal with NHS specific Datasets at both a local and national level requiring sensitivity and information governance controls to be upheld.
In this role, your primary focus will be all about Data, and treating it with a level of sophistication and clarity at all levels, ensuring where possible that quality and completeness is high and made available in an appropriate manner to those that require it.
Your main tasks in this role are defined as follows:
Communicating with Stakeholders
You will provide and receive highly complex, sensitive or contentious information; agreement or co-operation required; present complex, sensitive or contentious information to large groups. You will communicate to a range of IM&T issues which can be complex and multi-stranded. You will need to negotiate on priorities on e.g. IT training, system design and development, reporting processes with non IM&T managers; along with training or presenting on complex IM&T issues.
You will be expected to allocate work; train other IM&T staff/delivers training in own specialism to other staff and organisations
Data analysis and synthesis
You will undertake data profiling and source system analysis and can present clear insights to colleagues to support the end use of the data.
You will deal with Complex facts or situations requiring analysis, interpretation and comparison of a range of options. Analyses, investigates and resolves complex IM&T queries and issues/problems e.g. System errors, breaches of security or confidentiality, user requirements which may require configuration of software and hardware, unusual data trends, training requirements based on needs analysis.
Data development
Design and develop major information systems to meet specification of others Responsible for the planning, development, review, update, upgrade and introduction of major new IM&T systems to meet user requirements. e.g. Redevelopment of aspects of patient care system, business systems, infrastructure, information systems.
Data innovation
You will seek out opportunities for innovation with new tools and the use of data and plan and organise a broad range of complex activities; formulate, adjust plans or strategies, plan specialist projects which impact across clinical and non clinical areas. E.g. Plan training delivery for a team of trainers or for a new system.
Data integration design
You will deliver data solutions in accordance with agreed organisational standards that ensure services are resilient, scalable and future proof.
Data modelling
With your understanding of the concepts and principles of data modelling, you will produce, maintain and update relevant data models for specific business needs. You will know how to reverse-engineer data models from a live system.
Metadata management
You will work with metadata repositories to complete complex tasks such as data and systems integration impact analysis. You will assist in maintaining a repository to ensure information remains accurate and up to date.
Problem resolution (data)
Being aware about the types of problems in databases, data processes, data products and services, you will debug and unpack errors raised within our manual and automated processes.
Programming and build (data engineering)
You will design, code, test, correct and document simple programs or scripts under the direction of others using T-SQL, Store Procedures, Basic C# and or low-code tooling.
You will have developed physical skills; advanced keyboard use; highly developed physical skills, accuracy important; manipulation of fine tools, materials. Inputting and manipulating data, information into computer databases, system; uses fine tools when working on IM&T systems
Testing
You will regularly design, code and execute test scripts to support ETL processes defined within our platforms
In addition to the day to day aspects of your role you will also have a responsibility to:
- Contribute to the development, migration and implementation of our Data Warehousing Solutions as they evolve and modernise over time.
- Participate in the planning sessions of business as usual work and in-flight projects
- Assist Senior and Lead Engineers in meeting our requirements for commissioner and national submissions within agreed timescales
- Attendance of meetings as and when required in relation to departmental modernisation, business critical system changes / issues, as-well as providing technical and non-technical advice on request.
- On occasion, to commit to out of hours work for key migrations, and or manual modifications to systems / datasets to minimise critical business disruption.
- Monitor scheduled jobs for failures, escalate and work with Senior or Lead Data Engineers to resolve.
- Undertake other duties commensurate with the role.
Job description
Job responsibilities
You will gain exposure to a number of databases / datasets within the Trust and will deal with NHS specific Datasets at both a local and national level requiring sensitivity and information governance controls to be upheld.
In this role, your primary focus will be all about Data, and treating it with a level of sophistication and clarity at all levels, ensuring where possible that quality and completeness is high and made available in an appropriate manner to those that require it.
Your main tasks in this role are defined as follows:
Communicating with Stakeholders
You will provide and receive highly complex, sensitive or contentious information; agreement or co-operation required; present complex, sensitive or contentious information to large groups. You will communicate to a range of IM&T issues which can be complex and multi-stranded. You will need to negotiate on priorities on e.g. IT training, system design and development, reporting processes with non IM&T managers; along with training or presenting on complex IM&T issues.
You will be expected to allocate work; train other IM&T staff/delivers training in own specialism to other staff and organisations
Data analysis and synthesis
You will undertake data profiling and source system analysis and can present clear insights to colleagues to support the end use of the data.
You will deal with Complex facts or situations requiring analysis, interpretation and comparison of a range of options. Analyses, investigates and resolves complex IM&T queries and issues/problems e.g. System errors, breaches of security or confidentiality, user requirements which may require configuration of software and hardware, unusual data trends, training requirements based on needs analysis.
Data development
Design and develop major information systems to meet specification of others Responsible for the planning, development, review, update, upgrade and introduction of major new IM&T systems to meet user requirements. e.g. Redevelopment of aspects of patient care system, business systems, infrastructure, information systems.
Data innovation
You will seek out opportunities for innovation with new tools and the use of data and plan and organise a broad range of complex activities; formulate, adjust plans or strategies, plan specialist projects which impact across clinical and non clinical areas. E.g. Plan training delivery for a team of trainers or for a new system.
Data integration design
You will deliver data solutions in accordance with agreed organisational standards that ensure services are resilient, scalable and future proof.
Data modelling
With your understanding of the concepts and principles of data modelling, you will produce, maintain and update relevant data models for specific business needs. You will know how to reverse-engineer data models from a live system.
Metadata management
You will work with metadata repositories to complete complex tasks such as data and systems integration impact analysis. You will assist in maintaining a repository to ensure information remains accurate and up to date.
Problem resolution (data)
Being aware about the types of problems in databases, data processes, data products and services, you will debug and unpack errors raised within our manual and automated processes.
Programming and build (data engineering)
You will design, code, test, correct and document simple programs or scripts under the direction of others using T-SQL, Store Procedures, Basic C# and or low-code tooling.
You will have developed physical skills; advanced keyboard use; highly developed physical skills, accuracy important; manipulation of fine tools, materials. Inputting and manipulating data, information into computer databases, system; uses fine tools when working on IM&T systems
Testing
You will regularly design, code and execute test scripts to support ETL processes defined within our platforms
In addition to the day to day aspects of your role you will also have a responsibility to:
- Contribute to the development, migration and implementation of our Data Warehousing Solutions as they evolve and modernise over time.
- Participate in the planning sessions of business as usual work and in-flight projects
- Assist Senior and Lead Engineers in meeting our requirements for commissioner and national submissions within agreed timescales
- Attendance of meetings as and when required in relation to departmental modernisation, business critical system changes / issues, as-well as providing technical and non-technical advice on request.
- On occasion, to commit to out of hours work for key migrations, and or manual modifications to systems / datasets to minimise critical business disruption.
- Monitor scheduled jobs for failures, escalate and work with Senior or Lead Data Engineers to resolve.
- Undertake other duties commensurate with the role.
Person Specification
Qualifications
Essential
- Educated to A level in a Computing / IT related subject or equivalent work experience
- Test criteria
Desirable
- Certifications in Microsoft Stack (SQL Server, Azure, .NET)
- Certifications in Qlik Analysis Tooling
Experience
Essential
- A minimum of 2 years' experience of managing and maintaining a data warehouse within a large organisation
Experience
Essential
- Experience of developing a Data Warehouse to optimise performance
Skills and Knowledge
Essential
- You should possess strong in-depth knowledge of: -CSV, XML, JSON
Person Specification
Qualifications
Essential
- Educated to A level in a Computing / IT related subject or equivalent work experience
- Test criteria
Desirable
- Certifications in Microsoft Stack (SQL Server, Azure, .NET)
- Certifications in Qlik Analysis Tooling
Experience
Essential
- A minimum of 2 years' experience of managing and maintaining a data warehouse within a large organisation
Experience
Essential
- Experience of developing a Data Warehouse to optimise performance
Skills and Knowledge
Essential
- You should possess strong in-depth knowledge of: -CSV, XML, JSON
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.
