Local Gov't Housing Data Analyst (Temp: West London)

Adecco; City Of London; Hybrid; GBP 60,000 - 80,000; Full time

Job summary

A leading staffing agency is seeking a Data Analyst to join a Local Government's homelessness department in London. This full-time temporary role involves analyzing data to provide management insight and financial control. The successful candidate will work on data quality, create dashboards using Power BI, and engage with stakeholders. An ideal candidate should have expertise in SQL and Business Intelligence tools. The position offers a hybrid work model, with 1-2 days in the office each week.

Qualifications

• Experience analysing data and providing insights.
• Knowledge of data quality assessment and cleansing.
• Substantial experience in local authority or housing organisation.

Responsibilities

• Design and debug SQL Server Integration Services.
• Create interactive dashboards and reports using Power BI.
• Transform raw data into meaningful insights.
• Work with business users to ensure data alignment.

Skills

Data analysis

SQL

Business Intelligence

Dashboard creation

Data visualisation

R

Python

Power BI

Tools

SSIS

Tableau

Job description

Local Gov't Housing Data Analyst (Temp: West London)

An exciting opportunity has emerged for a Data Analyst to join the homelessness department at one of Adecco's leading Local Government clients in a temporary role for the next six months, with potential extension beyond this. This is a full time role (36 hours per week, Monday to Friday) working hybridly from our client's West London office 1-2 days each week, and previous experience of working within a local government housing department would be highly desirable.

The role will be reporting directly into the Assistant Director Housing Demand/ Programme Director, and the work is analysing data in the service to provide management insight and is core to financial control within housing demand. It will assist in providing accurate budgetary forecasting and analysis of their cohort in temporary accommodation, and those households presenting as homeless, and will enable the effective prioritisation of project work to manage spend within the directorate as well as improve outcomes for residents.

There are data quality issues within our client's systems, so this role would need to actively understand the accuracy of the data, cross-compare sources and potentially do other investigatory work to provide a view about reliability, as well as identify ways to data cleanse and resolve some of the issues identified.

Key Responsibilities

• Designing, developing, testing and debugging SQL Server Integration Services (SSIS) against BI Power reports
• Providing technical support to interpret business and service needs enabling new and improved reports
• Being an expert for the housing business, when discussing the use of Big Data and explaining the stories the data evidences against report outputs
• Providing drive optimal, innovative, scalable and high performing solutions for Business Intelligence and Visualisation, as part of a broader Data and Analytics portfolio
• Working with business & IT partners to understand data, improve the data and deliver informative solution visually which integrates backend data base
• Influencing and educating business users to ensure data is accurate and evidences alignment to business deliverables and targets
• Guiding and leading solution delivery for Business Intelligence and Visualisation of data
• Working with functional and technical associates to gather, refine business requirements, provide technical support/consulting, plan and prioritise work, coordinate the estimation and quotation for work to be done by various teams
• Building out using SQL and progress databases for Power BI reports
• Transforming raw data into meaningful insights
• Producing interactive and user-friendly dashboards and reports
• Performing a wide range of tasks such as reporting, building dashboards, building data models, analysing datasets, and administration of Power BI tools
• Must have extensive knowledge and expertise in business intelligence, databases, and technical aspects of BI tools
• Experience in data preparation, data gateway, and data warehousing projects
• Experience working with the Microsoft Business Intelligence Stack (Power BI, SSAS, SSRS, and SSIS)
• Experience with a self-service tool such as Power BI or Tableau
• Understanding of SQL, and an ability to produce reports with direct backend data feeds to support updates

Key Relationships

• Strategy and Change colleagues, as well as those in other parts of the organisation
• External organisations and partners such as the NHS Borough-Based partnership, Office for National Statistics, the Greater London Authority, and the London Office of Technology and Innovation
• External providers/consultancies
• Local Government networks and employer bodies
• Councillors

The ideal candidate will be somebody who is an expert in understanding and applying a range of modern tools and techniques to analyse data, as well as excellent skills in querying and reporting on datasets through modern tools such as R, Python etc, including creating dashboards and visualisations.

Substantial experience of working in data and analysis in a local authority or housing organisation would be highly desirable. Interviews will take place virtually before Christmas 2025, and applicants will ideally be immediately available or on a short notice period (1-2 weeks' maximum).

Only applicants who feel they meet the above criteria need apply.