Business Intelligence Analyst

Continental Services • Sterling Heights, MI

13d • Hybrid

About The Position

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.

Requirements

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

Nice To Haves

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

Responsibilities

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

Benefits

• 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

What This Job Offers

• Job Type: Full-time
• Career Level: Mid Level
• Education Level: No Education Listed