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.