Business Intelligence Analyst

Continental Services; Sterling Heights (MI); Hybrid; USD 70,000 - 90,000; Full time

Benefits offered by this job

Health Coverage

401(k) match

Paid Time Off

Parental Leave

Wellness Programs

Referral bonus

Additional Perks

Job summary

Continental Services is seeking a Business Intelligence Analyst to translate data into actionable insights. You will design dashboards, forecast revenue, and partner with cross-functional teams to ensure accurate reporting.

The role emphasizes statistical methods, visualizations, and automation to improve decision making and efficiency within a hybrid in-office/remote setup in Sterling Heights.

Qualifications

• 3+ years in business intelligence, analytics, forecasting, or reporting roles.
• Expertise in Excel with advanced formulas and PivotTables.
• Experience building reports or dashboards in Power BI.
• Strong data analysis, forecasting concepts, and visualization best practices.

Responsibilities

• Design, build, and maintain automated dashboards, KPI reporting, and forecasting models.
• Develop and maintain revenue forecasting models to support the sales team.
• Apply regression analysis to identify drivers and improve forecast accuracy.
• Develop intuitive visualizations to support decision making.
• Perform ad hoc reporting requested via Jira for multiple divisions.
• Partner with IT and business teams to integrate data sources and validate outputs.
• Automate recurring reporting and forecasting workflows.
• Provide training and documentation to help users consume insights.

Skills

Analytical skills

Excel advanced

Power BI

Forecasting

Statistics

Data viz

Communication

Automation/AI awareness

SQL basics

Python

Tools

Power BI

Excel

Python

Power Automate

SQL

Qlik

Job description

Business Intelligence Analyst

Department: Analytic Support 105604

Employment Type: Full Time

Location: Sterling Heights

Reporting To: Brian Potts

Description

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

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 Experience You’ll Create:

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.

Ingredients for Thriving:

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

Savor the Benefits:

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 https://www.continentalserves.com/work-at-continental/#benefits

#LI-KR1