Business Intelligence Analyst
Posted 2
views
Summary
Builds and maintains automated dashboards, KPI reporting, and revenue forecasting models that turn operational and financial data into clear insights for leadership. Works mostly on-site in Sterling Heights, MI using Excel, Power BI, and statistics/regression, with preferred Python, SQL, Power Automate, and Qlik.
A Taste of Who We Are:
Backed by a tireless commitment to high quality, innovative culinary offerings and unparalleled client and guest services, Continental consistently ranks among the top contract dining and refreshment providers in the nation according to Food Management Magazine, the industry’s source for food service news and trends.
Our Mission
Delight our guest. Every meal. Every day.
Our Core Values
Our Core Values
Exceptional – We recruit and retain phenomenal people who consistently go the extra mile to deliver results that lead the industry.
Hospitality – We are tirelessly committed to providing the highest quality food, beverages, and service by anticipating our guests' needs so they can count on memorable experiences every time.
Collaboration – We prioritize working together with a shared vision and effective & transparent communication, we unite as one team to achieve remarkable experiences.
Responsibility – we hold ourselves accountable to be there for our team and clients, to deliver what we say we will, when we say we will and check in on progress along the way.
Innovation – We are forward-thinkers always looking for new processes, technologies, and techniques to increase efficiencies and scalability to improve our services.
The Business Intelligence Analyst supports data-driven decision making by building and maintaining reporting, dashboards, forecasting models, and repeatable analysis that translate operational and financial data into clear insights. This role partners with cross-functional teams to understand reporting needs, validate data, and deliver intuitive dashboards, forecasts, and KPI views that help leaders act quickly.
- Design, build, and maintain automated dashboards, KPI reporting, and forecasting models.
- Develop and maintain revenue forecasting models to support the sales team in new business opportunity.
- Apply statistical techniques, including multiple regression analysis, to identify drivers of performance and improve forecast accuracy.
- Develop intuitive visualizations to support operational and financial decision making.
- Perform ad hoc reporting requested submitted through Jira for multiple divisions.
- Partner with IT and business teams to integrate data sources and validate outputs.
- Automate recurring reporting and forecasting workflows to reduce manual effort.
- Provide training and documentation to help users effectively consume insights.
Location: Four days per week in-office in Sterling Heights, Michigan, and one day remote.
- 3+ years of experience in business intelligence, analytics, forecasting, or reporting roles.
- Expert-level Microsoft Excel skills including advanced formulas, PivotTables, Power Query, and basic modeling.
- Experience building reports or dashboards in Power BI.
- Strong understanding of data analysis, forecasting concepts, and data visualization best practices.
- Foundational statistics knowledge, including correlation and multiple regression analysis.
- Basic understanding of data structures, tables, and relationships.
- Strong attention to detail and data accuracy.
- Ability to communicate insights clearly to non-technical stakeholders.
- Understanding of how automation and AI can be embedded into analytics and forecasting workflows.
Preferred Qualifications:
- Working knowledge of Python for data cleaning, automation, statistical analysis, or forecasting workflows.
- Experience using Power Automate to automate workflows, integrate systems, or support low-code solutions.
- Exposure to building low-code or no-code internal tools or lightweight web applications.
- Familiarity with AI-assisted analysis, including how to structure effective AI prompts and questions to support analysis, documentation, and insight generation.
- Basic SQL experience for querying and validating data.
- Experience working with enterprise BI platforms such as Qlik or similar tools.
Core Competencies:
- Strong analytical, statistical, and problem-solving skills.
- Ability to manage multiple priorities and deliver high-quality, accurate work.
- Ownership mindset with strong follow-through and accountability.
- Collaborative and service-oriented approach when working with internal teams.
We offer a range of benefits for eligibles team members, including:
- Health Coverage – Medical, Dental and Vision
- Voluntary Life/AD&D, Short-Term and Long-Term Disability, Critical Illness, Parental Leave
- 401(k) with company match
- Paid Time Off
- Paid Parental Leave
- Wellness Programs
- Referral bonus
- Additional Perks
To see a summary of current benefits, please visit .
#LI-KR1
#LI-KR1