onsite
Reporting & Data Analyst Automotive Operations - Long-Lewis Auto Group
Data Analyst
Data analyst focused on automotive operations, extracting and consolidating dealership and OEM data to produce actionable insights 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.
- Design and maintain recurring dashboards and reports in Power BI and Excel to support operational and strategic decision‑making.
- Collaborate with cross‑functional teams to define data requirements and ensure data quality and consistency.
- Develop automated data pipelines and scripts in Python to streamline data collection and reporting processes.
- Analyze trends, identify anomalies, and provide actionable insights to improve dealership performance.
Requirements
- Proven experience with SQL for data extraction and manipulation.
- Strong proficiency in Python for data processing and automation.
- Hands‑on experience creating interactive dashboards in Power BI.
- Advanced Excel skills, including pivot tables, advanced formulas, and VBA.
- Excellent analytical, problem‑solving, and communication skills.
Skills
sqlpythonpower biexcel