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