Lead Financial Modeling Consultant — AI-Driven Analytics

FI Consulting; Arlington (VA); On-site; USD 110,000 - 150,000; Full time

Job summary

FI Consulting is seeking a highly motivated Senior Consultant with Financial Modeling experience to lead client projects and engage with executive stakeholders in the DC metro area.

You will architect modeling approaches, guide analysts, and lead hands-on build and QA work to meet client objectives in fast-visibility environments. The role emphasizes collaboration, problem solving, and continuous learning in AI-driven solutions.

Qualifications

• Bachelor's degree in Finance, Accounting, Economics, Mathematics, Statistics, or related field.
• 4+ years in consulting, corporate finance, FP&A, investment banking, or analytics.
• Advanced financial modeling: data science, programming, statistics, econometrics.
• Advanced Excel (XLOOKUP, INDEX/MATCH, SUMIFS, dynamic arrays, data tables).
• Experience with Power Query/Power Pivot, Python, R, with VBA as a plus.
• Strong understanding of GAAP financial statements.
• Consulting skills: structured problem-solving, communication, stakeholder management.
• Project leadership in fast-paced consulting environments.

Responsibilities

• Lead modeling workstreams: Design and build models: forecasting engines, scenario/sensitivity analyses, and valuation models.
• Translate analysis to action: Convert model outputs into executive-ready insights and recommendations.
• Own quality & control: Maintain model structure, audit checks, documentation, and version control.
• Client engagement & presentations: Gather requirements and present findings to senior stakeholders.
• Project management: Deliver on time and on budget while managing risks and dependencies.
• Mentor & elevate the team: Provide coaching, review work products, and support junior staff.
• Support business development: Shape proposals and architect modeling solutions.
• Stay current on market, regulatory, and industry trends.
• Designing and building new models, or significantly changing/updating existing models

Skills

Advanced Excel

Advanced financial modeling

Power Query/Power Pivot

Python

R

GAAP knowledge

Consulting skills

Project leadership

Stakeholder management

Communication

Education

Bachelor's degree in Finance/Accounting/Economics/Math/Statistics or related field

Tools

Power Query/Power Pivot

Python

R

SQL

VBA

Job description

FI Consulting is seeking a highly motivated Senior Consultant with Financial Modeling experience to lead client projects and engage with executive stakeholders in the DC metro area.

You will architect modeling approaches, guide analysts, and lead hands-on build and QA work to meet client objectives in fast-visibility environments. The role emphasizes collaboration, problem solving, and continuous learning in AI-driven solutions.