Reporting & Data Analyst - Full-Time, On-Site

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., * 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.

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

Preferred

• 1 year(s): Experience with dealership systems such as CDK, Reynolds & Reynolds, Dealertrack, Tekion, VinSolutions, vAuto, OEM reporting portals, or sales analytics tools, * 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, * 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