Business Intelligence Analyst (XN06)

Job responsibilities

Data Quality and Evaluation

Provide reports to an agreed standard to meet the requirements of NIHR Academy Executive Board

Monitor established reporting to ensure data quality and integrity is maintained

Evaluate outputs, formulate and present ideas of future reporting developments

Deal with non-routine enquiries providing advice as necessary

Analyse and report on a range of options in order to contribute to decision making and action planning

Provide support and input into how data quality and integrity can be maintained as part of business improvement plans

Provide support in responding to information requests and parliamentary questions

Implements business intelligence policies and proposes changes to user working practices and procedures e.g. when planning for new projects, changes in legislation, new reporting processes, new training programmes impacting across the organisation.

Continuous improvement of data collection and modelling processes to ensure future fit for purpose

Communications and Engagement

Provide and receive complex, sensitive information

Communicate complicated, difficult to explain issues to non-technical staff

Present comprehensive reports and analysis of data gathered to the NIHR Academy Executive Board and other stakeholders

Build relationships with end users to ensure that the BI function provides the tools that they require

Contribute to cross-NIHR meetings and groups, effectively communicating information relating to NIHR Academy

Technical

Use appropriate BI tools to access and analyse data

Provide server side infrastructure support to the BI Manager to ensure reporting and BI tools continue to be available at all times

Plan and implement projects appropriate to the role

Achieve agreed objectives, working within professional policies, acting as a specialist in own area

Qualifications

Essential

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

Desirable

• Masters degree in a science, mathematics or computing discipline or equivalent

Experience

Essential

• Advanced knowledge of Microsoft Excel
• 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
• Well-developed knowledge and experience of operating and utilising information systems and software applications
• Experience of drafting reports or manuscripts
• Experience creating plans for BI solutions
• Specialist business intelligence knowledge and expertise acquired through degree level or equivalent qualification/experience

Desirable

• 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)
• Experience developing and scripting with QlikView
• Experience developing SSIS routines

Skills & Behaviours

Essential

• 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
• 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
• Excellent time management and organisational skills, with the ability to work both independently and as part of a team
• Ability to set goals and standards
• Ability to take personal responsibility
• Excellent verbally and in written communications
• Ability to give, receive and seek advice to/from peers and wider NIHR Academy executive
• Ability to work accurately with attention to detail
• Use of BI tool sets such as QlikView and SQL
• 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

Desirable

• 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
• Understanding of Source or Change Control processes
• Understanding of Relational database administration and maintenance routines

practical skills or Additional Requirements

Essential

• Understanding of Business Intelligence terminology and processes
• Understanding of Relational Databases
• An understanding of data protection and information governance including GDPR and the importance of reporting standards and report definitions
• Highly motivated