Senior BI Analyst - Team Lead

Introduction

Our client in the Automotive industry is currently looking for a Senior BI Analyst - Team Lead, in Randburg, Gauteng.

Duties & Responsibilities

• Team & leadership:
• Lead, develop, and manage a team of three analysts — workload allocation, quality review, and growth.
• Set the standards for data models, definitions, and documentation the whole business relies on.
• Serve as the primary data partner to stakeholders across Sales, Finance, Marketing, Operations, and Product.
• Business intelligence & analysis (primary focus):
• Maintain daily automated reports: leads, listings, LPL, promoted listings, sold listings, market monitor.
• Deliver weekly ad-hoc data requests across P24 and the company.
• Produce monthly and quarterly commercial analyses, industry reports, and press-ready data articles.
• Track commercial KPIs: take rate, ROS/MDS, LPL per dealer, slot utilisation, dealer profitability.
• Build and maintain dashboards in Tableau and Apache Superset; templates in Excel and Google Sheets.
• Proactively identify data improvement opportunities and surface insights to the business.
• Automation & data pipelines (second focus):
• Write and maintain complex SQL queries and automated pipelines across P24 and AT databases.
• Process, cleanse, and verify the integrity of data used for analysis and modelling.
• Build recurring data workflows — revenue book, billing, finance reporting, sold data
• Data science (phased):
• Apply predictive and statistical techniques to existing datasets — churn modelling, demand forecasting, pricing elasticity, and anomaly detection.
• Explore ML-assisted valuation and depreciation modelling for the company.
• Collaborate with engineering to productionise models as part of automated pipelines.

Desired Experience & Qualification

• 5+ in BI, data analytics, or data science; 1–2 years leading or mentoring others.
• Expert-level SQL and experience building automated reporting pipelines.
• Proficiency in at least one of Python, Tableau, Apache Superset, and Excel.
• Strong understanding of machine learning techniques and algorithms (clustering, neural networks, boosting) will be advantageous.
• Proficiency in statistical analysis, data mining, and mathematics.
• Proven ability to manage a high-volume, multi-stakeholder request backlog independently.
• Strong communication skills — able to translate complex data and models into clear business narrative.
• Degree in Data Science, Statistics, Computer Science, or a related field.
• Experience in online classifieds, proptech, or automotive industry.
• Familiarity with GA4.
• Experience producing data for press or media-facing data publications.
• Background in pricing or valuation modelling.

Package & Remuneration

• R70 000 – R80 000 per month