Description:
We are seeking a dedicated financial modeler to join our growing Commercial Finance team. You will need to have excellent technical skill of Excel (or similar software) and use that to create complex financial models. The financial models will primarily be used to perform profitability analysis for multi-year customer agreements and other strategic projects. The KPIs produced by the model (e.g. NPV, IRR, ROI, payback, profit margin and cashflow) will be used by the business to determine the financial viability of the business proposal.
Your duties will include creating financial models and templates in collaboration with key business stakeholders across various functions. This role reports directly to the Commercial Finance Director.
Responsibilities
- Use Excel to create high-quality financial model for evaluating profitability of customer agreements and projects.
- Working with cross-functional teams (e.g. Sales, RGM, Finance and Supply Chain) to obtain requirements and ensure sound logics are built in the model.
- Support User Acceptance Testing (UAT) of the model with key users before model goes live.
- Financial models will require the following elements:
- Functionality that enable evaluation of risks and opportunities with sensitivity analysis (i.e. “what if” scenario analysis)
- Model will involve extensive data inputs from various sources and complex calculations in the backend with a user-friendly frontend interface that allows users to select variables and enter inputs with clarity.
- Checks-and-balances functionality to determine reasonability of the inputs.
- Model will generate a clear financial summary with KPIs that is easy to understand by the business.
- Mechanics for updating actual performance to support post evaluation of the business proposal.
Qualifications
- Bachelor’s degree in accounting, finance, mathematics or data analytics preferred.
- Excellent/Expert Excel skills or experience with similar spreadsheet software, including the use of charts, macros, and VBA
- Knowledge of basic accounting concepts and a solid understanding of financial analysis terminology.
- A keen eye for detail and an ability to sift through large data sets to extract meaningful information.
- Excellent time management skills, including the ability to work under pressure to meet tight deadlines