Local Gov't Housing Data Analyst (Temp: West London)
Posted 2 days ago by Adecco
£500 Per day
Undetermined
Hybrid
London, England, United Kingdom
Summary: An opportunity has arisen for a Data Analyst to join the homelessness department of a Local Government client in West London for a temporary six-month role, with the possibility of extension. The position involves analyzing data to provide management insights, assist in budgetary forecasting, and improve outcomes for residents. The role requires expertise in SQL, Power BI, and data analysis within a local government context. The ideal candidate should have substantial experience in data analysis and be proficient in modern data tools and techniques.
Key Responsibilities:
- Analyze data to provide management insight and assist in budgetary forecasting.
- Design, develop, test, and debug SQL Server Integration Services (SSIS) against BI Power reports.
- Provide technical support to interpret business and service needs for improved reporting.
- Transform raw data into meaningful insights and produce interactive dashboards and reports.
- Work with business and IT partners to improve data quality and deliver informative visual solutions.
- Influence and educate business users to ensure data accuracy and alignment with business targets.
- Guide and lead solution delivery for Business Intelligence and data visualization.
- Build out SQL and progress databases for Power BI reports.
- Perform a wide range of tasks including reporting, building dashboards, and data model administration.
- Collaborate with internal and external stakeholders to gather and refine business requirements.
Key Skills:
- Extensive knowledge of business intelligence, databases, and BI tools.
- Experience with Microsoft Business Intelligence Stack (Power BI, SSAS, SSRS, SSIS).
- Proficiency in SQL and ability to produce reports with backend data feeds.
- Experience in data preparation, data gateway, and data warehousing projects.
- Expertise in modern data analysis tools such as R and Python.
- Ability to create dashboards and visualizations.
- Strong analytical skills and experience in local authority or housing organization data analysis.
Salary (Rate): £500.00/daily
City: London
Country: United Kingdom
Working Arrangements: hybrid
IR35 Status: undetermined
Seniority Level: undetermined
Industry: IT
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.
Other key elements of this role include:
- 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.
- An ability to produce 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 (both internal & external) in this role will be with:
- 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.