Reporting & Data Analyst (Automotive Operations) - Full Time

Long-Lewis Automotive Group • Florence, AL

11d • $20 - $25 • Onsite

About The Position

The Reporting & Data Analyst is responsible for extracting, consolidating, and delivering accurate, actionable data from multiple dealership systems and external sources. This role supports operational and strategic decision-decision-making by transforming fragmented data into meaningful reports and insights. This is a full-time in-person position at our corporate office in Florence, AL.

Requirements

• 2+ years of experience in reporting, data analysis, or related role
• Must have Strong SQL, HTML and Python skills
• Must have Strong Ai skills (Claude, ChatGPT, Copilot, Gemini)
• Strong Excel skills (pivot tables, lookups, data manipulation)
• Experience working with multiple data sources and web-based systems
• Ability to manage multiple priorities and deadlines

Nice To Haves

• Experience in automotive dealership operations
• Familiarity with DMS/CRM systems (CDK, Reynolds & Reynolds, Dealertrack, VinSolutions, Elead)
• Exposure to data automation tools (Power Query, APIs, or scripting)
• Understanding of dealership KPIs (sales performance, inventory, service 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
• Develop and maintain recurring reports for Sales, Service, Finance, and Operations
• Support ad hoc reporting requests with timely and reliable data
• Clean, validate, and reconcile data from multiple sources to ensure accuracy
• Identify trends, inconsistencies, and opportunities within dealership data
• Document reporting processes, data sources, and logic for consistency
• Create dashboards and visualizations using Excel and/or Power BI
• Automate manual reporting processes where possible

What This Job Offers

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