Information Developer

1. 5 hours per week (flexi-time).

The Trust has recently made significant investment in new Data Warehouse systems, complimented by new Business Intelligence reporting tools.

We are looking for an experienced Information Developer to join our busy and highly skilled team to further develop and maintain the data warehouse and reporting cubes.

Main duties of the job

You will be required to interpret complex requests then design implement new technical solutions, utilising the SQL stack and other technologies where appropriate.

A logical thinker who can work using your own initiative, you will also be a confident communicator and team player. The role will involve close working with other developers in the team, and well as analysts and other members of the department and staff across the Trust.

Educated to degree level, or equivalent qualification in a relevant discipline with experience in a software or information development role. The role requires experience of ETL and BI development using full SQL stack (SSMS, SSRS, SSIS, SSAS), NHS background, and preferably some experience of PowerBI and Microsoft Excel.

We operate hybrid working and are based at the Civic Centre in Doncaster. Travel to other sites may be required occasionally.

Working for our organisation

DBTH is one of Yorkshire’s Leading acute trusts, serving a population of more than 440,000. Our services are based over three main hospital sites and several additional services employing over 7,000 colleagues.

At DBTH we have a comprehensive framework of behaviours that guide us in our daily working lives, these form the DBTH Way. We pride ourselves on our commitment to the values of We Care and now the DBTH Way builds upon these foundations, providing further clarity on what it means to embody these values in our everyday interactions.

As an organisation that supports flexible working, we want to be sure that you can work in a way that is best for us and for our patients, and for you. Speak to us about how we might be able to accommodate a flexible working arrangement. If it works for the service, we will do our best to make it work for you.

As an equal opportunities employer, we encourage applicants from all sectors of the community, particularly from under-represented groups including those with disabilities, members of our ethnic minorities and LGBTQ+ communities.

• Extensive range of learning opportunities
• NHS Pension Scheme
• Generous holiday entitlement in line with Terms & Conditions
• Comprehensive health and wellbeing support
• NHS Car Lease schemes and a range of salary sacrifice scheme
• Discounts on restaurants, getaways, shopping and finance through external providers.

Detailed job description and main responsibilities

Please see attached to the advert a job description and person specification for further details. Please ensure you read both documents carefully.

Please note, if your application is successful, you will be required to present original certificates of qualifications that are listed in the person specification under essential.

Person specification

Knowledge and Experience

• Minimum of 3 years’ experience in a Data Engineer / Business Intelligence / Data Analyst / Software Developer role.
• Experience of working within an NHS environment.
• Awareness of data collection and data management procedures and patient administration procedures.
• Competent user in Microsoft Office products
• Experience of querying Microsoft SQL Databases.
• Awareness of NHS strategic objectives and the implications for Information Management.
• Evidence of excellence in profession in current role who is accustomed to the culture of service provision.
• Good understanding of the effects of poor data quality on patient experience and other Trust and national agendas.
• Detailed knowledge of NHS Data Definitions and technical documentation
• Competent in using a diverse range of information sources for research and problem solving.
• An awareness of the challenges facing the NHS, and how Information can support delivery of these objectives.
• Advanced numeracy skills and intermediate statistical techniques
• The post holder will require a clear understanding of the concept of the confidentiality of personal health information to ensure that this important aspect of care is not breached
• Ability to identify and assess a range of complex facts and situations where there may be no obvious solution.
• Exercise judgement in a situation that may have never occurred before or there may be no guidance.
• Advanced systems analysis skills to interpret user’s requirements and work through solutions from conception to delivery.
• Ability to quickly identify and investigate inconsistencies in data.
• Ability to exercise judgement and provide advice in the regular design and development of a range of information systems (databases, spreadsheets) required to produce reports
• Skilled in complex data analysis and interpretation, reporting complex, sensitive and on occasion’s contentious information to Managers, Clinicians, and other staff groups.
• Complex problem-solving skills including lateral thinking to develop new ideas and thinking which can be realised into workable solutions
• Ability to judge whether issues can be locally managed or should be referred higher
• Confident to propose service improvements and developments
• Ability to interpret and implement policies relating to informatics and business intelligence
• Experience in implementing successful changes to enhance business information management and reporting.
• Experienced in delivering training to individuals and groups
• Experience of developing and implementing information reporting systems
• Ability to act freely within an agreed framework to achieve agreed objectives.
• Use of VDU equipment for a significant amount of the day, long periods sitting at a desk.
• Advanced and accurate keyboard skills
• Ability to occasionally travel to other sites within the local area, for example by car or public transport
• Frequent, prolonged levels of concentration required when dealing with complex information, problem solving or software development
• Ability to quickly identify, investigate & provide solutions for identified issues.
• Ability to remain calm and demonstrate a professional manner in complex, difficult, emotional, or uncertain conditions.
• Ability to act assertively in difficult situations.

