Housing Systems and Data Lead

Respond!; Dublin; On-site; EUR 58,000 - 75,000; Full time

Job summary

Respond!, a leading housing association in Ireland, seeks a Housing Systems and Data Lead to manage housing systems, data governance and BI reporting. You will work with ICT, Housing and Finance to implement system enhancements, ensure data quality and support performance reporting.

The role requires strong experience with Aareon ActiveH, SQL Server and Power BI, and offers a permanent full-time position in Dublin with hybrid/work-from-home flexibility as required.

Qualifications

• Minimum five years’ experience in the social housing sector.
• Extensive experience with housing management and asset management systems.
• Proven experience with Aareon ActiveH and reporting.
• Strong SQL Server skills and advanced Excel (Power Query/Power Pivot/VBA).
• Experience developing reports and dashboards using Power BI or similar tools.

Responsibilities

• Housing Systems Management and Technical Support: provide specialist support for housing management and asset management systems, focusing on Aareon ActiveH.
• Data Management, Data Quality and Governance: lead data validation, cleansing and quality assurance activities across datasets.
• SQL, Reporting and Business Intelligence: develop, maintain and optimise SQL queries and reporting extracts; support BI dashboards.
• Asset Management and Stock Data: support management and reporting of asset data, maintenance, compliance and stock information.
• Business Process Improvement and Workflow Design: map requirements and translate them into practical technical specifications and workflows.
• Project Support and Implementation: support systems, data, reporting and digital transformation projects; assist with testing and rollout.
• Stakeholder Engagement and User Support: collaborate with teams to understand needs and provide guidance on systems and data.

Skills

SQL Server

Power BI

Excel

Data governance

Housing systems

Aareon ActiveH

Education

Relevant degree or professional qualification in IT, Data, Housing or Asset Management

Tools

SQL Server

Power BI

Aareon ActiveH

Excel

Job description

Location: On site / Dublin, Ireland
job type: Permanent / Full-time
Sector and subsector: Non-profit Organizations | Programme Operations
Annual Salary range:from € 57,622.00 to € 74,570.00

Respond is one of the largest housing associations in Ireland, providing social housing and homeless services. Our vision is that ‘every family and individual in Ireland will have high-quality housing as part of a vibrant and caring community’. We are growing rapidly in response to the housing crisis and are now looking for the right person who has the passion and skills to help us realise our vision.

Respond is committed to equal employment and growing a diverse workforce. If you do not “tick every box” there are likely other valuable attributes and skills that you have, that would make you a great fit for the organisation. We welcome applications from people of all cultures, nationalities, genders and from anyone who has historically faced social exclusion. If you feel this role is for you, then please apply.

Role: Housing Systems and Data Lead

Location: Dublin or Midlands / Hybrid

Reporting To:Housing Quality, Performance & Systems Manager

Terms: Permanent Full-Time (39 hours per week Mon-Fri)

Salary Range:€57,622 to €74,570 (Please note that offers are typically made at the beginning to mid-range of the advertised salary, based on skills and experience)

Job Purpose:

The Housing Systems and Data Lead is responsible for supporting the effective management, development and continuous improvement of housing systems, housing data, reporting structures and technical solutions across Housing Services.

The role provides specialist technical expertise in housing management systems, Aareon ActiveH, SQL Server, data management, reporting, data quality, asset management information and business intelligence. The postholder will ensure that systems and data are reliable, accurate, secure and capable of supporting operational delivery, performance management, regulatory reporting and evidence-based decision-making.

The postholder will work closely with operational teams, ICT, Asset Management, Housing, Finance and other stakeholders to understand requirements, improve processes, deliver system enhancements and provide practical technical solutions that support service quality, compliance, efficiency and improved outcomes for tenants and service users.

Key Responsibilities:

Housing Systems Management and Technical Support

• Provide specialist support for housing management and asset management systems, with a particular focus on Aareon ActiveH and associated reporting structures.
• Support system configuration, user requirements, data structures, workflows, interfaces and operational system improvements.
• Work with users to identify system issues, process gaps and opportunities to improve functionality and user experience.
• Provide practical technical solutions that support effective housing operations, performance reporting and service improvement.
• Maintain strong working knowledge of system functionality, permissions, reporting fields and data structures.
• Support implementation, testing and rollout of system changes, enhancements and new modules.

Data Management, Data Quality and Governance

• Lead data validation, cleansing and quality assurance activities across housing and asset management datasets.
• Develop and maintain data quality checks, exception reports and controls to improve accuracy and consistency.
• Support the development of data definitions, reporting standards and data governance processes.
• Ensure data used for operational reporting, compliance returns and performance dashboards is accurate, complete and auditable.
• Support GDPR, information security and appropriate handling of personal and sensitive data.
• Promote good data discipline across Housing Services through guidance, reporting and user support.

