Senior business intelligence developer

Job description

Job responsibilities

1. Communication and relationship skills

• The postholder will have the ability to communicate technical challenges and solutions in an understandable way, to internal and external parties who will have varying levels of technical knowledge.
• The postholder will be confident and comfortable presenting information on a 1:1 basis or to a large group, both in person and via video conferencing software such as Microsoft Teams.
• The postholder will select and use the most appropriate form of communication to ensure that the messages being communicated are fully understood by their audience, and can be used to come to informed judgements on the issues under discussion.
• The postholder will have good influencing skills in order to persuade senior colleagues of the importance of data quality; and to gain support for the projects for which the postholder is responsible.
• The postholder will represent MCH and its values at meetings with external stakeholders.
• The postholder will have the ability to influence those over whom they do not have line management responsibility in order to deliver key organisational projects and priorities.
• The postholder will build good working relationships with key stakeholders including internal staff, senior management, commissioners, IT suppliers and other statutory bodies.
• The postholder will have the ability to communicate highly complex data/statistical information to a range of healthcare professionals with varying levels analytical expertise and sometimes in environments where there are potential (hostile) barriers to acceptance.
• The postholder will be responsible for providing clear training packages and process documentation.

1. Knowledge, training and experience

• The postholder will be educated to degree level, or with an equivalent level of skill gained through experience of providing support services in a complex environment; and will have continued to develop their skills and expertise through programme of on-going personal development.
• The postholder will have advanced technical skills within BI and database technologies. Particularly advanced T-SQL, and a solid ability with the wider Microsoft BI Stack (SSAS, SSIS, SSRS).
• The postholder will have experience of delivering complex database solutions including customised and optimised Data Warehouse solutions, based on Relational Databases and Tabular Data Modelling techniques, derived from multiple, often highly disparate data sources.
• The postholder will be able to demonstrate an ability to think outside the box, and consider innovative solutions to BI challenges using technical and business knowledge.
• The postholder will have experience of working within IT projects and delivering on time and to budget.
• The postholder will have excellent knowledge and experience of working with performance data and a proven track record of implementing change.
• The postholder will have proven experience of improving processes and/or reporting solutions.
• The postholder will have excellent IT skills on Word, Access, Power BI and advanced knowledge of Excel.
• The postholder will have knowledge of technical data analysis and reporting using a variety of systems.
• The postholder will have excellent presentational skills and the ability to design user friendly data reports.
• The postholder will be aware of and comply with information governance principles and procedures with particular emphasis on compliance with confidentiality requirements.
• The postholder will have excellent planning, organisational and leadership skills.

1. Analytical and judgement skills

• The postholder will have the ability to identify where they do not have sufficient information to reach robust conclusions on an issue, and to design an appropriate methodology for gaining the information required.
• The postholder will have the ability to generate solutions and options to data / software issues.
• The postholder will have the ability to collate, analyse, interpret and present complex activity and performance data for a range of services.
• The postholder will not only respond to requests for information, but also identify any data quality issues providing supporting analyses and give recommendations where appropriate.
• The postholder will assess requests for information, investigate problems and provide solutions or suggest a range of suitable options.
• The postholder will have the ability to use their judgement to assess and recommend prioritisation of issues that they themselves will need to address, that the team might need to address and also that operational services might need to address.

1. Planning and organisational skills

• The postholder will have the skills and expertise to ensure that agreed complex plans are delivered, particularly where they do not have line management responsibility for those delivering the work.
• The postholder will plan and lead workshops and projects that support MCH staff to improve their data processes, data quality and develop their understanding of information provided via a wide range of reports and dashboards.
• The postholder will have the ability to identify when their projects are failing to achieve required milestones and will develop and implement a suitable rectification plan and notify to the appropriate manager or governance group at the earliest opportunity.
• The postholder will have the ability and experience to complete projects without direct supervision and recommend changes to plans.
• The postholder will have the ability to plan their own workload in order to deliver key targets/timescales and recommend/instruct others in the achievement of objectives and project outcomes.
• The postholder will be responsible for planning and designing all data processing operations. They will collaborate with external suppliers and other members of the team. These will be critical in ensuring achievement of the daily and monthly reporting process cycles and that all contractual deadlines are met.
• The postholder will ensure that the Business Intelligence team advise and support service leads to help improve the accuracy and consistency of their activity recording and minimise gaps in data and information.

