Business Intelligence Analyst (XN06)

Integrated Care System; Leeds; On-site; GBP 35,000 - 50,000; Full time

Job summary

A health care organization in Leeds is seeking a Business Intelligence Analyst to lead the delivery of BI solutions in a collaborative environment. Responsibilities include analyzing data, developing dashboards using Qlik or Tableau, and providing technical support for data warehousing projects. The ideal candidate will have advanced knowledge of BI systems and a solid understanding of database design.

Qualifications

• Experience in business intelligence environments.
• Experience leading BI solution delivery.
• Ability to produce self-reporting dashboards.

Responsibilities

• Develop and deliver BI reports to meet stakeholder requirements.
• Analyze data loads and implement data warehousing design.
• Support the BI Manager in server-side infrastructure.

Skills

Advanced knowledge of Microsoft Excel

Business intelligence expertise

Complex data analysis

Ability to manipulate and model data

Interpersonal skills

Project management experience

Understanding of BI terminology

Experience developing reports

Education

Degree in science, mathematics or computing discipline

Masters degree in a relevant field

Tools

Microsoft SQL Server

QlikView

Tableau

SSIS

Microsoft Azure

Amazon AWS

Job description

Thisis a fixed term 22.5 hours per week contract with an end date of 31 March2027.

Weare seeking a dynamic, self-motivated and passionate person with experienceof working in a progressive Business Intelligence environment.

Doyou have experience leading the delivery of BI solutions for organisationswith multiple stakeholders? Deliveringquality assured evidence based insights to inform business decisions?

Canyou provide technical support and data warehouse maintenance? Do you have experience producing selfreporting dashboards in data visualisation environments such as Qlik orTableau?

Therole will develop informatics delivery, ensuring user requirements are metwith accurate and well-presented outputs supporting the NIHR missions toimprove the health and wealth of the nation through research.

Main duties of the job

Ourbusiness intelligence tasks can range in scale from small ad-hoc datarequests to long-term, cross-team projects. As part of a small and friendlyteam your role will allow you to work with the full end-to-end businessintelligence delivery process. Frommeeting stakeholders and understanding requirements, through data modellingand the ETL process, to data visualisation and generating insight - youllget to experience it all!

Mainduties will include working with relational databases with MS SQL server andETL tools such as SSIS. You will alsoperform analysis of data loads and implement data warehouse design theory anddata modelling techniques. Producing reports and data visualisation in Qlikor Tableau using a variety of data sources. Our current data warehouse ison-premise, but there may be the opportunity in the future to move to ahybrid or cloud based approach. Therefore, any experience of Microsoft Azureor Amazon AWS may also be beneficial.

Throughour data scientists, we are exploring and implementing artificialintelligence and machine learning solutions.An enthusiasm for the field of data science, and a desire tocollaborate, and support these projects will also be beneficial.

About us

TheNational Institute for Health and Care Research (NIHR) has a mission toimprove the health and wealth of the nation through research. The NIHR playsa pivotal role in attracting, training and supporting the best researchersand complements the additional NIHR investment in world-class researchfacilities and a skilled research workforce.

Thisrole is hosted by the Leeds Teaching Hospitals Trust (LTHT) and delivers thework of the NIHR, leading on policy, strategy and delivery in respect ofacademic training in England and working closely with other NIHR centres andthe Science Research and Evidence (SRE) Directorate at the Department ofHealth and Social Care (DHSC).

LeedsTeaching Hospitals is committed to our process of redeploying 'at risk'members of our existing workforce to new roles. As such, all our job advertsare subject to this policy and we reserve the right to close, delay or removeadverts while this process is completed. If you do experience a delay in theshortlisting stage of the recruitment cycle, please bear with us while thisprocess is completed, and contact the named contact if you have anyquestions.

Job responsibilities

DataQuality and Evaluation

