Data Analyst Apprentice

6 days left

Regulator of Social Housing
City Tower, Piccadilly Plaza, Manchester, M1 4BT
£15,000.00 - £18,000.00 annually
25 Oct 2019
24 Nov 2019
Role Type
Apprenticeship, Higher
Start Date
Under the close guidance of the Data Manager, you will play a supporting role in managing the systems that collect regulatory data from private registered providers of social housing, compiling data in tools and formats that can be readily used by regulatory colleagues and the public.

The role will support the wider Business Intelligence team to deliver its objectives in relation to data systems, financial analysis and modelling of the sector, design and management of financial data sets and tools, and value for money. This in turn contributes to the delivery of the Regulator of Social Housing's (RSH) principal focus to promote a viable, efficient and well-governed social housing sector able to deliver homes that meet a range of needs.

The successful candidate will have excellent attention to detail, organisational skills and be familiar with using standard Microsoft Office package (including Excel). They will be able to demonstrate an understanding of basic analytical techniques and possess good verbal and written communication skills.

Your duties and responsibilities in this role will consist of:

  • Support the delivery and development of data collection systems commissioned by the RSH, liaising directly with Homes England digital services and helpdesk facility where necessary (running the NROSH+ system)
  • Support the Data Team by contributing to the guidance for survey collections, with a view to increase the quality of incoming data
  • Contribute to analysis by compiling data in tools and formats that can be readily used by regulators and the public and support the response to ad hoc queries from internal and external stakeholders, as required, sometimes under tight timescales

Main Duties:
  • Working within the Data Team, liaise with data system suppliers and regulators to specify and improve data collection returns focusing specifically on the collection of the Statistical Data Return (SDR). Reviewing existing specifications and determining new/ improvements to current validations to ensure that the collection of data in 2019/20 is fit for purpose and meeting regulatory needs. This will include reviewing guidance for multiple surveys to ensure consistency
  • Participate in the testing of data collection systems to ensure they are fit for purpose. This will include reviewing test plans, conducting testing on delivered systems (by inputting test data and ensuring the delivered systems matches the specifications provided)
  • Input into the cleaning and querying of data coming into the NROSH+ system (principally the Statistical Data Return (SDR)). Reviewing the submission monitoring tool and linking data from other sources to provide a basis by which to contact providers with queries. Contacting providers to query anomalous data. Working with RSH colleagues to ensure consistency in advice and classifications
  • Review existing guidance for consistency and, using feedback from colleagues on the delivery of the SDR, consider changes to make questions and guidance clearer and hence improve data quality
  • Contribute to the production of high quality and timely analysis on sector risks to provide intelligence and support the work of front-line regulators, providers and wider stakeholders, including predictive work to identify likely key trends in the social housing market and financial risks to social housing providers
  • Matching data from the NROSH+ system and the RSH's internal CRM system (Dynamics) to enable checking of the NROSH+ population and consistency of contact information and to generate contact lists for the organisation (based on size or type of organisation)
  • Working with large amounts of data, and migrating data from MS Access to other analytical software, generate analysis and analytical tools sometimes to tight deadlines, generally using MS Excel but sometimes using other tools (e.g. GIS, FME or statistical software). This will also include working on a User Interface for data manipulation, enabling efficient access to pre-filtered data (filtered by area, Registered Provider types or stock type for example)
  • Communicate and disseminate analytical outputs as required, ensuring data and outputs meet appropriate guidelines (including General Data Protection Regulations) and principles (including the UK Statistics Authority guidelines). Liaise closely across directorates with regulation staff to ensure that data analysis work supports the regulatory needs

Requirements and prospects

Desired skills

  • Intermediate level Microsoft Office capability - Outlook, Word, Excel and PowerPoint
  • Highly numerate, understanding of basic analytical processes
  • Planning and time management skills
  • Logical and creative thinking
  • Analytical and problem solving

Personal qualities

  • Ability to work independently and to take responsibility
  • Can use own initiative
  • A thorough and organised approach
  • Ability to work with a range of internal and external people
  • Ability to communicate effectively in a variety of situations
  • Maintain productive, professional and secure working environment

Desired qualifications

  • 5 GCSEs grades A*-C/9-4, or equivalent qualifications, including English Language and maths
  • 2 A-levels or equivalent qualifications

Future prospects

  • Opportunity for a full-time position

Similar jobs

More searches like this

Similar jobs