Role Overview
Position: Senior Modelling Analyst
Department: Corporate Finance & Treasury
Location: 159-161 Upper Sheriff Street (Hybrid)
Contract type: Permanent
Salary: €55k – €65k (Depending on skills and experience)
The Department is led by the Chief Finance Officer (CFO) and comprises of the following functions:
- Financial Reporting & Transactional Finance
- Business Partnering
- Corporate Finance & Treasury
- Risk & Assurance
- Procurement
The Finance Department provides a range of services in support of Clúid’s primary mission “quality housing and services to enable people to create homes and thriving communities”. It is led by the Chief Finance Officer and supported by the Head of Finance, Head of Procurement, Head of Corporate Finance & Treasury and Head of Risk & Assurance.
The Modelling Senior Analyst is an essential operational role within the Corporate Finance & Treasury team. This position is designed for a hands-on, detail-oriented analyst who will be actively involved in the financial assessment and consultation process for new housing schemes and investment opportunities.
The successful candidate must demonstrate a strong understanding of financial modelling concepts, including the interconnectivity of the three core financial statements, and be capable of applying this knowledge in a practical business context. The role will also support model design, maintenance, scenario testing, and peer-review frameworks. This position requires an analyst who enjoys working cross-functionally, interrogating operational data, and directly contributing to project delivery timelines.
Key Responsibilities
Housing Scheme Assessments & Operational Execution - Scheme Applications: Manage and lead the end to end preparation and submission of external funding applications, ensuring accuracy and timely delivery, while collaborating with Finance colleagues to compile scheme specific financials and partnering with the Commercial Development team to ensure all submissions are complete, compliant, and aligned with organisational priorities.
- Scheme Applications: Ensure all external funding awards are accurately communicated to Finance, Legal, and the Commercial Development team in a timely manner.
- Stakeholder Consultation: Collaborate closely with the Commercial Development and Property Services teams to gather, verify, and input operational data into assessment models, providing feedback to colleagues model updates through training.
- Viability Analysis: Work closely with Finance colleagues to ensure all funding received is reconciled against approved awards and effectively monitored throughout the scheme delivery timeframe.
- Scheme Analysis: Understand the local market and business environment that Clúid is operating within and evaluate scheme funding structures, cash flows, and value-for-money outcomes, as required.
- Scheme Data Inputs: Assist with operational data updates, reforecasting exercises, and scheme reassessments as macro-economic and funding assumptions change, as required.
Financial Modelling Application & Governance Support - Model Utilisation: Apply, build, adapt, and run existing financial models used in scheme assessments, ensuring outputs are logically consistent, clearly understood, and aligned with underlying financial assumptions.
- Financial Modelling Literacy: Demonstrate a clear understanding of integrated financial modelling, including the linkages between profit and loss, cash flow, and balance sheet, and apply this understanding when reviewing and interpreting model outputs.
- Business Planning Redundancy: Cross-train on Clúid’s long-term business planning tools, providing essential operational backup capability on the 30-year corporate business plan to mitigate key-person risk.
- Ad-Hoc Analysis: Efficiently respond to modelling requests and scenario iterations from senior management.
- The "Four-Eye" Governance Check: Act as a critical second set of eyes within the Corporate Finance & Treasury team, performing validation, integrity testing, and peer reviews on complex model outputs and board scenario iterations.
Other - Assist the Chief Finance Officer, Head of Corporate Finance & Treasury and Finance Managers with additional reporting/projects as required.
- Maintain and further develop key internal/external business relationships.
- Assist others in the Finance team to ensure smooth reporting process and meeting all Finance deadlines.
- Ensure that all project work, data modelling, and supporting data and financial reporting information are shared and stored on Clúid’s file servers in-line with the Finance Department’s established procedures.
- Attend continuing professional training as required by your profession’s governing body or your Learning & Development plan.
Corporate Responsibilities - Ensure all activity is aligned to Clúid’s values and contributes to the mission of supporting thriving communities.
- Adhere to all Clúid policies, procedures, and governance requirements at all times.
- Exercise discretion and maintainhigh standardsregarding personal and organisational health, safety, and wellbeing.
Person Specification
Essential Skills: - Advanced Excel and financial modelling: strong understanding of integrated financial models, including the ability to build or interpret a three-statement model and clearly demonstrate the linkages between income statement, cash flow, and balance sheet.
- Investment appraisal: Forecast cashflow, calculate DCF, NPV, and other metrics
- Analytical skills: deconstruct complex, unstructured data into logical components and be able to identify errors and variances
- Commercial acumen: Understand the impact of interest rate, costs, and inflation on long-term viability of housing projects
- Excellent communication skills, verbal, written, report writing, presentation
- Attention to detail: Ensure high level of accuracy in calculations and be aware of the impact of a single cell error on the long-term forecast. Build checks where necessary to identify and fix errors.
- Adaptability: Be able to learn and adapt to new tools for business planning, project management, etc.
- Plan and organise at organisation and personal levelto meet tight delivery deadlines
- Performance management data analysis reporting
- Working with senior management and business partnering
- Collaborationin a team environment
Experience/Qualifications
Essential Knowledge & Experience: - Post Graduate Degree in Finance
- 2 to 3 years of professional financial modelling experience
- Proven work with complex data in a highly operational, fast-paced environment
- Application and review of financial models in a live business or project environment, with accountability for accuracy and outputs.
Desirable - Knowledge of the corporate finance environment of Approved Housing Body (AHB) sector
- Experience of working in a property orientated environment or similar SME, in particular the social housing sector
Join Us
At Clúid Housing, you're more than just an employee; you're part of a mission to create lasting social change. If you're ready to contribute to our vision of thriving communities, apply by Tuesday 21st July 5pm, and let's make a difference together. #LI-Hybrid
About us
Clúid is at the forefront of providing affordable, quality housing in Ireland, with a vision to create communities where everyone has a great place to live. We're looking for talented individuals passionate about making a tangible impact in people's lives and eager to contribute to social change.
Why Choose Clúid?
At Clúid, we believe that success is achieved through our dedicated and passionate team. Working with us, you'll enjoy:- Dynamic Working Environment: Thrive in a supportive, innovative, and collaborative workspace.
- Flexible Working Arrangements: We support work-life balance with flexible working options with Hybrid working options.
- Comprehensive Training and Development Opportunities: Grow professionally with our continuous learning opportunities.
- Employee Benefits: 25 days annual leave +3 additional days over Christmas and Good Friday, 10% Pension, VHI, Employee Assistance Programme, Bike to work, Tax Saver Travel, Sick Pay, Payment Income Protection, Paid Maternity Leave, Paid Paternity Leave.
- Inclusive Culture: Be part of an organisation that values diversity and inclusion, recognised with a Gold Award from Investors for Diversity.
