The Reporting & Data Analyst is responsible for extracting, consolidating, and delivering accurate, actionable data from multiple dealership systems and external sources. This role supports operational and strategic decision-making by transforming fragmented data into meaningful reports and insights. This is a full-time in-person position at our corporate office in Florence, AL. The pay range is $20-$25 per hour.
Extract and compile data from dealership systems, OEM portals, CRM platforms, and third-party sources
Develop and maintain recurring reports for Sales, Service, Finance, and Operations
Support ad hoc reporting requests with timely and reliable data
Clean, validate, and reconcile data from multiple sources to ensure accuracy
Identify trends, inconsistencies, and opportunities within dealership data
Document reporting processes, data sources, and logic for consistency
2+ years of experience in reporting, data analysis, or related role
Must have Strong SQL, HTML and Python skills
Must have Strong Ai skills (Claude, ChatGPT, Copilot, Gemini)
Strong Excel skills (pivot tables, lookups, data manipulation)
Experience working with multiple data sources and web-based systems
Ability to manage multiple priorities and deadlines
Experience in automotive dealership operations
Familiarity with DMS/CRM systems (CDK, Reynolds & Reynolds, Dealertrack, VinSolutions, Elead)
Exposure to data automation tools (Power Query, APIs, or scripting)
Understanding of dealership KPIs (sales performance, inventory, service metrics)
- Microsoft Power BI Data Analyst Associate (PL-300)
- Microsoft Excel Expert (MO-201)
- SQL Certification
- Google Data Analytics Professional Certificate
This position plays a critical role in ensuring accurate, reliable data is available to support daily operations and strategic decisions. By improving reporting processes and data quality, this role helps drive efficiency and performance across the organization.
Required
-
Strong Excel skills (pivot tables, lookups, data manipulation
-
Experience working with multiple data sources and web-based systems
-
2 year(s): Experience in reporting, data analysis, or related role
Preferred
-
1 year(s): Experience in CDK, Reynolds & Reynolds, Dealertrack, Tekion, VinSolutions, vAuto, OEM reporting systems, sales performance analytics is preferred.
Required
Preferred
-
Leader: Inspires teammates to follow them
-
Dedicated: Devoted to a task or purpose with loyalty or integrity
-
Team Player: Works well as a member of a group
-
Thought Provoking: Capable of making others think deeply on a subject
-
Functional Expert: Considered a thought leader on a subject
-
Innovative: Consistently introduces new ideas and demonstrates original thinking
-
Detail Oriented: Capable of carrying out a given task with all details necessary to get the task done well
Preferred
-
Growth Opportunities: Inspired to perform well by the chance to take on more responsibility
-
Goal Completion: Inspired to perform well by the completion of tasks
-
Work-Life Balance: Inspired to perform well by having ample time to pursue work and interests outside of work
-
Self-Starter: Inspired to perform without outside help
-
Ability to Make an Impact: Inspired to perform well by the ability to contribute to the success of a project or the organization
Equal Opportunity Employer
This employer is required to notify all applicants of their rights pursuant to federal employment laws. For further information, please review the Know Your Rights (https://www.eeoc.gov/poster) notice from the Department of Labor.
