We are seeking a detail-oriented and analytical Business & Finance Analyst to support budgeting activities and finance process improvement initiatives for a luxury retail client. The role involves supporting financial planning and reporting, analysing data, reviewing and optimising complex Excel models, and documenting key finance processes. Working closely with business stakeholders, the successful candidate will contribute to budgeting cycles, variance analysis, process documentation, and operational efficiency improvements in a dynamic business environment.

Key Responsibilities & Capacity Breakdown

• Financial Modeling & Excel Optimization (40%):
  • Review, audit, and simplify large, complex Excel financial models featuring multiple linked tabs and macros.
  • Streamline workbook architecture to eliminate manual work steps, improve model performance, and reduce calculation errors.
  • Build and maintain robust financial models, scenarios, and ad-hoc data analysis to support strategic decision-making.
• BAU & Peak Budget Support (30%):
  • Support the annual budgeting, forecasting, and financial planning process across business units.
  • Assist with month-end financial reviews, variance analysis (Actuals vs. Budget), and routine BAU management reporting.
• Process Documentation & Projects (30%):
  • Document key financial workflows, standard operating procedures (SOPs), and data lineage for ongoing finance transformation initiatives.
  • Identify operational bottlenecks and recommend process improvements to ensure long-term data integrity and efficiency.

Key Requirements

• Experience: Experience in financial analysis, budgeting, forecasting, or management reporting.
• Advanced Excel Mastery: Expert-level proficiency in Excel (complex formulas, index/match, nested logic, linked workbooks, and working knowledge/debugging of VBA/Macros).
• Process Improvement Mindset: Proven track record of auditing "heavy/fragile" Excel files and simplifying them into automated, user-friendly structures.
• Financial Acumen: Solid understanding of financial statements, budgeting frameworks, and corporate financial principles.
• Documentation & Analytical Skills: Strong capability to map out complex financial processes clearly and synthesize large datasets into actionable insights.
• Fresh graduates with relevant internship or part-time experience are encouraged to apply.