Reporting & Data Analyst (Automotive Operations) - Full Time
About The Position
We are seeking a Reporting & Data Analyst to join our Automotive Operations team. This is a full-time, on-site role based at our corporate office in Florence, AL. The successful candidate will be responsible for extracting, compiling, and analyzing data from various sources to support our Sales, Service, Finance, and Operations teams across ten dealership locations. This role involves creating reports and dashboards, ensuring data quality, and automating manual processes to improve efficiency and accessibility. We are looking for a detail-oriented individual with strong analytical and technical skills, preferably with experience in the automotive industry.
Requirements
- 2+ years of experience in reporting, data analysis, or a related field.
- Ability to work full-time on-site at our Florence, AL corporate office.
- Current residence in or near the Shoals area with the ability to commute daily.
- Working knowledge of SQL, HTML, and Python.
- Experience using AI tools such as Claude, ChatGPT, Microsoft Copilot, or Gemini to improve productivity and reporting workflows.
- Advanced Microsoft Excel skills, including pivot tables, lookups, formulas, and data manipulation.
- Experience working with multiple data sources and web-based business systems.
- Strong organizational skills with the ability to manage multiple priorities and deadlines.
- Excellent analytical, communication, and problem-solving skills.
Nice To Haves
- Experience in automotive dealership operations.
- Familiarity with dealership systems such as CDK, Reynolds & Reynolds, Dealertrack, VinSolutions, Elead, Tekion, or vAuto.
- Experience with Power Query, APIs, scripting, or other data automation tools.
- Understanding of dealership KPIs, including sales, inventory, fixed operations, and service performance metrics.
- Microsoft Power BI Data Analyst Associate (PL-300)
- Microsoft Excel Expert (MO-201)
- SQL Certification
- Google Data Analytics Professional Certificate
Responsibilities
- Extract and compile data from dealership systems, OEM portals, CRM platforms, and third-party sources.
- Build and maintain recurring reports for Sales, Service, Finance, and Operations teams across all ten dealership locations.
- Respond to ad hoc reporting requests from department leaders with timely, accurate data.
- Clean, validate, and reconcile data from multiple sources to ensure accuracy.
- Partner with department managers to identify trends, inconsistencies, and opportunities within dealership data.
- Document reporting processes, data sources, and reporting logic for consistency and continuity.
- Create dashboards and visualizations using Microsoft Excel and Power BI.
- Automate manual reporting processes using appropriate tools and scripting where applicable.
- Collaborate with the IT team to improve reporting efficiency and data accessibility.
Stand Out From the Crowd
Upload your resume and get instant feedback on how well it matches this job.
What This Job Offers
Job Type
Full-time
Career Level
Mid Level
Education Level
No Education Listed
