Reporting & Analysis Specialist

MSX International•Troy, MI

20h•Hybrid

About The Position

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 a strong background in data analytics, business intelligence reporting, and automotive program support, then we may be looking for you. What We Are Looking For: Do you thrive on turning complex datasets into actionable business insights? Are you experienced in building and maintaining automated reporting workflows? Can you manage multiple recurring report deliverables on tight weekly and monthly cadences? Are you comfortable working across platforms like Tableau, Salesforce, and data integration tools? Do you have strong attention to detail and the ability to identify data quality issues before they impact stakeholders? If you answered yes to the questions listed above, MSXi might have the right opportunity for you! We are expanding one of our signature programs and are looking for a Buyback Prevention Reporting & Analysis Specialist to own the end-to-end reporting and analytics function supporting our Field Service Consultant (FSC) program. Your day-to-day will include building, maintaining, and delivering operational reports that track program performance, key metrics, consultant utilization, and overall program health. You will manage data pipelines across multiple source systems, maintain automated workflows, deliver weekly and monthly reports to program leadership, and respond to ad hoc analytical requests. 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.

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; ability to build, maintain, and troubleshoot dashboards and formatted report deliverables
Experience managing recurring report cadences with strict deadlines and multiple stakeholder groups
Strong working knowledge of data integration/ETL concepts; experience building or maintaining automated data processing workflows
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
Proven ability to work with large datasets (millions of records) and maintain performance and accuracy
Strong attention to detail with experience implementing data quality checks and validation processes
Excellent written and verbal communication skills with ability to document technical processes for non-technical audiences
Ability to manage multiple concurrent deliverables and prioritize between recurring obligations and ad hoc requests

Nice To Haves

Tableau experience strongly preferred — including building/maintaining workbooks, connecting to data sources, creating calculated fields, and publishing dashboards
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
Background in automotive industry, dealership operations, or OEM program support
Familiarity with automotive service operations, compliance programs, or field service management
Experience with Learning Management System (LMS) data and training compliance reporting
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)

Responsibilities

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
Produce regular reports for program leadership and field operations covering case progress, performance trends, aging analysis, and identification of critical items requiring attention
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
Execute manual quality steps for all reports including data validation, date alignment, source integrity checks, and stakeholder-specific formatting requirements
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
Maintain data source documentation including a reference guide of URLs, pull locations, input requirements, and system dependencies
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
Build and maintain interactive dashboards and data visualizations that enable stakeholders to slice, filter, and explore program data
Translate raw data outputs into formatted executive-ready deliverables combining automated outputs with manual formatting, summaries, and contextual notes
Maintain shared report distribution folders and ensure timely delivery to all stakeholder groups
Respond to recurring and one-off analytical requests from program leadership, including cross-referencing datasets, mapping distribution and location data, and producing program-specific extracts and analyses
Work with large-scale datasets (millions of records) from enterprise data platforms to answer business questions not addressable through standard CRM reporting
Support special analyses tied to emerging program needs, client requirements, or strategic planning initiatives
Extract and analyze data from multiple source systems to support specific business questions or investigative requests
Pull, process, and deliver monthly training completion data by joining training system downloads to the FSC master roster, filtering by staff identifiers, and extracting training phase completion status
Reconcile training data discrepancies between online system records and actual completion (e.g., in-person training not reflected in downloads)
Support program leadership in tracking certification levels and identifying training gaps across the FSC team
Maintain comprehensive documentation for all recurring reports including step-by-step execution instructions, manual steps, known failure points, and sanity checks
Develop and maintain a reporting cheat sheet covering data sources, system URLs, pull procedures, and input requirements
Support knowledge transfer activities to ensure reporting continuity, including shadowing-based training (watch → drive methodology)
Identify and recommend process improvements to reduce manual effort, improve data integrity, and increase report reliability