Senior Macro Analyst

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 maintain high standards regarding 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 level to meet tight delivery deadlines * Performance management data analysis reporting * Working with senior management and business partnering * Collaboration in 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 Agoda At Agoda, we bridge the world through travel. Our story began in 2005, when two lifelong friends and entrepreneurs, driven by their passion for travel, launched Agoda to make it easier for everyone to explore the world.     Today, we are part of Booking Holdings [NASDAQ: BKNG], with a diverse team of over 7,000 people from 90 countries, working together in offices around the globe. Every day, we connect people to destinations and experiences, with our great deals across our millions of hotels and holiday properties, flights, and experiences worldwide.   No two days are the same at Agoda. Data and technology are at the heart of our culture, fueling our curiosity and innovation. If you’re ready to begin your best journey and help build travel for the world, join us. *Contract extension possible based on performance, with additional benefits including a performance bonus and medical insurance* The Opportunity: Are you passionate about engineering automation solutions that improve efficiency, accuracy, and control at scale? Do you thrive in a fast-paced, data-driven environment? Agoda’s Finance Operations Excellence is seeking a VBA Automation Specialist to serve as a hands-on technical expert focused on designing, developing, and maintaining automation solutions for finance operations. You will play a key role in building robust tools and workflow automations, modernizing manual processes, and enabling a more scalable and controlled operating model across Finance.   Key Responsibilities: Automation Architecture & Development: * Design, develop, test, deploy, and maintain automation solutions using Advanced Excel, Macro/VBA, MS Access, SQL, Power Automate, FloQast, and Power Apps. * Build reliable, scalable, and well-structured solutions with a strong focus on maintainability, performance, control, and user usability. Finance Operations Solution Engineering: * Partner with Finance operations teams to understand process requirements, identify technical solution options * Engineer automations for high-volume and control-sensitive workflows across areas such as reconciliations, reporting, validation, close activities, and operational tracking. Data Processing & Logic Design: * Develop data models, query logic, input/output structures, and exception-handling routines using Excel, Access, and SQL. * Optimize existing tools by improving logic design, reducing processing time, strengthening validation layers, and enhancing auditability. Workflow Automation & Systems Enablement: * Build and enhance workflow-based solutions using Power Automate, FloQast, and Power Apps to reduce manual handoffs, improve process standardization, * Support stronger controls and transparency across finance operations. Technical Documentation & Change Control: Create and maintain high-quality technical documentation including solution design notes, process logic, code commenting, SOPs, testing evidence, version histories, and user guidance to ensure sustainable ownership and supportability. Issue Resolution & Continuous Improvement: * Troubleshoot defects, resolve production issues, support enhancement requests * Proactively identify opportunities to refactor or upgrade existing automations. * Contribute to improving development standards, documentation quality, and reusability of automation components.   What You’ll Need to Succeed: Technical & Functional Skills * Advanced proficiency in Excel, including complex formulas, structured models, large-volume data handling, and spreadsheet-based solution design. * Strong hands-on expertise in Macro/VBA automation coding, including development of modular, maintainable, and well-documented solutions. * Strong experience with MS Access and SQL for data storage, query development, data transformation, and reporting support. * Hands-on experience in workflow automation tools such as Power Automate, FloQast, and Power Apps. * Strong technical ability to convert business requirements into structured, reliable, and supportable automation solutions. * Good understanding of process controls, exception handling, validation design, and documentation practices in an operations environment. * Experience developing automation solutions in Finance operations environments is preferred. * Python-based automation, Tableau/Power BI, and ERP scripting experience are not a must but good to have. Behavioral Attributes * Strong structured problem-solving skills with the ability to diagnose issues logically and design practical technical solutions. * Well organized with strong attention to detail, especially in code structure, testing, versioning, and documentation. * Strong communication skills with the ability to work directly with Finance operations end-users to gather requirements, explain solutions, and support adoption. * Strong documentation discipline and a high standard for supportability, clarity, and technical quality. * Self-starter with a hands-on engineering mindset and the ability to independently manage technical deliverables in a fast-paced environment. * Adaptable, dependable, and comfortable balancing delivery speed with control and quality. Qualifications * Bachelor’s degree in a technical field such as Computer Science, Information Systems, Engineering, Data Analytics, or a related discipline. * 5+ years of relevant experience in automation development, VBA/Excel-based engineering, or related technical development roles. * Experience in developing automations for Finance operations is preferred. * Experience in a tech or e-commerce environment is an advantage. * Professional certifications or training in automation, analytics, systems development, or process improvement are a plus.   #India       PLEASE REVIEW OUR HIRING PROCESS GUIDELINES BEFORE YOUR INTERVIEW — CLICK HERE TO LEARN HOW INTERVIEWING AT AGODA WORKS.     DISCOVER MORE ABOUT WORKING AT AGODA * Agoda Careers https://careersatagoda.com * Facebook https://www.facebook.com/agodacareers/ * LinkedIn https://www.linkedin.com/company/agoda * YouTube https://www.youtube.com/agodalife   Equal Opportunity Employer  At Agoda, we pride ourselves on being a company represented by people of all different backgrounds and orientations. We prioritize attracting diverse talent and cultivating an inclusive environment that encourages collaboration and innovation. Employment at Agoda is based solely on a person’s merit and qualifications. We are committed to providing equal employment opportunity regardless of sex, age, race, color, national origin, religion, marital status, pregnancy, sexual orientation, gender identity, disability, citizenship, veteran or military status, and other legally protected characteristics. We will keep your application on file so that we can consider you for future vacancies and you can always ask to have your details removed from the file. For more details please read our privacy policy. Disclaimer We do not accept any terms or conditions, nor do we recognize any agency’s representation of a candidate, from unsolicited third-party or agency submissions. If we receive unsolicited or speculative CVs, we reserve the right to contact and hire the candidate directly without any obligation to pay a recruitment fee.