Contractor Financial Modeling Specialist

We are seeking a Financial Modeling & Dashboard Specialist to provide expertise in developing sophisticated financial projection models, data analysis, and reporting solutions to support our organization's 10-year strategic development initiative.

This role requires deep experience in financial modeling, multi-year projections, and advanced Excel techniques to help guide our infrastructure and financial planning processes.

1. Financial Analysis & Modeling:
• Develop comprehensive 10-year financial projection models with multiple scenario capabilities
• Create dynamic dashboard reports for tracking key metrics and performance indicators
• Build integrated formulas for scenario analysis (V1, V2, V3 iterations) for strategic initiatives
• Design models for revenue stream analysis and debt retirement strategies
• Implement visualization tools for infrastructure projection models

1. Advanced Excel & Data Management:
• Utilize advanced Excel formulas, Power Query, Power Pivot, and VBA/Macros to develop sophisticated financial tools
• Create automated reporting systems for integrated strategy roadmaps
• Develop data validation and protection mechanisms for collaborative workflows
• Build dynamic dashboards with drill-down capabilities for leadership decision support
• Implement data integration frameworks between multiple financial systems

1. Strategic Financial Planning:
• Model capital investment planning scenarios and ROI projections
• Forecast revenue and expense patterns across multiple operational sites
• Develop maintenance reserve funding models and depreciation schedules
• Create financial feasibility assessments for expansion initiatives
• Design cash flow forecasting tools for multi-year planning horizons

1. Process Improvement & Training:
• Identify opportunities to streamline financial processes using Excel automation, macros, and Power Query
• Train staff on best practices in financial modeling and reporting
• Support the implementation of financial software tools that integrate with Excel for efficiency

Requirements

• Financial Modeling Expertise: 5+ years experience in financial modeling for multi-year projections
• Advanced Excel Proficiency: Expert-level command of Excel formulas (INDEX/MATCH, SUMIFS, OFFSET, etc.)
• Strategic & Analytical Thinking: Ability to interpret complex financial data and provide actionable insights
• Communication & Collaboration: Ability to present financial information clearly to non-financial stakeholders

Preferred Experience:

• Experience in commercial real estate development and valuation
• Construction project finance and cost estimation background

Industry Experience:

• Commercial construction financial planning
• Real estate investment analysis

What is the last date for applying to the job?

Which countries are accepted for this remote job?