SQL, Reporting and Business Intelligence

• Develop, maintain and optimise SQL queries, views, stored procedures and reporting extracts.
• Produce management information, statutory reports, operational reports and analytical outputs as required.
• Support the development of Power BI dashboards, Excel reporting tools and business intelligence solutions.
• Use data analysis to identify trends, risks, exceptions, performance issues and opportunities for service improvement.
• Ensure reporting outputs are clear, accurate, consistent and aligned with agreed definitions and business rules.
• Support KPI reporting, performance dashboards and senior management reporting requirements.

Asset Management and Stock Data

• Support the effective management and reporting of asset management data, planned maintenance data, compliance records and stock condition information.
• Assist with data structures linked to stock condition surveys, component lifecycles, planned works, compliance programmes and asset-related reporting.
• Support data validation, reporting and reconciliation between housing, asset and finance-related datasets where required.
• Provide analysis to support lifecycle costing, asset planning, compliance oversight and operational prioritisation.
• Work with Asset Management colleagues to improve the quality and availability of asset data for decision-making.

Business Process Improvement and Workflow Design

• Work directly with operational users to understand requirements, map processes and identify improvement opportunities.
• Translate business requirements into practical technical specifications, reporting solutions, workflow improvements and system enhancements.
• Support the design and implementation of improved business processes and system workflows.
• Challenge existing processes constructively and recommend more efficient, consistent and auditable ways of working.
• Contribute to project plans, testing scripts, implementation plans, user guidance and post-implementation reviews.

Project Support and Implementation

• Support systems, data, reporting and digital transformation projects across Housing Services.
• Contribute technical expertise to system upgrades, migrations, data cleansing projects, reporting developments and process improvement initiatives.
• Manage assigned tasks, deadlines and deliverables across multiple projects and priorities.
• Support user acceptance testing, issue resolution, change control and implementation activities.
• Ensure project outputs are documented, tested and embedded into operational practice.

Stakeholder Engagement and User Support

• Work collaboratively with operational teams to understand system and reporting needs.
• Communicate technical concepts clearly to non-technical audiences.
• Provide guidance, advice and support to staff on systems, data and reporting matters.
• Build effective working relationships with ICT, Housing, Asset Management, Finance and other teams.
• Support the development of user guidance, process notes and technical documentation.
• Contribute to a positive, solution-focused and service-oriented culture.

General:

• Demonstrate a commitment to own health, safety and wellbeing, and that of colleagues and tenants.
• Attend meetings outside core working hours where necessary.
• Undertake any other duties commensurate with the nature and level of the role.
• Contribute to audit readiness, evidence quality and continuous improvement across Housing Services.

Essential Criteria/Education Qualifications:

• Minimum five years’ experience working within the social housing sector.
• Extensive experience of housing management and asset management systems.
• Proven experience of working with Aareon ActiveH, including system configuration, database structures, reporting and data management.
• Strong SQL Server skills, including writing and optimising complex queries, stored procedures and views.
• Advanced Microsoft Excel skills, including Power Query, Power Pivot and VBA automation.
• Experience developing reports and dashboards using Power BI or similar business intelligence tools.
• Experience of data migration, validation, cleansing and quality assurance.
• Experience of asset management data, planned maintenance, compliance and stock condition information.
• Experience designing and implementing business processes and workflows.
• Experience producing management information and statutory reporting.
• Experience working directly with operational users to understand requirements and deliver practical solutions.
• Experience managing multiple projects and priorities.
• Relevant degree or professional qualification in IT, Data, Housing or Asset Management, or equivalent relevant experience.

Technical Knowledge:

• Data modelling and relational databases.
• Stock condition surveys and lifecycle costing.
• Data governance and data quality.
• Information security and GDPR.
• Housing business processes and regulatory reporting.

Desired Skills/Personal Attributes:

• Excellent analytical and problem-solving abilities, with the capacity to identify trends and provide meaningful business insight.
• Excellent attention to detail and a strong commitment to data accuracy.
• Ability to communicate technical concepts clearly to non-technical audiences.
• Strong report writing and presentation skills.
• Ability to translate business requirements into practical technical solutions.
• Excellent stakeholder management, organisational and time-management skills.
• Ability to challenge existing processes constructively and recommend improvements.
• Ability to work independently while supporting wider team objectives.
• Customer focused, logical, methodical, self-motivated and proactive.
• Professional, collaborative, adaptable and committed to delivering high-quality work.
• Knowledge of Azure, Microsoft SQL Reporting Services or Microsoft Fabric is desirable.
• Experience of Python or R, GIS or spatial data, PRINCE2, Agile, system implementation or digital transformation projects is desirable.

Experience:

The position requires a minimum of five years’ experience working within the social housing sector, together with substantial experience in housing systems, data management, reporting and business process improvement.