ESSENTIAL REQUIREMENTS & KEY RESPONSIBILITIES

• Ensure, in coordination with other corporate departments and the Data Engineer and Data Architect, that raw data used in reporting, analysis, and planning is accurate and complete.
• Partner with vendors and internal data team to organize the process of ingesting new data sources into the data warehouse, ensuring accuracy and usability.
• Create curated data sources through data transformation to be consumed by analysts and dashboards for end users.
• Leverage AI to provide wholistic views of overall performance by location.
• Develop and enhance existing Power BI dashboards to provide comparative views of restaurant, region, division and corporate performance over varying timeframes and disparate performance metrics.
• Support the development of the annual budget and quarterly financial forecasts. Enhance existing projection models and develop new tools as necessary to improve and facilitate the current planning processes.  Partner with the operations team to gather relevant data, assess and provide forecast input on restaurant sales, cost of sales, cost of labor, controllable costs, advertising, fixed expenses, etc.
• Responsible for the ongoing development, accurate preparation and timely distribution of weekly, monthly and quarterly reports, including KPI reports, weekly and monthly flash reports, monthly financial and operational reports, new restaurant performance, and other reports as requested by senior management.
• Provide general business insights to all levels of operations management to support the achievement of corporate and regional goals through identification and presentation of profit opportunities and financial results.
• Support the development of financial and operational tools to facilitate decision making of business partners in operations, purchasing, and marketing. Provide analyses to evaluate the potential financial performance of alternative options.
• Create or support the preparation of quantitative and qualitative analyses in the evaluation of potential brand opportunities as requested by operations, development or finance management. These analyses may involve development activity, food costs, labor costs, controllable costs, return on investment, general brand spending, marketing, etc.

Lead monthly analysis projects including:

• Develop cost reduction and management initiatives reporting.
• Review projected menu changes and model preference & margin impacts.
• Identify underperforming units and work with operations teams in the analysis of store improvements.
• Participate in special projects as requested.

• Working knowledge of database applications, including SQL, Snowflake, Palantir Foundry (or comparable)
• Advanced proficiency with Microsoft Excel, Microsoft Word, Microsoft PowerPoint, Microsoft Power BI, and Microsoft Outlook
• Strong technical, analytical and problem solving skills
• Advanced understanding and working knowledge of budgeting, forecasting, and analysis
• Strong interpersonal verbal and written communication skills
• Sound knowledge of accounting and accounting principles
• Minimum 4-6 years relevant work experience including financial and/or operational analysis
• Bachelor’s degree in finance, economics, accounting, or a related field
• Restaurant or multi-unit retail experience in a financial planning and analysis position, preferred
• A Master’s Degree in Business, Finance, or Accounting, preferred
• CPA or CMA, preferred