Job Description

Company Overview

Ziggi's Coffee is a rapidly growing coffee franchise with 115+ locations nationwide, headquartered in northern Colorado. We're passionate about delivering exceptional coffee experiences and empowering our franchisees to succeed. As we scale, we're investing in data-driven decisions to boost store-level profitability.

Position Overview

We're seeking a Senior Business Intelligence Analyst to join our team and transform our data into actionable insights that directly help our stores make more money and support every department in making better decisions. You'll focus on store-level economics, analyzing everything from menu pricing and regional variations to promotion ROI, labor optimization, and inventory efficiency. This role will not include oversight of the accounting team, allowing full dedication to data analysis and insights.

This is a full-time role (in-office preferred in northern Colorado for maximum impact; hybrid or remote considered for exceptional candidates) reporting to the CEO/leadership team. You'll collaborate closely with operations, marketing, and finance to drive measurable improvements across our franchise network.

Key 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.

Required Qualifications

• 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 Qualifications

• 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.

What We Offer

• Competitive base salary: $100,000–$125,000 (depending on experience).
• Comprehensive benefits including health insurance, 401(k), paid time off, and potential for growth/equity in a fast-scaling brand.
• Opportunity to make a direct impact on a growing brand's profitability and strategy.
• Collaborative, entrepreneurial culture with room to innovate and grow into a leadership role.
• Flexible work options (in-office preferred; hybrid or remote for the right candidate).

Ziggi’s Coffee is a leading specialty coffee shop and drive-thru franchise dedicated to serving only the finest roasted coffee, uniquely handcrafted drinks, and amazing breakfast, lunch and snack options. Founded in 2004, the Colorado-based company is on a mission to elevate the standard of service within the coffee shop industry. From specializing in a variety of great-tasting menu items to providing fast and friendly service, the Ziggi’s Coffee brand is focused on creating a positive experience that is faster, more authentic, and convenient for the demand of consumers seeking higher-quality coffee and food options on the go. In addition to its distinctive menu and superior service, Ziggi’s Coffee is also committed to making a positive difference in the local communities it serves.
With several locations open nationwide, and additional units in development, Ziggi’s Coffee is positioned to quickly grow its presence in a variety of communities across the U.S.

Job Tags

Similar Jobs