Senior Modelling Analyst

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.

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 maintain high standards regarding personal and organisational health, safety, and wellbeing.

• 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 level to meet tight delivery deadlines
• Performance management data analysis reporting
• Working with senior management and business partnering
• Collaboration in a team environment

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.