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 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, 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.
:quality(80))
:quality(80))
:quality(80))