Data Analyst

The Housing Network; Luton; On-site; GBP 30,000 - 45,000; Full time

Job summary

A leading housing organization in Luton is seeking a data analyst to support its data-driven decision-making process. The ideal candidate will excel in data manipulation and visualization, providing actionable insights through reports and analysis to facilitate organizational growth. Proficiency in Excel and familiarity with data analysis tools like Power BI and SQL is essential for success in this role.

Qualifications

• Experience in social housing, local government, or letting agencies is preferred.
• Basic knowledge of SQL or Python for data querying is desirable.
• Understanding of data protection principles.

Responsibilities

• Provide regular reporting packs to public bodies.
• Prepare and automate monthly management packs.
• Support decision-making by analyzing data.

Skills

Data manipulation

Data analysis with strong attention to detail

Data visualization and presentation

Problem solving and innovative thinking

Supporting business decisions

Tools

Excel

Power BI

Tableau

SQL

Python

Job description

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, drive improvements, and 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, defect management, root cause analysis, 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, engaging, and effective way to maximize organisational outcomes.

Additionally, the role will lead the creation of specific management information outputs (in prescribed formats) for key external stakeholders, ensuring data accuracy and timeliness aligned with service level agreements and expectations.

As part of our commitment to organisational development, growth, and data-led decision-making, we are investing heavily in new ICT systems. This role will support and facilitate this transition, working with departmental leads and data owners to ensure a smooth process.

Main Duties: What needs to be done?

1. Provide regular reporting packs to the various public bodies we work with.
2. Prepare and automate monthly management packs with detailed business and financial analysis and insights.
3. Provide statistical information and insights for business development and profile raising.
4. Support decision-making by analyzing data to understand business drivers and evaluate ongoing initiatives.
5. Work with management to develop forecasts.
6. Assist in generating and analyzing customer satisfaction surveys.
7. Collaborate with departments to improve data quality and accessibility, providing insights to support operations.
8. Support ad hoc projects, such as reporting on property pipelines and new business expansions.
9. Assist in migrating data from legacy systems into Omniledger or other platforms.
10. Establish and document processes for extracting information from various data sources.
11. Coordinate with external IT support to ensure data accuracy and consistency in Omniledger.
12. Train finance and other teams on Power BI.

Competencies: Who with and your skill level?

Skills & Experience

• Data manipulation
• Data analysis with strong attention to detail
• Data visualization and presentation, ensuring source data consistency
• Problem solving and innovative thinking
• Supporting business decisions through understanding financial and growth drivers

Desirable Skills

• Experience in social housing, local government, or letting agencies
• Basic knowledge of SQL or Python for data querying
• Understanding data protection principles

Knowledge

• Proficiency in Excel and familiarity with data sources
• Understanding of data manipulation and visualization software (e.g., Tableau, SQL, Python, PowerBI)
• Excellent communication and presentation skills

Behaviour

• Organized and logical
• Pragmatic, accepting data imperfections
• Proactive, initiating improvements
• Self-motivated, working independently
• Deadline-oriented
• Collaborative, providing data for business improvements
• Confident to challenge assumptions
• Continuous learner, understanding business and technical best practices

At all times, you should:

• Act with integrity
• Exercise skill, care, and diligence
• Maintain professionalism
• Be cooperative with colleagues