BI & Reporting Analyst (SQL / Power BI)

Prime South Africa; Randburg; On-site; ZAR 300,000 - 500,000; Full time

Job summary

A leading motor vehicle insurance firm in Randburg is seeking a BI & Reporting Analyst to transform raw data into meaningful insights. You will design Power BI dashboards, write SQL queries, and develop automation scripts to enhance reporting workflows. The ideal candidate will have a Bachelor's Degree in related fields and strong skills in SQL and Power BI. If you are passionate about data and improving business outcomes, apply now to join this dynamic team.

Qualifications

• Strong SQL skills including data modelling and query optimisation.
• Power BI expertise from dashboard creation to semantic model design.
• Proficiency in Python, especially using pandas for data manipulation.

Responsibilities

• Design Power BI dashboards for sales, operations, and executives.
• Write efficient SQL queries to extract data from multiple sources.
• Develop scripts to automate reporting and data quality checks.

Skills

SQL skills

Power BI expertise

Python proficiency

Analytical thinking

Collaboration

Education

Bachelor’s Degree in Mathematics, Statistics, Computer Science, or equivalent

Tools

Git

Databricks

Job description

About Prime SA

At Prime SA, we aim to reshape the motor vehicle insurance industry by providing the best possible insurance, delivered with humanity, simplicity, and compassion.

We're passionate about leveraging data to improve decision-making, drive growth, and create real impact across the business. Join our fast-paced and supportive team where your work will directly influence operations, strategy, and customer outcomes.

The Role

The BI & Reporting Analyst will be part of the Data Science & Analytics team, supporting departments across the business by transforming raw data into meaningful insights. You will play a hands-on role in building SQL data models, designing user-friendly dashboards in Power BI, and automating data workflows to ensure timely, accurate, and actionable reporting.

This position is based at our Bryanston office and reports to the Head of Data Science & Analytics.

Key Responsibilities

Business Intelligence & Analytics

• Design clear and intuitive Power BI dashboards for teams across sales, operations, and executive leadership.
• Develop reusable data models and DAX measures to enable self-service insights and scalable reporting.
• Translate business questions into data-driven visual stories that support better decision-making.

Data Engineering & SQL

• Write clean, efficient SQL queries to extract and prepare data from multiple sources.
• Optimise stored procedures, views, and data transformations for clarity and performance.
• Build and maintain lightweight, reproducible data pipelines using Python and/or Databricks.

Automation & Workflow Optimisation

• Develop scripts to automate ETL, reporting refreshes, or data quality checks using Python (pandas, SQLAlchemy, or PySpark).
• Use Git for version control and deploy code using basic CI/CD pipelines when needed.

Documentation & Quality Assurance

• Document dashboards, datasets, and SQL logic for transparency and maintainability.
• Write tests to validate critical SQL queries or Python code and reduce the risk of data errors.

Collaboration

• Work closely with senior data scientists, analysts, and business owners to clarify requirements and deliver value quickly.
• Proactively identify and raise data quality issues — and suggest practical solutions rather than short-term fixes.

Qualifications & Technical Skills

• A Bachelor’s Degree in Mathematics, Statistics, Computer Science, Engineering, Biology, or equivalent experience
• Strong SQL skills — including data modelling, query optimisation, and advanced joins/window functions
• Power BI expertise — from semantic model design to interactive dashboard creation (Desktop & Service)
• Python proficiency — especially using pandas for data manipulation and SQL integration
• Comfortable with Git (GitHub, GitLab, or Azure Repos) and basic command-line tools
• Experience working across Windows and Linux environments

Nice to Have

• Familiarity with dbt, Delta Lake, or Databricks
• CI/CD workflows for Power BI using tools like Azure DevOps or GitHub Actions
• Exposure to high-volume transactional domains such as insurance
• Experience with cloud data platforms (e.g., Azure SQL, AWS RDS, or Google BigQuery)
• Basic understanding of Docker or containerised deployments

Personal Attributes & Soft Skills

• Analytical thinker with a natural curiosity for understanding the “why” behind numbers
• Clear communicator who can explain complex concepts in plain language
• Able to manage multiple requests and set realistic expectations
• Attention to detail — writes clean, well-documented code and tests solutions
• Collaborative mindset with a willingness to share knowledge and receive feedback

Ready to Make an Impact?

If you’re passionate about data, eager to work in a collaborative environment, and motivated by the opportunity to improve real-world business outcomes, we’d love to hear from you.

Apply now and become a part of Prime SA’s data-driven future.