Business Intelligence Specialist

MSX International•Troy, MI

12h•Hybrid

About The Position

MSX is seeking a skilled Business Intelligence Analyst to join their team. This role involves collecting, analyzing, and reporting on business data to support informed, data-driven decision-making across customer-facing programs. The position is expected to evolve into a strategic business partner role, leveraging data to identify opportunities, influence decisions, and drive measurable business outcomes. The BI Analyst will transform complex data into actionable recommendations, collaborate with stakeholders to solve business problems, gather and analyze business data (revenue, sales, market information, customer engagement), identify patterns and trends for improvement, develop and maintain data models and dashboards, and present findings to internal teams and customers.

Requirements

Proficiency in Tableau and Databricks is a must
Full working knowledge of Python, SQL, MySQL, or PostgreSQL
Advanced experience with Microsoft Excel, including Power Query & Power Pivot, Advanced Formulas, PivotTables & Interactive and Dashboards Automation (VBA & Macros)
Strong understanding of descriptive and predictive analytics
Excellent communication and data storytelling skills
Minimum of 4-7 years of proven BI curriculum
Minimum of 3 years in automotive field, OEM or large dealer group
Proven track record of creating and delivering dashboards, will be assessed
Experience may be substituted by demonstrated analytical capabilities and proven delivery of impactful BI solutions
Intellectual curiosity and passion for uncovering meaningful business insights
Demonstrated ability to learn new business domains quickly
Strong analytical thinking and problem-solving skills
Desire and capability to grow into a strategic business intelligence leadership role
Excellent presentation and facilitation skills with ability to engage diverse audiences
Highly organized with exceptional attention to detail in documentation
Excellent written and verbal communication skills with ability to simplify complex technical information
Ability to work independently and manage multiple training initiatives simultaneously
Self-motivated, adaptable, and results-driven with ability to work in a fast-paced environment

Nice To Haves

Familiarity with Salesforce, Palantir and PowerBI is an advantage
Knowledge of automotive systems, recall processes, warranty, retail fixed operations and parts
Certified Business Intelligence Professional (CBIP)
Familiarity with Salesforce, Palantir or Databricks is an advantage

Responsibilities

Act as a strategic business partner by transforming complex data into actionable recommendations that drive operational and business decisions
Work closely with operations, PMO, and customer stakeholders to identify opportunities, solve business problems, and influence decision-making
Gather, clean, and analyze business data including revenue, sales figures, market information, and customer engagement metrics
Identify patterns and trends in data that signal opportunities for improvement in business practices
Work with and strengthen the PMO offering to the customer, making every decision a measurable and sustainable decision.
Develop and maintain data models, dashboards, and analytical solutions that support proactive business decision-making
Translate complex data findings into clear, actionable insights for stakeholders
Identify operational improvement opportunities and quantify the potential business impact of recommended actions
Develop business cases and recommendations supported by data analysis to enable informed decision-making
Support multiple customer programs and business portfolios through proactive analysis, performance monitoring, and insight generation
Present reports and recommendations to internal teams and customers through visualizations, charts, written summaries and presentations.
Monitor market trends to help the organization adapt its products and strategies accordingly.