Reporting & Analysis Specialist

Job Description

Job Description

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

The Buyback Prevention Reporting & Analysis Specialist Key Tasks Are: 

Recurring Operational Reporting 

• 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 

Data Pipeline & Workflow Management 

• 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 

Data Visualization & Business Intelligence 

• 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 

Ad Hoc Analysis & Special Projects 

• 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 

Training Data & Compliance Reporting 

• 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 

Knowledge Management & Process Continuity 

• 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 

Qualifications

Required Experience: 

• 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 

Preferred Experience: 

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

Skills & Competencies: 

• 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 

• Ability to translate business questions into data queries and deliver clear, actionable insights 

• 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 

• Self-motivated and deadline-driven with ability to manage a structured weekly/monthly reporting calendar 

• Strong collaboration skills with ability to work effectively with cross-functional teams both in-person and virtually 

Additional Information

What We Have to Offer: 

• Competitive salary range 

• 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 

• Hybrid work environment: 10 days a month in Troy, Michigan office with remote work flexibility on remaining days 

• Paid standard US holidays and paid vacation time 

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.