Data Engineer

Job description

Job responsibilities

Directorate:

Finance

Job Title:

Data Engineer

Pay Band:

6

Base and Service:

Working from Home / Office usage as required Business Intelligence

Reports to (Line Manager):

Lead Data Engineer

Accountable to (Professionally/managerially):

Performance and Information Manager

Dimensions and Context of Role:

Business Intelligence is responsible for the development and delivery of all Information systems within the organisation. The teams primary function is to supply senior managers and executives with the information they require to make sound business decisions that will improve the effectiveness of all services. In addition the team support various operational systems, with system technical support and operational and ad-hoc reporting for all staff.

This role is highly technical and will be responsible for supporting the ongoing maintenance and development of the organisations SQL Server Data warehouse and its functionality using allied technologies, including the development of reporting solutions. The post holder will also lead on the continuous delivery of the organisations key outward data flows and datasets.

The post holder will also promote the development of key skills and knowledge across the BI Team, in addition to developing solutions which support the Information team to effectively fulfil their roles.

Scope and Range:

This role is pivotal in enabling the team to develop robust and scalable systems that will increase the efficiency of the team and enable the expansion of information delivery across the whole business function of Livewell Southwest and include the delivery of information and systems using the most up to date technologies and techniques.

Key Tasks and Responsibilities of the Post:

Data Warehouse & Reporting Development

• Support the development and ongoing maintenance of the reporting elements of the Livewell Southwest Data Warehouse, to facilitate the informational needs of the analysts and wider organisation.
• Support the development and continuous delivery of mandatory datasets, including the Mental Health and Community Services datasets, on behalf of the organisation. Implement changes and updates in accordance with the datasets technical output specifications upon the release of new versions.
• Develop essential reporting solutions such as dashboards and performance reports within technologies including Power BI and SQL Server Reporting Services (SSRS).
• Support the rollout and implementation of Microsoft Power BI (PBI) across the organisation.
• Support improvements to data quality across the organisation and its various clinical systems.
• Aid the maintenance of the Data Warehouses internal mappings for Livewell Southwests teams and services, to facilitate benchmarking and wider reporting across the organisation.
• Will be responsible for the creation of both technical guidance and process flows relating to the maintenance and development of the reporting structures within the SQL Server data warehouse.
• Will be expected to investigate and technically advise in the development of SQL Server using the latest techniques and tools in the development of complex reporting requirements, incorporating data from the many systems used across Livewell Southwest.
• A high level of expertise in SQL coding with the ability to proactively maintain existing and develop new procedures for information provision and the troubleshooting of data issues. Including the ability to allow for integration with other technologies such as web development and other application developments.
• Will be responsible for the development of security policies that ensure that access to the database conforms to both NHS Information Governance policies and associated legislation and also any locally agreed Information sharing protocols.
• The ability to analyse complex requests and issues, and then translate into a solution where appropriate.
• The ability to plan workload that may involve several complex pieces of work that have parallel timelines.
• To work effectively with a variety of professionals both technical and non-technical working on projects and programmes as required.
• The post holder is responsible for interpreting and implementing Livewell Southwest policies and will propose relevant improvements and changes to policies as appropriate.
• Contribute to the delivery of project plans, allocating tasks as appropriate, identifying risks, issues and dependencies, considering best practice and current options and ultimately making recommendations in the best interest of the project.
• The post holder will need to work with complex facts or situations requiring analysis, interpretation, comparison of a range of options. Analyses complex problems relating service issues; makes judgements regarding allocation of resource.

Mentoring and Departmental development

• Support the continuous development of the BI team via the dissemination of skills and knowledge, as well as best practice techniques, within SQL coding and reporting solutions such as SSRS and PBI.
• Expected to provide training in SQL Server and its reporting functions across the BI team. This will require training to be provided in SQL Server coding techniques, the proper use of source control and associated tools, in addition to SSRS and PBI.
• Support the Information team by imparting specialist knowledge on the appropriate data sources and criteria for various data flows.
• Act as a gatekeeper for the Information teams deployment of SSRS and PBI reports, ensuring that they are efficient, reflect best practice and the teams agreed standards prior to deployment.

Business Development

• Pro-actively developing, identifying and generating opportunities for the Business Intelligence Team to deliver continually improving systems across all functions of the organisation, ensuring the ongoing improvement and effectiveness of the Business Intelligence team.
• Assist with the Research, review and analysis of the effectiveness and efficiency of existing requirements gathering processes and developing strategies for enhancing or further leveraging these processes. This will include advising other senior managers on the procurement of new software or systems.
• Liaise with other senior members of the Business Intelligence Team to ensure that the delivery of Business Intelligence is consistent across the service.

General

• To undertake other relevant duties as may be required by the Lead Data Engineer.
• To be responsible for training or demonstrating skills for junior or new staff.
• To attend training identified as necessary for the successful delivery of the role.