• Providereports to an agreed standard to meet the requirements of NIHR AcademyExecutive Board
• Monitorestablished reporting to ensure data quality and integrity is maintained
• Evaluateoutputs, formulate and present ideas of future reporting developments
• Dealwith non-routine enquiries providing advice as necessary
• Analyseand report on a range of options in order to contribute to decision makingand action planning
• Providesupport and input into how data quality and integrity can be maintained aspart of business improvement plans
• Providesupport in responding to information requests and parliamentary questions
• Implementsbusiness intelligence policies and proposes changes to user working practicesand procedures e.g. when planning for new projects, changes in legislation,new reporting processes, new training programmes impacting across theorganisation.
• Continuousimprovement of data collection and modelling processes to ensure future fitfor purpose

Communicationsand Engagement

• Provideand receive complex, sensitive information
• Communicatecomplicated, difficult to explain issues to non-technical staff
• Presentcomprehensive reports and analysis of data gathered to the NIHR AcademyExecutive Board and other stakeholders
• Buildrelationships with end users to ensure that the BI function provides thetools that they require
• Contributeto cross-NIHR meetings and groups, effectively communicating informationrelating to NIHR Academy

Technical

• Useappropriate BI tools to access and analyse data
• Provideserver side infrastructure support to the BI Manager to ensure reporting andBI tools continue to be available at all times
• Planand implement projects appropriate to the role
• Achieveagreed objectives, working within professional policies, acting as aspecialist in own area

Person Specification

Experience

• Advanced knowledge of Microsoft Excel
• Specialist business intelligence knowledge and expertise acquired through degree level or equivalent qualification/experience
• Experience of complex data analysis using advanced knowledge of statistics, database design and BI systems tools
• Understand basic concepts of BI Architecture such as ETL, Data Warehousing and Data Modelling
• Ability to manipulate, model and analyse data using Excel, SQL, QlikView, Qlik Sense
• Experience developing reports using data visualisation tools such as QlikView, Qlik Sense, Tableau or Power BI
• Experience in processes related to data collection, modelling and processing data to maintain a trusted data source
• Commitment to self development and consideration of options that may improve or provide alternative solutions to existing NIHR Academy technology
• An understanding of data protection and information governance including GDPR and the importance of reporting standards and report definitions
• Experience creating ad hoc SQL queries of T-SQL
• Experience of project management
• Advanced development and application of google platforms, Microsoft office and databases
• Contributed to peer reviewed publications
• Experience of Microsoft Visual Studio (SSIS)
• Knowledge of grant/award management and its metrics
• An understanding of terminology applicable to medical research
• An understanding of public sector health research and its management

Skills & behaviours

• Highly developed interpersonal skills with the ability to deal effectively with confidential, sensitive, or contentious information
• Quickly assimilate information and apply knowledge effectively to new problems, escalating concerns where necessary
• Well-developed knowledge and experience of operating and utilising information systems and software applications
• Understanding of Business Intelligence terminology and processes
• Understanding of Relational Databases
• Ability to tackle complex problems, identify solutions and implement them
• Ability to work as part of a team, build and maintain good working relationships both internally and externally to the organisation
• Ability to set goals and standards
• Ability to take personal responsibility
• Excellent verbally and in written communications
• Highly motivated
• Ability to give, receive and seek advice to/from peers and wider NIHR Academy executive
• Experience developing and scripting with QlikView
• Understanding of Source or Change Control processes
• Understanding of Relational database administration and maintenance routines

Additional Requirements

• Ability to work accurately with attention to detail
• Use of BI tool sets such as QlikView and SQL
• Experience of drafting reports or manuscripts
• Experience creating plans for BI solutions
• Ability to analyse, interpret and present complex data and policy information in an easy to use and understandable manner for different audiences
• Ability to collect, model and process data from many different sources
• Ability to work with end users at all levels to gather requirements and suggest innovative methods to streamline approaches to model and analyse data to match business requirements
• Ability to identify data errors, inconsistencies, or gaps to achieve standardised, consistent, and reliable outputs
• Ability to maintain confidentiality
• Willingness and ability to travel in UK on a frequent and regular basis, including occasional overnight absence

Qualifications

• Degree in a science, mathematics or computing discipline or equivalent experience as a reporting analyst
• Masters degree in a science, mathematics or computing discipline or equivalent

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.