Business Intelligence Analyst

Business Intelligence Analyst

Department: Analytic Support 105604

Employment Type: Full Time

Location: Sterling Heights

Reporting To: Brian Potts

Compensation: $70,000 - $80,000 / year

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.
• Performs other related duties as assigned.

• 2+ years of experience in business intelligence, analytics, forecasting, or reporting roles.
• Expert-level Microsoft Excel skills including advanced formulas, Pivot Tables, 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.
• 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 prioritize the health, wellness and work-life balance of our team members and designed our comprehensive compensation packages to reflect that.

• Full-time team members are eligible for medical, dental and vision insurance, life insurance, disability insurance, parental leave, 401(k) with company match, at-work dining perks, flexible schedules, generous PTO, and a total rewards program. Team Members can also use our inclusive employee assistance program.
• Part-time Team Members are eligible for our 401(k) with company match, at work dining perks and team members can also use our inclusive employee assistance program.
• Location-specific perks may also include wellness programming, on-the-job training, corporate-hosted courses, certifications and team events.

Continental is unable to sponsor a visa at this time.