Ziggi's Coffee · 1 day ago
Senior Business Intelligence Analyst
Mead, CO
Full-time
Hybrid
Mid, Senior Level
$100K/yr - $125K/yr
3+ years expZiggi's Coffee is a rapidly growing coffee franchise with 115+ locations nationwide, headquartered in northern Colorado. They are seeking a Senior Business Intelligence Analyst to transform data into actionable insights that enhance store profitability and support decision-making across departments.
CoffeeFood and BeverageRestaurants
Responsibilities
Develop and maintain interactive Power BI dashboards for store-level performance tracking, including sales mix, contribution margins by item/region, labor vs. sales ratios, inventory turnover, loyalty, discounts, and promotion/campaign lift
Analyze POS data (from systems such as Revel or others) to uncover insights on unit economics: Identify high-performing items, regional pricing opportunities, discount impacts, and menu optimization strategies
Conduct deep dives into promotion and campaign effectiveness at the individual store level—quantify ROI, traffic drivers, and profitability impacts
Support regional pricing strategies: Model price elasticity, test scenarios, benchmark competitors, and recommend adjustments for margins and discounts across markets
Optimize labor and inventory: Forecast needs by location, spot inefficiencies, and provide actionable recommendations to reduce costs without impacting service
Integrate data from POS systems (e.g., Revel), QuickBooks Online, Loyalty Dashboard, and other sources into Power BI for comprehensive franchisor and store-level views
Partner with franchisees, operations, and marketing to translate insights into strategies that increase store profits
Automate reporting processes and explore enhancements (e.g., data connectors for real-time feeds from various POS systems)
Present findings and recommendations to leadership and stakeholders in clear, compelling stories
Qualification
Required
3–7+ years of experience in business intelligence, data analytics, or similar roles
Advanced proficiency in Microsoft Power BI (DAX, data modeling, dashboard development, scheduled refreshes)
Strong SQL skills for querying and data manipulation
Experience with POS systems (Revel strongly preferred; Toast, Square, or other QSR systems acceptable)
Proven track record analyzing restaurant/QSR metrics (e.g., menu mix, pricing, promotions, loyalty, labor scheduling)
Excellent Excel skills for ad-hoc analysis
Bachelor's degree in Data Analytics, Business, Finance, Statistics, or related field (or equivalent experience)
Preferred
Experience in franchise/multi-unit restaurant or hospitality operations
Knowledge of QuickBooks Online integration with BI tools
Background in revenue management, pricing analytics, or unit economics
Familiarity with restaurant-specific tools (e.g., Restaurant365, MarginEdge) or franchise reporting
Benefits
Health insurance
401(k)
Paid time off
Company
Ziggi's Coffee
Ziggi's Coffee is a restaurant chain that serves coffee, tea, Italian sodas, and energy infusions.
51-200 employees
Funding
Current Stage
Growth StageLeadership Team
Karl Ziegler
CFO
Recent News
2025-07-29
2025-03-31
2025-01-29
Company data provided by crunchbase