Business Intelligence Specialist at MSX International in Troy, MI, United States

Job description

• If you have experience in business intelligence for the automotive industry, then we may be looking for you.
• 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.

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.

Requirements

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

Required

• Tableau
• Databricks
• Python
• SQL
• MySQL
• PostgreSQL
• Microsoft Excel
• Power Query
• Power Pivot
• VBA
• Macros
• Salesforce

Benefits

• 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