1. Physical skills

• The postholder will have advanced keyboard skills.
• The postholder will have advanced use of a range of relevant IT packages.
• The postholder will have the ability to operate audio-visual equipment.
• The postholder will be required to travel between sites to meetings and event.

1. Responsibility for patient / client care

• The postholder will have no direct responsibility for patient care, but will be required to assist patients appropriately during incidental contact.
• The work undertaken by the postholder may have a direct impact on the organisations ability to provide clinical service, and as such the postholder is required to conduct himself or herself with the utmost propriety.

1. Responsibility for policy and service development implementation

• The postholder is responsible for implementing policies and procedures within their activities and will contribute to wider information policies/practices/procedures including suggestions for changes that come about in light of analytical work they are carrying out.
• The postholder will be responsible for developing and maintaining clear and concise Standard Operating Procedures and Change Management processes.
• The postholder will contribute towards policies affecting data and information.
• The postholder will keep up to date with relevant legislation, policies and procedures and communicate to relevant parties and will be responsible for developing datasets and standards where required.

1. Responsibilities for financial and physical resources

• When identifying technical solutions, the postholder will be expected to explore multiple options including identifying both and indirect costs of implementing an maintaining those solutions
• The postholder will avoid resource and time-waste wherever possible.
• The postholder will submit their own timesheets and travel claims accurately and in a timely manner.
• The postholder will be an authorised signature for travel claims and timesheet.

1. Responsibilities for human resources (HR)

• The postholder will ensure the Business Intelligence team has guidance documentation (process notes) to support all business as usual activities that need to be undertaken.
• The postholder will provide training to all analysts in relation to the work they are managing.

• The postholder will provide training to a range of staff and managers across the organisation of varying technical ability.

• The postholder will direct other analysts within the team in respect of activities that are required to develop and test reports and dashboards.

• The postholder will liaise with others to ensure cover of rotas and key tasks including planning of annual leave.

• The postholder will recognise and understand the impact of organisational change on teams and individuals, and will seek to develop strategies to support members of teams they are working with through such changes.

Full JD can be found in attachments

Person Specification

Qualifications

Essential

• Educated to degree level or equivalent experience
• Understanding of ETL processes and data warehousing

Expertise

Essential

• Strong experience of Business Intelligence Database Development using SQL Server
• Significant experience of developing and maintaining large scale SSIS and SSAS solutions
• Experience of querying data and developing reports/dashboards in Power BI or other BI Tools
• Advanced knowledge of TSQL

Desirable

• Experience of working with health-related data, undertaking/managing data analysis
• Understanding of Relational and Multidimensional Database theory and practice

Experience

Essential

• Strong technical and problem-solving skills and comfortable working with the latest analytical techniques and technologies
• Ability to research and understand complex technical subjects

Desirable

• Knowledge and experience of using Rio & EMIS electronic patient record system
• Knowledge of Information Governance, Security and confidentiality issues
• Proven experience in improving processes and/or reporting solutions

Communication & practical skills

Essential

• Excellent communication skills, particularly written communication skills
• Ability to support and train others
• Planning and organisational skills - ability to manage and prioritise own workload and workload of others

MCH Values

Essential

• Caring and compassionate, delivering quality and value and working in partnership

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).

Employer details

Employer name

Medway Community Healthcare

Address

MCH House

MCH House, 21 Bailey Drive, Gillingham Business Park

Gillingham

ME8 0PZ

Employer's website

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