Business Intelligence & AI Reporting Analyst, Operations Finance
Python
Ai Reporting
Analytical Skills
Analytics
Business Analytics
Business Intelligence
Business Intelligence Automation
Cloud Platform
Cloud Platforms
Data
Data Analysis
Data Analytics
Data Analytics Tools
Data Platform
Data Processing
Digital Marketing
Financial Analysis
Financial Operations Analytics
Financial Reporting
Hr Technology
Information Technology (IT)
Microsoft 365
Microsoft Excel
Microsoft Office
Office 365
Office Suite
Office Tools
Operations Analytics
Product Management
Productivity Tools
Programming
Programming Language
Programming Languages
Reporting and Analytics
Software Development
Spreadsheets
Tools
Job Description
Drive automated weekly and period-end reporting for operations finance by building data pipelines, AI-assisted narratives, and exception-based validation across multi-system inputs.
- Design and operate end-to-end automated reporting systems from data extraction to transformation, validation, report generation, and distribution.
- Leverage AI for production reporting using large language models and reusable prompt workflows to speed analysis, draft narrative commentary, detect anomalies, and produce first drafts of recurring reporting packages (examples required).
- Connect operational and finance systems through APIs and integrations, creating a single source of truth across POS and back-office platforms, franchisor portals, labor and scheduling tools, accounting, facilities work order management (Corrigo), lease management (Visual Lease), and Microsoft 365.
- Implement validation and exception alerts in every pipeline so errors are caught before publishing.
- Set and follow guardrails for responsible AI use, including data privacy, access control, human review of AI-generated output, and version control of models, prompts, and scripts.
- Act as a cross-functional data connector for operations, finance/accounting, HR, facilities, loss prevention, real estate, and IT so data is shared once and defined consistently.
- Coordinate with technology and data vendors to scope integrations, manage API access and credentials, troubleshoot data feeds, and enforce data-quality expectations.
- Eliminate duplicate manual work by replacing department handoffs with shared, automated workflows.
- Train and support end users so operators and colleagues can use dashboards and AI tools independently.
Reporting and analytics responsibilities
- Build and automate period P&L review dashboards that roll store-level data up through Area Coach, Market, and company totals, including sales, transactions, COGS/ICOS, labor, prime cost, controllable income, EBITDA, speed of service, and guest complaints.
- Create market P&L diagnostics each period for every Market Coach, including a controllable income bridge and a narrative of drivers, plus preparation materials for P&L review meetings.
- Distribute review materials promptly (notes, dashboards, diagnostics) to Market Coaches and leadership using automated distribution and filing.
- Maintain additional recurring period dashboards, including team member turnover (separate Taco Bell and Pizza Hut views) and the bonus and disqualification dashboard used by operations.
- Prepare period-end financial summary packages for investors, the executive team, and/or ownership.
- Automate weekly labor forecast rollovers by archiving prior weeks, loading actuals, resetting adjustments, refreshing last-year inputs, and logging flagged events with projected transaction impact.
- Run labor allocation and reconciliation by filling the weekly labor allocation worksheet and daily labor hour tracker from market forecast models, then reconciling market totals back to source.
- Refresh and distribute a weekly scorecard dashboard (People, Customer, Digital, and Financial pillars) at store, Area Coach, and Market levels, including rankings for operators to share with restaurants.
- Run a weekly loss prevention red-flag report that identifies stores breaching two or more thresholds (cash variance, deletes, refunds, promos, ICOS variance, and others) via automated anomaly detection and sends results to the loss prevention team.
- Develop facilities spend reporting by store, Area Coach, Market, and vendor, covering repair and maintenance, capital projects, and preventive maintenance with trends vs budget and prior year.
- Integrate facilities work orders with accounting/AP by connecting Corrigo work order data to accounting and AP through APIs or automated exports to reconcile work orders, invoices, and spend without manual matching.
- Monitor facilities performance and outliers across work order volume, aging, response and completion times, repeat repairs, and vendor performance; flag high-cost stores, recurring equipment failures, and invoice mismatches vs work performed.
- Support facilities budgeting and decisioning with data-backed analysis for vendor savings and repair-versus-replace and capital decisions.
- Deliver recurring facilities dashboards to facilities leadership, Market Coaches, and the executive team.
Quality, documentation, and publishing controls
- Verify data integrity and fair framing by reconciling store counts and rollups to source, flagging non-comparable periods or bases, verifying AI-generated content, and surfacing methodology questions before publication.
- Document automated processes using SOPs, data maps, and run books so workflows can be run, maintained, or audited by others.
Requirements
- Bachelor’s degree in data analytics, business analytics, finance, accounting, economics, information systems or a related field.
- 3+ years in financial analysis, FP&A, operations finance, or business intelligence, including ownership of recurring weekly and period-end reporting.
- Hands-on AI experience producing real business output by building reusable AI workflows, prompts, skills, or agents (for example with Claude, ChatGPT, or Copilot) that run production reporting; be prepared to show examples.
- Experience designing and running automated reporting systems end to end, not only one-off scripts.
- Strong unit-level P&L knowledge: sales, COGS and inventory variance, direct and indirect labor, controllable expenses, controllable income, and EBITDA.
- Advanced Excel: lookups, linked workbooks, multi-tab models, structured data, and the discipline to roll models forward week to week without breaking them.
- Analytical judgment and skepticism to recognize non-comparable periods, select appropriate metrics, and flag data conflicts rather than smoothing them over.
- Clear written communication translating numbers into plain-language, actionable recommendations for audiences from operators to investors.
- Collaborative approach working across departments and with outside vendors.
- Ability to manage multiple fixed weekly and period deadlines with limited supervision.
- Discretion with confidential financial, investor, lease, and personnel data, including responsible handling in AI tools.
- Working experience with APIs and integrations including authentication, pulling and pushing data, handling JSON and CSV, and troubleshooting failed feeds.
- Python (pandas, openpyxl, requests) or comparable scripting for data extraction, transformation, and report generation.
Technologies
- Excel, Python, Claude, ChatGPT, Copilot
- AI agents, prompt workflows
- APIs, Microsoft 365, POS
- Corrigo, Visual Lease
- JSON, CSV, pandas, openpyxl, requests
- Python-generated HTML dashboards, HTML, JavaScript, Chart.js
- SharePoint, Outlook, Teams, Microsoft Graph API
- SQL, Power BI (DAX, Power Query), Tableau
- ServiceChannel, Claude Code, Opal, MCP connectors
- Power Automate, Zapier, Make
Benefits
- 401(k)
- Dental insurance
- Health insurance
- Paid time off
- Vision insurance
Location and work setup
- Charleston, SC (remote in the Southeast; some travel required in the Southeast)
- Work location: Hybrid remote in Charleston, SC 29417
Reporting line
- Reports to the executive leadership team
Pay
- USD 31,200 - 500,000 per year
Preferred qualifications
- Experience in multi-unit restaurant, QSR, or franchise finance, including familiarity with labor metrics (labor %, TPLH, SPLH, overtime) and inventory/food cost variance.
- Experience with Claude, Claude Code, Opal, MCP connectors, or other agentic AI frameworks.
- Power BI (DAX, Power Query), Tableau, or similar BI platforms, and SQL.
- Workflow automation tools such as Power Automate, Zapier, or Make, or scheduled scripts and cloud functions.
- Working knowledge of HTML and JavaScript charting (for example, Chart.js) to maintain existing dashboards.
- Microsoft 365 administration and integration, including SharePoint, Outlook, Teams, and the Microsoft Graph API.
- Experience with restaurant POS and back-office systems, franchisor reporting portals, and labor or scheduling platforms.
- Financial modeling experience, including weekly labor forecasting or scheduling models.
- Experience preparing reporting for limited partners or other outside investors.
- Facilities or maintenance spend analysis experience, including work order systems such as Corrigo, ServiceChannel, or similar.
- Exposure to lease administration: critical-date tracking, renewal options, rent escalations, or a lease management system such as Visual Lease.
- Experience leading a tool rollout or training non-technical users on new systems.