Panoramic Associates are currently working with a London-based council in recruiting an Asset Information Analyst to join the Asset Management Team. This is a hybrid role offering a 6-month contract to start with.
Key Responsibilities:
1. Maintain and develop data systems and business processes to support asset management of social housing stock.
2. Design, write, and run reports using Power Query (Power BI/Excel), SQL, Server Reporting Services, and VBA .
3. Assist in data modelling, automation, and reporting to support strategic decision-making.
4. Ensure data accuracy for statutory returns, stock condition assessments, and compliance monitoring.
5. Support planned works programmes by analysing stock condition data, repairs history, and survey feedback.
6. Manage compliance data related to gas safety, electrical testing, fire protection, lift inspections, and water quality .
7. Act as the first line of support for Asset Information Systems, providing troubleshooting, training, and user support.
Experience & Skills Required:
8. Advanced IT skills with expertise in SQL, Power Query, Excel, VBA, and Microsoft Access .
9. Proven experience in data retrieval, analysis, reporting, and quality assurance .
10. Strong ability to interpret complex technical documentation and follow instructions accurately.
11. Excellent problem-solving skills with a flexible approach to evolving work priorities.
12. Strong communication skills, both written and verbal, with a commitment to providing a high-quality service.
13. Ability to work independently, meet deadlines under pressure, and maintain confidentiality.