onsite
Reporting & Data Analyst Automotive Operations - Long Lewis
Data Analyst
Data analyst focused on automotive operations, extracting and consolidating dealership and OEM data to produce actionable reports using SQL, Python, Power BI, and advanced Excel techniques.
About the role
Key Responsibilities
- Extract, transform, and load data from dealership systems, OEM portals, CRM platforms, and third‑party sources.
- Develop and maintain recurring dashboards and reports for Sales, Service, Finance, and Operations teams.
- Provide ad‑hoc reporting and data analysis to support operational and strategic decision‑making.
- Collaborate with cross‑functional stakeholders to identify data requirements and improve data quality.
- Document data processes, maintain metadata, and ensure compliance with data governance standards.
Requirements
- Proficiency in SQL for data extraction and manipulation.
- Experience with Python for data cleaning, automation, and analysis.
- Strong skills in Power BI or similar BI tools for dashboard creation.
- Advanced Excel skills, including pivot tables, formulas, and VBA.
- Knowledge of ETL concepts and data integration best practices.
Skills
sqlpythonpower biexcel