Data Analyst

PBT Group; Cape Town; On-site; ZAR 300,000 - 450,000; Full time

Job summary

PBT Group is seeking a detail-oriented Data Analyst in Cape Town. The role involves transforming data into actionable insights, conducting thorough analyses, and developing dynamic dashboards to support the organization’s business units. Ideal candidates should have a solid background in SQL, Excel, and data visualization tools, along with strong analytical skills.

Qualifications

• 2–4 years of experience in data analysis or business intelligence.
• Comfortable with large datasets and presenting to non-technical audiences.
• Good understanding of data models and relational databases.

Responsibilities

• Extract, clean, and analyze data from diverse systems.
• Develop dashboards and visualizations to support business needs.
• Collaborate with Data Engineers for data quality.

Skills

SQL

Excel

Analytical thinking

Problem-solving

Data visualisation

Tools

Power BI

Tableau

Python

R

Azure

Job description

Data Analyst position available in Cape Town.

PBT Group is looking for a detail-oriented and business-savvy Data Analyst to transform data into actionable insights. The successful candidate will work across departments to identify trends, measure performance, and support data-driven decision-making.

Key Responsibilities:

• Extract, clean, and analyse data from various systems and sources
• Develop interactive dashboards and visualisations to support business units
• Identify trends, anomalies, and opportunities through exploratory data analysis
• Provide regular reporting and ad hoc insights to stakeholders
• Collaborate with Data Engineers to ensure data quality and availability
• Translate business questions into analytical solutions

Requirements:

• 2–4 years of experience in a data analysis or business intelligence role
• Proficient in SQL, Excel, and at least one data visualisation tool (e.g., Power BI, Tableau)
• Strong analytical thinking and problem-solving ability
• Comfortable interpreting large datasets and presenting findings to non-technical audiences
• Good understanding of data models and relational databases

Nice to Have:

• Experience with Python or R for statistical analysis
• Familiarity with cloud platforms (Azure preferred)
• Exposure to data warehousing concepts and tools