Communications and relationships:

There will be regular communication with a diverse range of staff within Livewell and representatives of other organisations for the purpose of requirements gathering and informing of new reporting mechanisms. In house training is delivered to other staff where they have a need to be aware of more technical aspects of report building and SQL coding.

Physical Demands of the Job:

This is a hybrid working role, predominantly home based but with access to and an expectation to attend when required in an open plan, air conditioned environment with disabled access and facilities. Work is largely involving the use of a computer and is desk where there are restrictions in position due to the wearing of a headset and inputting at a keyboard.

Mental Effort:

There is a requirement to be able to concentrate for long periods of time using VDU devices and will be of a repetitive nature.

Emotional Effort:

There is a requirement for long periods of intense concentration when collating information.

Additional information for all posts:

The post holder is required to comply with all relevant policies and procedures pertinent to their post. Current versions can be found on the intranet or via your manager. The areas listed below are those Livewell Southwest currently places particular emphasis on. Failure to follow correct policies and procedures may result in disciplinary action.

Risk Management:

In accordance with the Risk Management Strategy, employees will participate, whenever required, with the risk management process. They will support line managers by attending mandatory and statutory training, completing incident/accident forms for every adverse event or near miss that occurs, report all defects and complaints, and communicate any dangerous situation to individuals potentially at risk.

Health and Safety at Work:

You must co-operate with those in authority and others in meeting the statutory requirements and in following policies and procedures. A copy of the Health and Safety Policy is available from the intranet or from the Risk Management Department.You are reminded that in accordance with the Health and Safety at Work Act 1974 you have a duty to take reasonable care to avoid injury to yourself and to others affected by your work activities.You will be notified where your post carries a requirement for immunisation.You may be required to be able to undertake physical intervention training and participate in physical intervention as part of a physical intervention team and Basic Life Support (BLS).

Infection Control:

Livewell Southwest is determined to eradicate healthcare-acquired infection and puts a great deal of emphasis on the responsibility of all staff to ensure their own personal and others compliance with Infection Control (including Hand Washing) Policies. All staff must comply with infection control policies and guidance, attend relevant updates and report issues of concern to their immediate line manager (if no action or explanation received, then it is the individuals responsibility to escalate their concerns to the Director of Operations or Chief Executives Office).

Person Specification

Experience

• Specialist experience of using Microsoft SQL Server within a large organisational setting.
• Experienced in developing applications using Microsoft SQL Server and the SQL Server Stack.
• Experience in developing and delivering complex reporting solutions.
• Experience of working and engaging with staff at all levels.
• Experience of developing / compiling complex policies and procedures.

• Experience in developing SSRS reports.
• Experience in developing Power BI reports.
• Experience of implementing and maintaining source control methods.
• Demonstrable experience of other relational database technologies.
• Experience of project management work.

Specific Skills

• Highly skilled in the application of technology to business problems in order to offer solutions that are useable by staff at all levels.
• Advanced keyboard skills for the use of inputting and manipulating data.
• Ability to work with a high level of autonomy as well as within part of a team.
• Excellent verbal and written communication and presentation skills
• Highly organised and able to plan and prioritise own workload.
• High Degree of competence in communication and presentation of complex information to non-technical staff, including senior managers and clinicians, with clarity and precision.
• Confidently builds effective relationships across organisational and HLP boundaries.
• Commands the confidence of colleagues across the wider health community as well as internally.
• Ability to work in partnership with managers across the organisation and within stakeholder organisations.

Knowledge

• Relevant specialised understanding of the principles and use of relational database technologies.
• Understanding of the Data Protection Act and allied legislation and its implications on systems design.
• Understanding of the Data Protection Act and allied legislation and its implications on the design of systems used on a multi-agency basis.
• Specialist Knowledge and understanding of internet delivery technology, Microsoft SQL Server.

• Understanding of the principles and use of relational database technologies within a healthcare setting.
• Understanding of key health policies and standards (e.g. Referral to Treatment, Right to Reside etc.).
• Knowledge of information systems utilised by partner agencies.
• Knowledge of risk appraisal and management of risk.

Qualifications

• A technology based Degree or substantial relevant equivalent experience in a similar role with relevant specialist knowledge and skills.
• Completion of industry standard recognised courses in SQL Server and evidence of the development of systems using relational database systems and related technologies.

• Any industry standard certification, e.g. Microsoft Certified Professional series, Cisco Networking standards.
• Completion of industry standard recognised courses in any database or programmable language.
• Recognised healthcare qualification in information security or management.

Employer details

Employer name

Livewell Southwest

Address

Crownhill Court

Tailyour Road

Plymouth

Devon

PL6 5DH

https://www.livewellsouthwest.co.uk/