Nacar is seeking a part-time Financial Modeling Analyst to support business operations and strategic decision-making through accurate financial models. You will play a key role in building models from scratch and providing operational insights.
What You'll Do
- Design and develop dynamic financial models from scratch to support forecasting, budgeting, and strategic planning.
- Analyze business performance metrics and KPIs to identify trends, risks, and opportunities.
- Prepare revenue forecasts and scenario analyses to support business growth and operations.
- Utilize complex Excel formulas, including OFFSET, INDEX, MATCH, nested functions, and macros to enhance model functionality.
- Provide insights for operational efficiency, profitability, and long-term strategy.
- Improve existing financial processes, automate repetitive tasks, and ensure scalability of models.
- Create dashboards and trackers to monitor model outputs and key performance indicators over time.
What We're Looking For
- Proven experience in financial modeling and analysis.
- Advanced Excel skills, including pivot tables, OFFSET, INDEX/MATCH, dynamic ranges, and formula optimization.
- Strong understanding of business operations, finance, and strategy.
- Ability to handle large data sets and perform accurate reconciliations.
- Excellent problem-solving, analytical, and communication skills.
- Ability to work independently and meet tight deadlines.
Nice to Have
- Experience with forecasting and scenario planning.
- Familiarity with business intelligence tools (e.g., Power BI, Tableau).
- Knowledge of financial planning & analysis (FP&A) best practices.
Technical Stack
- Excel
- Power BI
- Tableau
Work Mode
This is a remote position.
Nacar is an equal opportunity employer.
