Data Analyst

Role Overview - What is it?

This role is a key element of our organisational focus and commitment to using data as a valuable tool to support our understanding of performance, to drive improvements; and also communicate our impact, to support our ambitious growth journey.

Working across our full suite of internal systems the role will incorporate all aspects of the data analysis function, including data cleansing and defect management, root cause analysis and process review, data collation and manipulation.

Using this raw data the role will identify and develop opportunities to use and present data in an innovative, visibly engaging and effective way to maximise wider organisational outcomes.

Alongside this, the role will lead on the creation of specific management information outputs (in prescribed formats) for key external stakeholders. Ensuring the accuracy and timeliness of the data is fully aligned to the relevant service level agreements and expectations.

As part of our overall commitment to organisational development, growth and data-led decision making we are investing heavily into new ICT systems. This role will play a significant part in supporting and mobilising this process, working across the organisation to support departmental leads and data-owners, to ensure the most positive transition process.

Main Duties - What needs to be done?

• Provide regular reporting packs to the various public bodies that we work with
• Prepare and automate monthly management pack with detailed business and financial analysis and insights
• Provide statistical information and insights that can be used for business development and profile raising purposes
• Support decision making within the business by analysing data for a better understanding of the business drivers and appraisal of results of ongoing initiatives
• Work with the management team to develop forecasts
• Support across the business to generate and analyse customer satisfaction surveys
• Work with all departments and other internal teams to identify how we can improve the quality and accessibility of our data and provide data insights to team operations.
• Support ad hoc projects such as reporting on property pipeline and deployment for new other business expansions
• Support migration of data from legacy systems into Omniledger or others
• Establish and document processes to obtain information from various data sources
• Work with external IT support to ensure Omniledger data accuracy and consistency
• Train members of the finance and other teams on Power BI

Competencies - Who with and your skill level?

Skills & Experience

• Data manipulation
• Data analysis and strong attention to detail
• Visualisation and presentation of data with reconciliation back to source systems to assure consistency
• Problem solving and innovation
• Strong business decision support through knowledge of key financial and growth drivers of the business

Desirable Skills

• Experience working in or with the social housing sector, local government or a letting agency
• Exposure to SQL or Python for basic data querying or analysis
• Understanding of data protection principles

Knowledge

• Substantial knowledge of Excel and other data sources
• A good understanding of data manipulation and visualisation software (eg Tableau/SQL/Python/PowerBI)
• Excellent communication and presentation skills so that data can be presented in a user friendly and engaging manner

Behaviour

• Deeply organised and logical approach
• Pragmatic, recognising that date set may be imperfect
• Proactive and prepared to initiate and recommend changes
• Self-starting and able to work with minimal supervision
• Works well to deadlines
• Work with other functions to identify and provide data needed for effective business changes or continued strong business performance
• Have confidence to challenge assumptions
• Appetite for continuous learning, including how the business works and external technical best practice
• We would expect you at all times to:

o act with integrity

o act with due skill, care and diligence

o act with professionalism

o be open and co-operative with colleagues