MSX International

MSX International

Reporting & Analysis Specialist

Troy, MI, United States · Staff+ · Full-time

Sponsorship not specifiedDetected 55 days ago
Data StructuresSQLData AnalysisData EngineeringData VisualizationStatisticsSalesforceCRMExcelCadenceLeadershipCommunicationCollaborationProblem SolvingAdaptability

About the role

  • Job Description Are you looking for a new opportunity?
  • If you answered yes to the questions listed above, MSXi might have the right opportunity for you!
  • If you have a knack for data storytelling, thrive on process reliability, and can balance recurring operational reporting with analytical deep dives, this position might be a great fit for you.

Responsibilities

  • 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.
  • Build and deliver weekly and monthly performance reports that track key program metrics, performance indicators, completion rates, pace-to-goal measurements, and time-based performance buckets
  • Deliver periodic performance monitoring reports covering consultant productivity, involvement rates, and supporting key performance indicators across the program
  • Maintain and distribute utilization reports that account for known data behaviors including end-of-month timing fluctuations, verification lag, and data maturation patterns.
  • Document and communicate cadence rules and data interpretation guidance to stakeholders
  • Own and maintain centralized data processing workflows (e.g., KNIME or similar ETL/data integration platforms) that feed reporting and visualization outputs
  • Manage data source connections and inputs including CRM exports, dealer/FSC master lists, customer experience data, and training system downloads
  • Implement and monitor data quality checks and sanity thresholds (e.g., expected record counts) to detect upstream source failures or data breaks early
  • Manage legacy workflow components and understand downstream dependencies to prevent breakage when modifying pipelines

Requirements

  • Minimum of 3-5 years of experience in data analytics, business intelligence, or reporting within an operational or program-support environment
  • Demonstrated proficiency with data visualization and reporting tools
  • Experience managing recurring report cadences with strict deadlines and multiple stakeholder groups
  • Strong working knowledge of data integration/ETL concepts
  • Advanced proficiency in Microsoft Excel including Index & Match, pivot tables, data validation, and formula-driven summary tabs
  • Experience working with CRM platforms for data extraction, report generation, and data quality management

Nice to have

  • Salesforce reporting experience strongly preferred - including report/dashboard creation, data exports, and understanding of CRM data structures and relationships
  • Experience with KNIME Analytics Platform or similar visual workflow/ETL tools (e.g., Alteryx, Talend, Apache NiFi)
  • Experience with enterprise data platforms and large-scale data environments
  • Familiarity with automotive service operations, compliance programs, or field service management
  • Knowledge of SQL for ad hoc querying and data validation
  • Bachelor's degree in Data Analytics, Business Intelligence, Information Systems, Statistics, or related field (equivalent professional experience will be considered)
  • Preferred Experience:

Skills

  • Analytical mindset with ability to identify trends, anomalies, and data quality issues proactively
  • Strong problem-solving skills with ability to troubleshoot data pipeline failures and report discrepancies
  • Process-oriented with a focus on documentation, repeatability, and continuous improvement
  • Comfortable working independently while maintaining consistent communication with stakeholders across remote and in-office settings
  • Adaptable and resourceful when working with imperfect data, legacy systems, or evolving requirements
  • Strong collaboration skills with ability to work effectively with cross-functional teams both in-person and virtually

Compensation

  • Competitive salary range

Benefits

  • Full-time position with benefits effective the first of the month following 30 days of employment
  • Benefits include Health, Rx, Dental, Vision Insurance, 401k Savings Plan, Health Savings Account, Disability Insurance plans, and employee discounts

Company info

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

Equal opportunity

  • Paid standard US holidays and paid vacation time
Apply directly at MSX International →Create a free account for alerts like thisView MSX International immigration profile

This listing is sourced directly from MSX International's careers page and normalized into a canonical job model.