Junior Systems (BI) Developer

Job description

Job responsibilities

Communication

Close liaison with other members of the Data Engineering team, and active contribution to the successful running of the department will be expected from the post holder.

Confidently and effectively communicate with users of the Trusts Information Systems, spanning staff at all levels of the organisation.

Being able to articulate complex technical information in a way that is appropriate to users with different levels of computer literacy and technical capability.

Service Delivery and Improvement

Analyse and investigate system errors and unplanned downtime for root causes, making recommendations on remedial actions and implementing required changes to prevent recurrence.

Translate user requirements into actionable development proposals, making recommendations as to best approach to achieve the desired outcome and negotiating timescales.

Able to operate typically unsupervised on a day-to-day basis, prioritise own workload within given timescales in partnership with customer deadlines and operational needs, seeking direction from the Data Engineering Manager and/or Head of IT Data Management.

Able to work methodically and logically on own initiative with minimum supervision.

Maintain departmental standard operating procedures, making changes to reflect newly developed applications and reporting solutions.

Fully exploit opportunities to streamline existing processes by making recommendations for change through advances in programming and database technologies.

Keep up to date with newly issued DCB directives, determining required changes to existing systems to ensure full compliance with their requirements.

Observe personal duty of care for all issued equipment.

To contribute towards the design and development of specialised custom-built information collection and reporting systems as part of the Applications Development function, that deliver effective solutions to Trust business needs and facilitate the provision of services to patients. This may include:

o Gathering and documenting user requirements. Seeking approval from the data Engineering Manager and/or Head of IT Data Management before initiating development work.

o Designing small solutions to address specific business needs.

o Developing applications either wholly for smaller projects, or as part of the larger team for more significant pieces of work.

o Monitoring system performance and highlighting issues.

o Implementing database changes, ensuring referential integrity is maintained.

To plan own workload, taking direction and priorities from the Data Engineering Manager

To be actively involved in the testing of new developments.

To ensure all documentation relating to application development is maintained.

Participate in the management of the Trusts Data Warehouses and Management Information Tools, to enable provision of all statutory returns on patient information by the Information Services team; maintain accurate documentation regarding the data structures, routines and files used by the Data Warehouses and Tools.

To be actively involved in the testing of upgrades for the Trusts Information systems, participating in the actual upgrade process where appropriate.

Maintain the reference data contained within the Trusts information systems so that it conforms to NHS data dictionary standards.

Produce submissions of Commissioning Data Sets (CDS) to be made to the Secondary Uses Services (SUS) and Maternity Services Data Set (MSDS) to the Exeter portal in line with the timescales specified by the Operating Framework to support the Commissioning process.

Collaborate with the Commissioning and Finance departments to ensure provision of accurate, timely information to support the monitoring of Service Level Agreements, Service Line Reporting/Patient Level Costing and Reference Costs submissions.

Maintain an up-to-date knowledge and understanding of the Data Dictionary, NHS information requirements and IT developments as they apply to Trust systems.

Develop and maintain a solid understanding of the Information Systems used across the Trust, their data models and structures, interdependencies and interfaces so as to facilitate work to develop new and more complex reporting capabilities.

Person Specification

Experience/ Qualifications

Essential

• Degree in a computing, mathematical or statistical discipline, or possessing the equivalent knowledge through proven relevant experience.
• Expertise in the use of Microsoft SQL Server suite : SQL Programming (T-SQL), SQL Server Integration Services (SSIS) and Reporting Services (SSRS).
• Experience in the use of relational databases, querying techniques and data analysis/interpretation.
• Knowledge of software development tools

Desirable

• Microsoft certification in the use of Microsoft Business Intelligence stack (SQL Server Reporting Services, SQL Server Integration Services).
• Programming skills in Visual Studio (ASP.Net, VB.Net), XML, JavaScript, VBScript, Microsoft Office.

Equality, Diversity, and Inclusion

Essential

• Evidence of having undertaken own development to improve understanding of equalities issues
• Evidence of having championed diversity in previous roles (as appropriate to role).

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

University Hospitals Sussex NHS Foundation Trust (279)

Address

Brighton / Worthing

Brighton / Worthing

BN2 5BE

Employer's website

https://www.uhsussex.nhs.uk/ (Opens in a new tab)