Business Intelligence Developer

Job description

Job responsibilities

We are looking for people with development skills who would like to specialise in Business Intelligence for an exciting role in a Data Warehousing team. As a Business Intelligence Developer , the role will be responsible for building, testing and maintaining the data architecture. The role is crucial to lay the foundation, enabling data scientists and data analysts to create new insights from data.

The role will drive best practice for data products and services within the team and building build Business Intelligence capability. The role will work with other senior team members to identify, plan, develop and deliver data services.

The role will involve driving forward improvements in data services including the development and implementation of a new data platform and roll out of platform for analytics and reporting. The role will also involve supporting the organisation with ongoing projects from a data perspective.

The role will be responsible to ensure compounding value is created through shared data, common ontologies, and cross-organisation projects. You will do this through maintaining a focus on systems, processes, culture, performance and behaviours, with a keen eye for best practice and as a collector of ideas, you will keep abreast of a wide range of national and local health and social care policy developments and provide proactive insight to ensure these are reflected in the delivery of the Trust objectives and medium to long term plans

You will be solution-focused, effective, and resourceful; able to overcome challenges and motivate others.

You will be responsible to act as a role model for leadership, living and promoting the LCHS Way. You will be expected to support and encourage others to reach their full potential by creating an environment of empowerment through adopting a culture of freedom coupled with accountability.

Responsible for working with the team to continually automate by identifying areas of need/opportunity and helping to develop and implement solutions, and streamline procedures for extracting and processing regular data.

Train others on information gathering and analysis,and to develop datasets to support national reporting requirements, standards and timeframes.

To be the analytical lead and make recommendations about the performance of specific complex queries, including proposing, developing and introducing new systems for reporting and training.

Lead in the analysis and interpretation of activity and information produced and manipulate raw data in order to present information in a format suitable to a variety of internal and external audiences to demonstrate the Trusts activity and performance

To advise, in conjunction with others, on data quality within the organisation; recommend changes and new reports in areas identified as critical to the organisation.

To develop effective reporting and management tools to inform the LCHS on the Key Performance Indicators and information analysis.

To proactively review changes in the NHS data collection measures and new guidance and returns, and identify areas of risk to the organisation.

In conjunction with FBI colleagues, particularly in the operational area, , support the collation and submission of statutory returns and other organisation reports, ensuring accuracy and disseminating useful conclusions and information.

Lead on the NHS Data Model and Dictionary for England and assist other team members to develop a working knowledge.

To design, develop and implement LCHS wide processes, to support the flow of information and the delivery of targets.

To deal with agreed as well as unpredictable, ad hoc requests using varied datasets, from all levels including senior leaders to achieve organisational objectives.

Person Specification

Experience

Essential

• Experience in statistical analysis and presentation techniques and have a solid understanding of research methodologies and data validation techniques.
• Contract management experience and associated data flows
• Experience of working with NHS data sets, advanced SQL and query writing skills, experience of using Power BI and DAX Scripting or equivalent.

Qualifications

Essential

• Degree level qualification or equivalent qualification/experience
• Evidence of recent relevant CPD

Skills

Essential

• Be able to work autonomously and under pressure to meet strict deadlines.
• Technically skilled to an advanced level with specialised technical skills including SQL Server, report building, MS Excel, analytical skills and a knowledge of displaying information visually, e.g. dashboards.
• Ability to demonstrate pragmatic decision-making when evaluating data and trends
• Demonstrates accountability and ownership of work duties and activities and carries them out with accuracy, integrity and customer focus
• A high degree of customer service focus including with clinicians, senior leaders, external stakeholders

Knowledge

Essential

• IT literacy to an expert level including proven knowledge and skills in Microsoft Database environments (SQL), Business intelligence systems (e.g. Qlikview), and systems programming languages gained through courses
• Knowledge of mandatory reports, performance metrics, NHS currency and activity.
• Extensive knowledge and experience of working in an information team, understanding Information Standards, Performance Targets, dataset production to Data Dictionary standards and SLA monitoring

Desirable

• Have in depth knowledge of large data structures ideally NHS information systems.
• Knowledge of the NHS Data Dictionary and an understanding of NHS performance indicators and quality standards and an understanding of national tariff and payments by results.

Attributes

Essential

• Ability to travel across the county
• Excellent interpersonal skills including verbal and written communication and presentation skills

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

Lincolnshire Community Health Service NHS Trust

Address

Beech House

Waterside South

Lincoln

LN5 7JH

Employer's website

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