Automotive Dealership Data Analyst - Full-Time, On-Site

Job Description

Job Description

Key Responsibilities Data Extraction & Reporting

• 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.
• This is a full-time on-site role at our Florence, AL corporate office. Applications from candidates outside the Shoals area or seeking remote/hybrid work will not be considered.

Data Quality & Analysis

• 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.

Dashboards & Automation

• 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.

Required Qualifications

• 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.

Preferred Qualifications

• 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