Business Intelligence Specialist

MSX International; Troy (MI); On-site; USD 65,000 - 95,000; Full time

Benefits offered by this job

Health Insurance

401k Savings Plan

Paid holidays & vacation

Job summary

MSX International is seeking a skilled Business Intelligence Analyst to join our team. You will collect, analyze, and report on business data to support informed, data-driven decision-making across several customer-facing programs.

This role is expected to evolve beyond traditional reporting responsibilities and become a trusted business partner who leverages data to identify opportunities, influence decisions, and drive measurable business outcomes.

Qualifications

• Proficiency in Tableau and Power BI 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.

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.

Skills

Tableau

Power BI

Python

SQL

Excel

Analytics

Tools

Salesforce

Palantir

Databricks

Power Query

Power Pivot

Job description

MSX has been a trusted partner to leading vehicle manufacturers, their retailers, and mobility organizations globally for more than 30 years. Our unwavering commitment is to help our clients transform their businesses and effectively manage operations in the areas of Sales Performance; Repair Optimization and Compliance; Parts and Accessories Sales Performance; and Consumer Engagement. With our global teams, industry expertise, and the power of technology, we design and deliver tailored, sustainable, and innovative solutions and services that help our clients optimize their operations and captivate their customers.

Job Description

Are you looking for a new opportunity?

If you have experience in business intelligence for the automotive industry, then we may be looking for you.

What We Are Looking For:

We are looking for a skilled Business Intelligence Analyst to join our team. In this role, you will collect, analyze, and report on business data to support informed, data-driven decision-making across several customer-facing programs. This role is expected to evolve beyond traditional reporting responsibilities and become a trusted business partner who leverages data to identify opportunities, influence decisions, and drive measurable business outcomes.

The BI Analyst key tasks are:

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

Qualifications

Required Skills and Tools

• Proficiency in Tableau and Power BI 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

Required Experience:

• 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 demonstratedanalytical capabilities and proven delivery of impactful BI solutions

Preferred Experience:

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

This role is expected to evolve beyond traditional reporting responsibilities and become a trusted business partner who leverages data to identify opportunities, influence decisions, and drive measurable business outcomes

Additional Information

What We Have to Offer:

Work at the intersection of data and business strategy

Collaborate with cross-functional teams to drive measurable impact

Opportunity to grow into senior or specialized BI roles

Competitive salary based on experience and qualifications)

Benefits include Health, Rx, Dental, Vision Insurance, 401k Savings Plan, Health Savings Account.

Paid standard US holidays and paid vacation time

Professional development opportunities and access to industry training resources

MSX International is an Equal Employment Opportunity Employer committed to employing a diverse workforce. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, national origin, sexual orientation, gender identity, disability and protected veteran status, age, or any other characteristic protected by law.