• Experience of building ETL processing in SQL Databases.
• Awareness of NHS clinical information systems
• Modern programming languages
• Experience of Maintenance and Configuration Tasks on Windows Servers
• Database Administration Experience
• Experience of building SSAS Analysis Services Cubes.
• Power-BI Experience

Qualifications/Training

• Degree or equivalent qualification or relevant experience in relevant discipline plus post graduate diploma or equivalent qualification or relevant experience in a software or information development role
• Academic knowledge of the theory of relational database concepts and design.
• Evidence of ongoing career development

• Microsoft Certified Professional
• Knowledge and skills in Microsoft SQL Database environments including administration and associated products (i.e Analysis Services) gained through attending a variety of formal courses and practical experience

Personal Attributes & Skills

• A confident and clear communicator, whether in person or via video call.
• Good interpersonal skills
• Ability to supervise other staff on specific pieces of work.
• Effectively communicate a range of complex Information Management ideas and solutions to all levels in an easily understood way including breaking down barriers to understanding
• Perform well as part of a team and undertake support and training of other team members.
• Confident to lead and fully participate and represent the team and department at internal and external meetings.
• Ability to assimilate and disseminate complex information quickly and accurately at all levels
• Confident to present complex information to small groups.
• Ability to undertake training including contextual training to small groups
• Strong ability in interpreting a user’s requirements, converting it into a technical solution, and advising them on what information would best suit their purpose.
• Persuasion and negotiation skills in relation to resistance to change situations
• Ability to work under own initiative, prioritise and manage workload and to work to strict deadlines.
• Ability to manage an extensive and complex workload efficiently
• Excellent planning, project management and organisation skills covering a broad range of complex, often conflicting priorities, and activities
• Ability to manage an extensive and complex workload efficiently, with exceptional attention to detail and accuracy
• Unpredictable daily work pattern and conflicting priorities
• Frequent Interruption factors – ability to respond flexibly in an ever changing and unpredictable environment.
• Working to tight deadlines in pressurised situations

• Experience of collaborative working with other organisations

• Please note that all correspondence will be sent you to via email. If you are offered a job, information will be transferred into the national NHS Electronic Staff Records system. In submitting an application form, you authorise our Trust to confirm any previous NHS service details via the ESR IAT process should you be appointed.
• We reserve the right to close down this advert early should there be a high number of applicants.
• The Trust is committed to its obligations in accordance with the Equality Act 2010, and we positively encourage applications from all sections of the community.
• All employment with the Trust is subject to a number of NHS Employment Checks being met to a satisfactory standard including verification of identity, eligibility to work in the United Kingdom, references and qualifications in addition to professional registration, a disclosure and barring records check and occupational health check if these are deemed to be a requirement for the position to be undertaken. The Trust is now passing the charge for undertaking a DBS check on to candidates in the event that they are successfully appointed into the post for which they have applied. Please note that this check will be charged for in two instalments when you commence employment with Doncaster & Bassetlaw Teaching Hospitals NHS Foundation Trust. By applying for this vacancy you are agreeing to this undertaking in the event you are successfully appointed.