Senior Data Engineering Analyst

Job responsibilities

To investigate, appraisal, advise, plan and undertake with clinical, technical and managerial teams, finding solutions to issues and requirements that are raised from internal and external influences.

To formulate business cases and assess cases from other departments that may engage on Digital Services

To lead on the effective use of information to support the objectives of Data Engineering and wider Digital Services service, including, data integrity, planning, software developments, projects, forecasting, investigations, assessments and risk management.

To work closely with the Lead Data Engineering Analyst ensuring data structures are optimised for robust analysis by corporate and clinical functions.

To consider existing complex, multi departmental data flows and inform changes harnessing software capabilities to provide the right information at the right time.

To manage direct reports in all human resource and service related issues, fostering a culture of learning and support to deliver valuable expertise to assist the objectives of the service.

To apply advanced levels of understanding of specialty specific data, applying exceptional attention to detail, ensuring the highest quality and efficiency of new processes are implemented.

The post-holder will ensure knowledge, insight and information generated from the Data Engineering team is communicated effectively and that the systems and processes underpinning this operational function are regularly reviewed.

Able to confidently converse with managers, senior clinicians, using specialised clinical and technical terminology as required, to understand issues being raised in detail.

As a senior member of the Digital Services directorate, apply statistical and analytical knowledge to critically appraise and challenge the results of outputs ensuring only meaningful information is delivered to the clinical/business stakeholders.

To manage staff whom the post holder is responsible and deputise for their line manager as appropriate.

Working with project teams, the software development team and the Data Engineering team to detail software development requirements and advise on functionality, quality, and potential issues.

To work closely with and support the highly important requirements of the performance management and income teams to ensure our patient access and our finances have the right engagement from the expertise of this role.

To represent Digital Services as appropriate in internal and external meetings, reporting back on progress. The post holder must be able to travel and be sufficiently confident to forge effective working relationships with partner organisations as required.

To advise, support and lead on reporting at appropriate directorate, divisional and trust level meetings.

The post holder will have, and continue to gain, appreciation for the working environment of the clinical, financial and performance community, ensuring that outputs meet well within the expectations of stakeholders.

Ensure the provision of a first point of contact within Digital Services for all queries, problems, requests and incidents ensuring they are logged and tracked.

Lead, manage and action the resolution of incidents, problems and requests in an efficient and professional manner, whilst conforming to Trust and departmental standards, service agreements, policies, procedures and working practices, seeking further advice and information within Digital Services, when necessary.

Support for the monitoring and business continuity of all operationally reliant ETL functions.

Human Resources

Responsible for line management as required in line with appropriate policies, procedures, working practices and guidelines, ensuring all resources are deployed to maximise an efficient and effective delivery of support services to patients and users.

Provide regular performance reports on progress, status and achievements for own area to be used by management and users.

Undertake and support the development of staff in line with personal development reviews and other associated guidance.Provide training for staff from own or other disciplines on own subject area, when required. On occasion the post holder may be required to work unsociable hours to support and/orenable the delivery of key programmes or projects.

Financial/Physical Resources

Responsible for the management of financial resources allocated to own areas and make proposals to maximise those resources through involvement in budget setting, recharges, long term financial planning and cost saving opportunities.

Be responsible for the safe use of ICT hardware and software, including installation, repair and maintenance.

Monitor the maintenance and support contracts allocated to own area, ensuring continuity of service and budget management. Liaise with third party suppliers to identify and evaluate potential value for money contracts.

Liaise with external agencies, suppliers and contractors ensuring delivery of service is in line with agreed contracts.

Lead business appraisals and business case production when required in partnership with Trust stake holders. Undertake solution searches and appraisals of supplier proposals.

Ensure Trust procurement processes and procedures are followed in a timely and efficient manner and participate in the procurement process where relevant, providing assistance for the development and assessment of procurement documentation as required.

Ensure Trust Standing Financial Instructions (SFIs) and procurement guidelines are followed and adhered to.

Project Management

Advise and participate in the development and implementation of projects, where required, ensuring Digital Services provision of integrated solutions and user objectives are achieved. Lead on Service Desk/service improvement projects.

Ensure project tasks, where required, are successfully delivered in line with agreed timescales and budgets.

Support the activities of project boards and project teams, when required, and making presentations, where required, to all levels of staff.

Ensure any project management documentation or reports are delivered in line with agreed standards and timescales.

Policy/Service Development/Governance

Act as an ambassador for Digital Services Service by developing and maintaining excellent working relationships with users across the organisation to deliver a high quality, standard IT culture to achieve local requirements and national targets.

Lead in the development and maintenance of a culture of service provision and continuous improvement for own areas.

Be responsible for implementing policies for own work area and for proposing changes to policies, in line with legislation, Trust and NHS policies and guidelines across the Trust, where appropriate.

Pro-actively participate in ensuring that Digital Services services delivered within the Trust reflect best practice with respect to organisational, NHS and legislative requirements and guidelines including IT Infrastructure Library (ITIL), Data Protection Act (1998), Information Standards, Information Security and compliance with NHS Information Governance.

