Reporting & Analysis Specialist

MSX International

Experience: 3+ yrs
Location: Troy, Michigan, United States
Job type: Full-time

Required skills

Tableau
Salesforce
KNIME
SQL
Excel
ETL
CRM

About the role

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.

About MSX International

Provides outsourced business services and technology to automotive manufacturers.

This page is fully interactive when JavaScript is enabled. Please enable JavaScript to apply or browse related roles.