Finance Analyst

Ambition Hong Kong
Full time Contract On-site HKD20000 - HKD30000 per annum

About the job

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.