Participate in Information Governance and security as required and ensure appropriate governance and security in own area.

Leading on quality management, undertaking audits designed to improve IT systems and services.

Ensure change management is applied in own areas and follows implemented policies and procedures.

Ensure all documentation relating to own area is complete and fit for purpose and all releases relating to hardware, software and documentation is controlled.

Ensure there is a proactive and comprehensive approach to risk management and be responsible for service continuity for own area and participate in the Digital Services service continuity planning.

Participate in Root Cause Analysis (RCA) for allocated incidents and problems; instigating emergency action, when required, liaising with other Trust Managers, as appropriate.

Business Continuity ManagementLead in the development, exercising, maintaining and reviewing of business continuity plans. Participate in the business impact analysis exercises highlighting critical business processeswithin own area.

Be familiar with the Trust Business Continuity Plan and personal responsibilities within where applicable.

Qualifications

Essential

• University Degree in a related subject or demonstrable equivalent experience
• Relevant professional or technical qualification
• Evidence of continued professional development

Desirable

• Post graduate level of education in an Digital Services/scientific/ mathematical discipline
• Agile methodology qualification
• Management qualification(s)
• Database/dataflow/reporting practitioner certificates e.g. SQL, Microsoft server tools etc.
• Statistics qualification

Experience

Essential

• Substantial experience of querying databases using SQL and appraising the queries of others
• Experience of managing staff in a technical team providing a customer-focused support environment
• Experience of producing documentation and reports to a Trust Board level standard
• Extensive experience with Microsoft Word, Excel, PowerPoint, Project, Visio and Outlook
• Experience of managing financial resources
• Extensive experience in an information role involving analysis of complex data
• Experience of managing a number of equally important tasks successfully
• Successful track record of achieving service improvements through initiating the use of new technologies and supporting the management of change
• NHS experience involving close working relationships with senior managers, clinicians and a multidisciplinary environment
• Experience of leading data quality/data integrity monitoring and improvement programs of work and creating new policies, procedures and system documentation relating to data management

Desirable

• Demonstrable experience in similar role
• Experience of writing/appraising business cases.
• Experience of data capture process re-design, critical analysis and implementation of change
• Experience of clinical or corporate service operational management
• Experience of academic writing for publication
• Experience of audit methodologies
• Experience of clinical trials/studies

Skills

Essential

• Excellent communication skills - verbal, written, presentational and interpersonal
• Good organisational skills including time management, record keeping and paying attention to detail
• Able to work to deadlines, prioritise and manage workload in a busy and changing environment; demonstrable evidence of use of own initiative
• Flexible, positive, resilient, methodical, team player., advanced influencing and negotiating skills
• Analytical skills in data extraction, data analysis and report writing with ability to make sound observations and recommendations through formal reporting
• Ability to communicate complex system and technical issues to a variety of staff at different levels within the organisation
• Ability to think creatively and work effectively and efficiently under pressure; strong problem solving approach to issue resolution seeking out best practice and referencing guidance

Desirable

• Data analysis skills using statistical packages such as STATA, SPSS, R.
• Advanced skills with packages, languages and constructs for data transfer (such as SSIS, XML, HL7)
• Advanced Tableau data manipulation skills
• Ability to coach individuals and lead a team engendering enthusiasm and commitment
• Able to directly supervise a large team including recruitment, appraisal and work monitoring

Knowledge

Essential

• Knowledge of Cancer Services
• Wide basic knowledge of Digital Services disciplines such as development, infrastructure, service desk
• Practical and working knowledge of Microsoft Office Products at an expert level
• Understanding of how services are commissioned within the NHS.
• Knowledge of hospital services and how services interlin; understanding of the working practices used within the Trust, e.g. patient administration and clinical pathways

Desirable

• Knowledge of NHS England, Health & Social Care Information Centre (HSCIC) and Department of Health strategies, policies and guidance
• In depth knowledge and understanding of oncology treatment pathways on a disease group level
• Public health knowledge in relation to cancer
• Knowledge of quality improvement methodology and its practical application
• Understanding of NHS clinical coding principles and implications

Other

Essential

• Evidence of continuing professional and personal development
• Maintain confidentiality relating to patient data and sensitive information relating to the business of the Trust
• Ability to work flexibly to meet key deadlines
• Flexible working hours ensuring core service coverage from 8:00am to 6:00pm
• Ability to undertake shift working including out-of-hours, weekend and Public Holidays as required

Desirable

• Commercially adept at contract/SLA negotiation
• Driving License / Car Owner

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.

Certificate of Sponsorship

Applications from job seekers who require current Skilled worker sponsorship to work in the UK are welcome and will be considered alongside all other applications. For further information visit the UK Visas and Immigration website (Opens in a new tab).

From 6 April 2017, skilled worker applicants, applying for entry clearance into the UK, have had to present a criminal record certificate from each country they have resided continuously or cumulatively for 12 months or more in the past 10 years. Adult dependants (over 18 years old) are also subject to this requirement. Guidance can be found here Criminal records checks for overseas applicants (Opens in a new tab).