Job Description

Job title:Data and Business Intelligence Developer

Reporting to:Data and BI Manager

Job family:Technology

Pay level:C2

Role Purpose

To assist the Data and Business Intelligence Manager in providing support for all the NMC’s key data sources and applying high level skills in producing complex reporting, business intelligence and management information and in depth system and database analysis.

Key Accountabilities

●Works as a key part of the data improvement programme helping to refine and implement the strategy and ensure our key characteristics of data quality are recognised and adhered to (accuracy, timeliness, completeness, validity, consistency)

●Understands all the data stores within the applications of the NMC.

●Works with suppliers to ensure that systems and data stores are managed effectively to support the data needs of the business e.g. integrity, availability, capacity

●Assists in the maintenance of the data warehouse capability, and it’s rollout and use throughout the business

●Provides a coherent and timely reporting function to the business.

Data Input and Data Integrity

  • Promote and monitor the accuracy of information inputted within any and all NMC systems
  • Contribute to and performregular quality assurance activities across all reporting and data activities.
  • Be a central point of contact for business areas in order to provide support and training in use of data and reporting capability.

Data outputs

  • Assist Data and BI Manager to identify and undertake analysis of issues and trends emerging from the data.
  • Provide reports to the Data and BI Manager in relation to volumes of work and task allocation.
  • Assist Data and BI Manager in extracting and producing data for annual reports, half yearly and quarterly review reports for the regulator, meeting deadlines agreed by the business.
  • Assist Data and BI Manager with highly complex management information and KPI reports required by the business on a monthly basis.
  • To implement new reports based on business requirements and develop new quality assurance processes.
  • Maintain a report library of all reporting services (SSRS) reports implemented.
  • Provide complex reports, undertaking a wide range of data analysis using SQL and Excel.
  • Ensure all reports are provided with an accurate methodology helping users understanding the concepts with data.

Freedom of Information requests

  • Acknowledge and understand requests from the Freedom of Information Team.
  • Liaise with Data and BI Manager on the disclosure of data and where possible produce and provide reports on the requested requirements within the FoI Act deadlines.

Support to Data and BI Manager

  • Provide training and support to other Data and BI analysts, ensuring processes are followed and system changes are accurately documented and updated within the team’s SOPs log.
  • Deputise during any absence of the Data Information Manager:

Other Responsibilities

There are a number of standard duties and responsibilities that all employees, irrespective of their role and level of seniority within the NMC, are expected to be familiar with and adhere to:

  • To comply at all times with the requirements of Health and Safety Regulations to ensure their own wellbeing and that of their colleagues
  • To promote and comply with NMC policies on diversity and equality both in the delivery of services and treatment of others
  • To ensure confidentiality at all times, only releasing confidential information obtained during the course of employment to those acting in an official capacity in accordance with the provisions of the Data Protection Act and its amendments
  • To comply with NMC protocols on the appropriate use of telephone, email and internet facilities
  • To comply with the principles of risk management in relation to individual and corporate responsibilities
  • To comply with NMC policies and procedures as compiled on the organisation’s intranet

This job description is not exhaustive and as such, the postholder will be expected to be flexible, and any changes will only be made following a discussion with the postholder.

Person Specification

Qualifications and Experience

  • Educated to a degree level
  • Proven knowledge in etl tools, data warehousing techniques and data dashboards.
  • Proven experience of producing and analysing statistics and report production
  • Experience of data integrity checks and rules
  • Essential skills:
  • SQL 2005/2008/2012 platform and associated tools ( Extensive experience )
  • SSIS/SSAS/SSRS
  • Advance level skill for MDX, Dax, OLAP
  • Business analytic tools like PowerBI, Power Pivot, Power Query, Power View or similar tools
  • Knowledge of Power BI solutions using SSAS AND ETL Tools such as WhereSpace and SSIS
  • Good track record of managing own workload
  • Experience of working with a range of stakeholders

Skills, Knowledge and Abilities

  • Good research and analytical skills, business analysis skills would be an advantage.
  • Able to recognise and suggest improvements to existing systems
  • Excellent time management and organisational skills with the ability to achieve results within tight deadlines
  • Good verbal and written communication skills with all stakeholders
  • Excellent attention to detail
  • Good problem solving skills

Personal Qualities

  • Highly organised with good attention to detail.
  • A good team player
  • Highly motivated and flexible
  • A commitment to an understanding of the importance of equality and diversity within the environment that the NMC operates

Page 1 of 5