Salary
💰 $1,000 - $1,500 per month
About the role
- Support all FP&A work led by Department Head
- Provide comprehensive historical datasets to feed FP&A reports
- Support developing multi-layer structured Portfolio Modelling and Forecasts creation
- Provide supportive reports such as break-even, scenario-based and modelling reports
- Analyze and audit monthly financial results and update those in ongoing modelling phase
- Make monthly forecast-actual analysis and prepare Executive reports for explaining discrepancies
- Audit existing Financial Models for accuracy, functionality, reporting, simpleness and transparency perspective with other FP&A principles
- Develop management reports and automation
- Perform budgeting and forecasting and prepare sets of financial statements including cashflow
- Power BI and Excel Dashboarding and automation
- Support financial and functional due diligence requests for corporate transactions
- Prepare cash flow forecasts and long-term financial and statistical projections for strategic planning
- Build annual budgets and forecasts for business units and consolidate into a master budget
Requirements
- Bachelor’s degree or equivalent in Accounting, Finance, Mathematics, Business Administration, Economics, Data Modeling Sciences or a related field.
- 2-5 years progressive experience in financial analysis/modeling with data analysis in the financial lending or mortgage industry.
- Solid knowledge of the principles of general business, accounting, quantitative analysis and finance.
- Banking experience and background highly preferred
- High degree of proficiency in Excel, including complex financial analysis/modeling, Advanced VBA and SQL coding knowledge
- Advanced Excel knowledge (PMT, IRR and similar financial formulas)
- Ability to produce dashboards in Excel
- Experience with Power BI
- You must have your own laptop or desktop to use (the company does not supply equipment)
- Excellent English fluency, both written and verbal.