Reporting & Analysis Specialist

Requirements

• 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?
• 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 C

Benefits

Additional Information

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.

Your Match

How well this role fits your profile.

Company Intel

What employees say

Worked at Msxinternational? Share your experience