Strategic Financial Analyst

Strategic Financial Analyst

This position serves as the analytical extension of the Vice President of Finance on the Finance team. The role owns recurring executive reporting, financial forecasting, lender reporting, executive dashboards, profitability analyses, and other decision-support tools while serving as the primary analytical resource for strategic projects across the organization. The ideal candidate is intellectually curious, enjoys solving ambiguous business problems, and thrives in environments where analytical thinking matters more than following predefined processes. This is an onsite position based in our Kansas City, MO or Springfield, MO location.

Essential Functions:

• Own recurring Finance reporting and analyses, including cash flow forecasting, financial forecasting, lender reporting, executive dashboards, profitability reporting, and other decision-support tools used by Executive Leadership.
• Serve as a trusted financial partner to Executive Leadership and internal departments by providing financial insight, evaluating business opportunities, and supporting strategic decision-making.
• Maintain and enhance existing financial models, executive workbooks, and reporting tools to ensure they remain accurate, reliable, and relevant.
• Develop new financial models and analyses to support evolving business needs, strategic initiatives, and executive requests.
• Continuously improve Finance processes through automation, standardization, and enhanced reporting methodologies.
• Document and maintain financial models, recurring analyses, and reporting processes to support business continuity and organizational knowledge.
• Partner with Accounting, Contracts, Revenue Operations, Operations, and Executive Leadership to provide financial insight and support strategic business decisions.

Competencies:

• Analytical Problem Solving: Demonstrates the ability to deconstruct complex business problems, identify key drivers, and develop practical, data-driven solutions that drive actual decision-making.
• Financial Modeling & Excel Expertise: Builds, audits, and improves financial models using advanced Excel techniques. Understands model structure, validates assumptions, and ensures analyses are accurate, scalable, and maintainable.
• Reverse Engineering & Analytical Curiosity: Quickly understands unfamiliar financial analyses by identifying underlying business logic, data sources, assumptions, and calculations. Demonstrates intellectual curiosity by asking questions, challenging assumptions, seeking to understand the business drivers behind the results.
• Initiative & Ownership: Works independently with minimal direction, takes ownership of recurring reporting and analytical processes, follows through on commitments, and proactively identifies opportunities for improvement.
• Collaboration & Business Partnership: Builds interdepartmental relationships by understanding stakeholder needs and providing responsive support.
• Systems Thinking: Looks beyond individual analyses to understand how financial data flows through business processes, ERP systems, reporting tools, and operational workflows. Recognizes opportunities to improve the overall financial information ecosystem rather than simply completing individual tasks.
• Adaptability & Learning Agility: Thrives in an environment with changing priorities, unfamiliar challenges, and evolving business needs. Quickly learns new systems, processes, and analytical techniques while maintaining high-quality work.

Required Education and Experience:

• Bachelor's degree in Accounting, Finance, Economics, Business, or related experience.
• 2-5 years of experience in Financial Planning & Analysis, Corporate Finance, Investment Banking, Consulting, or similar analytical role.
• Advanced Microsoft Excel skills, including:
• Financial modeling
• Complex formulas
• Dynamic array formulas
• Pivot Tables
• Power Query
• Data validation
• Scenario and sensitivity analysis
• Model auditing and troubleshooting
• Ability to understand and improve legacy workbooks.
• Strong understanding of:
• Financial statements
• Forecasting methodologies
• Financial analysis techniques
• Demonstrated ability to reverse engineer complex Excel models developed by others, understand the underlying business logic, update assumptions, validate results, and improve the analysis with minimal guidance.

Preferred Education and Experience:

• Experience in Engineering, Consulting, Construction, Architecture, Environmental Services, or project-based businesses.
• Experience with Power BI or similar business intelligence tools.
• Experience with ERP systems, Vantagepoint preferred.
• Knowledge of project accounting and project-based financial metrics.

Position Type and Expected Hours of Work:

• This is a full-time position.

• Typical work schedule will be Monday through Friday 8am – 5pm; some flexibility and overtime may be needed dependent on business needs.

• This role operates in an office environment and regularly uses standard office equipment, this is not a remote position.

Pay Range: $70,000 - $90,000/yr – contingent on experience.

Benefits:

• 1700/3400 * Deductible Health Insurance Plans Available

*3400 includes Health Savings Plan (HSA) Company Contribution with Employee Contribution

• Dental

• Vision

• Health Savings Account (HSA)

• 401k | Up to 4% Company Match

Voluntary Benefits:

• Accident

• Hospital Indemnity

• Critical Illness

• Life and AD&D

Company Paid Benefits:

• Short - Term Disability

• Long - Term Disability

• Employee Assistance Program (EAP)

Cost Savings Programs:

• SmithRX | Prescription Drug

• Valenz Health | Surgery and Imaging

• CancerCare

• Healthjoy | Care Navigation Platform

Additional Benefits:

• Tuition Reimbursement

• Career and Personal Development Resources and Training

• Boot Reimbursement

• Apparel Reimbursement

• Gym Membership Reimbursement

And More

Other Duties:

Please note this job description is not designed to cover or contain a comprehensive listing of activities, duties, or responsibilities required of the employee for this job. Duties, responsibilities, and activities may change at any time with or without notice.

AAP/EEO

Environmental Works, Inc. is committed to maintaining a workplace free from discrimination and harassment based on any protected characteristic under federal, state, or local laws. This policy applies to all terms and conditions of employment, including recruiting, hiring, placement, promotion, termination, layoff, transfer, leave, compensation, and training.

#IND