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

Long-Lewis Career • Florence, AL

6d • Onsite

About The Position

We are seeking a dedicated Reporting & Data Analyst to join our team on a full-time, on-site basis at our Florence, AL corporate office. This role is crucial for extracting, analyzing, and presenting data to support our Sales, Service, Finance, and Operations teams across ten dealership locations. The ideal candidate will be responsible for ensuring data accuracy, developing insightful reports and dashboards, and automating processes to enhance efficiency. This position requires a strong understanding of data analysis principles, proficiency in tools like SQL, Excel, and Power BI, and a commitment to maintaining data integrity. We are looking for an individual who can identify trends, solve problems, and contribute to the overall success of our dealerships through data-driven insights. Please note that this is a strictly on-site role, and applications from candidates outside the Shoals area or those seeking remote/hybrid work will not be considered.

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.

What This Job Offers

• Job Type: Full-time
• Career Level: Mid Level
• Education Level: No Education Listed