BI Analyst, Performance Analytics
- Salary
- $85K–$105K
- Hiring from
- United States
- Work type
- Remote
- Posted
626,573 remote jobs, straight from company career pages
100% free · New jobs every minute
Show job descriptionHide job description
Description
OHG Brands is home to America’s original, iconic restaurant brands. The company strategically develops and grows a diverse portfolio of fast-casual, quick-service and casual dining concepts around the world, using brand heritage as the foundation for growth and innovation that resonates with the next generation of fans. OHG Brands currently operates 12 restaurant brands: Round Table Pizza, Fatburger, Marble Slab Creamery, Johnny Rockets, Fazoli’s, Great American Cookies, Buffalo’s Cafe & Express, Hurricane Grill & Wings, Native Grill & Wings, Pretzelmaker, and Ponderosa and Bonanza Steakhouses, and franchises and owns over 1,700 units worldwide.
As our BI Analyst, you will own the reporting leaders run the business on, and make it accurate, repeatable and documented.
What you’ll do:
- Run the weekly sales report and period-close sales files for every brand.
- Tie every load to its source and reconcile warehouse sales and traffic to 40+ point-of-sale systems; when numbers don’t tie, find the cause and work the fix with IT.
- Run a daily data health check and flag stores that are missing, late or off pattern.
- Build the daily sales flash, weekly business review and Store Scorecard in Power BI on Snowflake.
- Replace manual, recurring reports with repeatable SQL and Python processes.
- Build the product mix tracker by mapping menu items across brands to one set of categories.
- Document your work, and use AI tools every day, checking the output before it is used.
In your first 90 days: you run the weekly sales report on your own and own the daily sales flash and data health check.
Requirements
- 2+ years in business intelligence, analytics or financial reporting, with work you can show.
- Strong Power BI (data modeling, DAX, Power Query) and strong SQL (joins, aggregations, window functions, reconciling tables that should match).
- Working Snowflake, or a comparable cloud data warehouse, and able to build simple views yourself so you are not blocked waiting on others.
- Advanced Excel, plus working proficiency with Word, PowerPoint, Outlook, Teams and SharePoint.
- Regular, hands-on use of AI tools (such as Claude, ChatGPT or Copilot) for real work, with good judgment about checking the output and protecting confidential data.
- Precise with financial data: you reconcile totals to the cent, trace a number back through every step, spot a figure that can’t be right, and say what a number covers and what it doesn’t.
- High ownership and initiative: you chase down why a number is off, build without a playbook, finish what you start, and say early when something will slip.
- A track record of documenting your work so others can pick it up, and clear written follow-up with franchisees, field teams and IT.
Preferred:
- Deeper Snowflake experience, and Python (pandas).
- Restaurant, franchise or multi-unit experience, including point-of-sale data across several platforms.
- 4-4-5 fiscal calendars and period close.
- Excel VBA and MySQL, or experience taking over and improving existing reporting workbooks.
This is a fully remote role, so you’ll work from home with no commute and no office to report to. We trust our team to do great work from wherever they work best. We stay connected through virtual meetings and regular check-ins, and we give you the flexibility to balance work and life.
OHG Brands is excited to offer all full-time employees a competitive compensation package that includes:
• Competitive base salary and bonus eligibility
• 85% employer-paid health, dental and vision insurance for you and your dependents
• Generous PTO policies (vacation, sick, bereavement.)
• 11 Paid company holidays
• 3 Floating holidays (because you decide what’s important)
• Paid Maternity Leave
• 401(k) with company match
• Flexible Spending Account (FSA)
• Health Savings Account (HSA)
• Company-paid life and AD&D insurance
• Company-paid Short- and long-term disability insurance
• Employee Assistance Program (EAP)
This job description is not intended to be an all-inclusive list of duties and responsibilities. Duties may change based on business needs.
OHG Brands is an equal opportunity employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, age, disability, veteran status or any other characteristic protected by law.
