What are the responsibilities and job description for the Automotive Dealership Data Analyst - Full-Time, On-Site position at Long-Lewis Auto Group?
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
Experience
Required- SQL Certification
- Hands-on Microsoft Excel experience (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
- 1 year(s): Experience with dealership systems such as CDK, Reynolds & Reynolds, Dealertrack, Tekion, VinSolutions, vAuto, OEM reporting portals, or sales analytics tools
Licenses & Certifications
Required- DRIVER'S LICENSE
Behaviors
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
Motivations
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.