Contractor Financial Modeling Specialist
Servant is hiring a remote Contractor Financial Modeling Specialist. The career level for this job opening is Expert and is accepting USA based applicants remotely. Read complete job description before applying.
Servant
Job Title
Posted
Career Level
Career Level
Locations Accepted
Share
Job Details
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.
- 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
- 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
- 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
- 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