Senior Financial Analyst in Troy, MI at Vaco

Date Posted: 6/10/2019

Job Snapshot

  • Employee Type:
    Full-Time
  • Location:
    Troy, MI
  • Job Type:
  • Experience:
    5 to 7 years
  • Date Posted:
    6/10/2019
  • Job ID:
    SENIO45991

Job Description

Senior Financial Analyst

Reporting to the Director of Financial Planning & Analysis, the Senior Financial Analyst will assist with developing models to support the budget and forecast process, as well as evaluate operating results.
  • Generate and analyze monthly performance metrics, and operating trends.
  • Participate in the evaluation of growth initiatives including Return on Investment and Cash-on -Cash returns and post audit analysis.
  • Assist with developing and maintaining financial models and standardized templates to support the Annual Operating Plan, maintain rolling monthly forecast, and measure actual vs. budget and prior year operating variances.
  • Create dashboards, benchmarks and roadmap plans to support strategic and operational decision making.
  • Generate and analyze performance metrics on store and product line sales and margin trends against established targets. Assist with developing product line profit models and reporting cadence.
  • Develop models, reporting cadence, and trend analysis of key operating metrics at the store level including traffic, close rate, average sale, sales, margin, and staff cost performance,
  • Assist key stakeholders with monthly forecasting and developing departmental scorecards to help drive operational objectives.
  • Analysis of franchise candidates including review of profit and loss statements, balance sheets, working capital and cash flow statements.
  • Prepare Proformas, ROI and cash-on cash return analysis of new store and market opportunities.
  • Capital planning and forecasting, including monitoring capital project spend, post audit and ROI analysis.
Job Requirements:
  • A Bachelor's degree in Accounting, Business Administration or a related field.
  • A minimum of five to seven years accounting experience. Retail experience is highly desired.
  • Experience performing ROI and cash-on-cash return analysis.
  • Demonstrated ability to work well in an environment with multiple priorities. Must be able to work well with a diverse group in a deadline oriented environment.
  • Outstanding verbal/written communication skills.
  • Must be proficient with Excel at the EXPERT level (pivot tables, Vlookups functions, VBA/Macros). Proficiency with Word and Power Point also required.
  • Must be familiar with SQL queries.
  • Demonstrated project management skills.