Business Intelligence Analyst

Continental Services•Sterling Heights, MI

17d•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 turn operational and financial data into clear insights. The 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. The position is based in Sterling Heights, Michigan, with four days per week in-office and one day remote.

Requirements

At least 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.
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.

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 structuring 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 opportunities.
Apply statistical techniques, including multiple regression analysis, to identify performance drivers and improve forecast accuracy.
Develop intuitive visualizations to support operational and financial decision making.
Perform ad hoc reporting requests 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.