Business analyst Jobs in Longmont, CO

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

Preferred Qualifications

What We Offer

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.