Business Intelligence Specialist
At a glance
Mid-level Data Analysis & BI role at MSX International. Troy · full-time · no salary stated · we estimate $86,500–$135,038 across the United States.
MSX International has not published a salary for this role. The figure below is our estimate, not theirs.
dataroles summary, based on the employer's posting.
What you'll do
- Turn complex business data into recommendations that guide operational choices and customer program decisions
- Work with operations, PMO and customer teams to surface problems, find opportunities and shape decisions
- Clean and analyze revenue, sales, market and customer engagement data to spot patterns and improvement areas
- Build data models, dashboards and analytical tools, then measure the business impact of proposed changes
- Present findings through visualizations, reports and presentations, while tracking market shifts
What you bring
- You have four to seven years of business intelligence experience, with three years in automotive at an OEM or large dealer group
- You can use Tableau and Databricks, and have working knowledge of Python, SQL, MySQL or PostgreSQL
- You bring advanced Excel skills, including Power Query, PivotTables, formulas and dashboard automation
- You have delivered dashboards and can explain analytical findings clearly to different audiences
Who this fits
This mid-level role suits someone ready to move from reporting into business partnership and data-backed recommendations across customer programs. You’ll work in the office four days each week in Metro Detroit.
From the employer
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.
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.
Required Skills and Tools
- 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)
- Familiarity with Salesforce, Palantir and PowerBI is an advantage
- 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 demonstrated analytical 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
Skills & Competencies:
- 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
Workplace Type: In office 4 days per week in Metro Detroit
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
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.