Finance Analyst

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: 1-3 years of experience in financial analysis, budgeting, forecasting, or management reporting.
• Advanced Excel Mastery (Must-Have): 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.
• Language: Professional fluency in English (written and spoken); Cantonese or Mandarin is an advantage.