Data Analyst

PBT Group; Cape Town; On-site; ZAR 350,000 - 550,000; Full time

Job summary

PBT Group, Data Specialists, is seeking an experienced Data Analyst to turn complex data into meaningful insights that support strategic decision-making. You will handle large datasets, write advanced SQL, and create impactful data visualisations and statistical analyses.

You'll develop reports, dashboards and KPIs using Power BI or Tableau, use Python or R for analytics, and mentor junior analysts while exploring GenAI tools to boost productivity.

Qualifications

• Proven experience as a Data Analyst / BI Analyst / Analytics Specialist.
• Significant experience working within financial services or banking will be highly advantageous.
• Strong experience with advanced SQL and large datasets.
• Experience with Python or R for data analysis.
• Strong experience with Power BI, Tableau or similar visualisation tools.
• Solid understanding of statistics, data modelling and predictive analytics.
• Advanced Excel skills, including VBA/macros, would be advantageous.
• Experience presenting data insights and recommendations to senior and non-technical stakeholders.

Responsibilities

• Perform complex data analysis to identify trends, patterns, opportunities and business insights.
• Translate business questions and requirements into data-driven solutions.
• Write and optimise advanced SQL queries and work with large datasets.
• Develop reports, dashboards, KPIs, forecasting and scenario analysis using Power BI or Tableau.
• Use Python or R for data manipulation, analysis, visualisation and statistical modelling.
• Apply statistical and predictive analytics techniques to support business decision-making.
• Work closely with Data Engineers, Data Scientists and other technical teams to understand data flows and requirements.
• Engage with business stakeholders and clearly communicate findings, insights and recommendations to non-technical audiences.
• Identify data quality issues and opportunities to improve data processes and analytical solutions.
• Contribute to the development of data marts and analytical data assets.
• Take ownership of analytical projects from planning through to delivery.
• Mentor and support junior Data Analysts and contribute to knowledge sharing and best practices.
• Explore and apply GenAI and modern analytical tools to improve productivity and analytical processes.

Skills

Advanced SQL

Python

R

Data Analysis

Power BI

Tableau

Statistical Analysis

Data Modeling

Excel

Education

Bachelor's or Honours degree in Data, Analytics, Computer Science, Statistics, Mathematics, Information Systems

Tools

Power BI

Tableau

Excel VBA

Job description

Be part of our team of Data Specialists and embark on a career of the future!

PBT Group is looking for an experienced Data Analyst to join our data team and help turn complex data into meaningful insights that support business and strategic decision-making.

This role is ideal for a strong Data Analyst with experience working with large datasets, advanced SQL, data visualisation and statistical analysis, preferably within financial services or banking. You’ll work closely with business and technical stakeholders to understand requirements, identify opportunities and deliver data-driven solutions that create measurable business value.

Key Responsibilities

Perform complex data analysis to identify trends, patterns, opportunities and business insights.

Translate business questions and requirements into data-driven solutions.

Write and optimise advanced SQL queries and work with large datasets.

Develop reports, dashboards, KPIs, forecasting and scenario analysis using tools such as Power BI or Tableau.

Use Python or R for data manipulation, analysis, visualisation and statistical modelling.

Apply statistical and predictive analytics techniques to support business decision-making.

Work closely with Data Engineers, Data Scientists and other technical teams to understand data flows and requirements.

Engage with business stakeholders and clearly communicate findings, insights and recommendations to non-technical audiences.

Identify data quality issues and opportunities to improve data processes and analytical solutions.

Contribute to the development of data marts and analytical data assets.

Take ownership of analytical projects from planning through to delivery.

Mentor and support junior Data Analysts and contribute to knowledge sharing and best practices.

Explore and apply GenAI and modern analytical tools to improve productivity and analytical processes.

Bachelor's or Honours degree in Data, Analytics, Computer Science, Statistics, Mathematics, Information Systems or a related technical field.

Proven experience as a Data Analyst / BI Analyst / Analytics Specialist.

Significant experience working within financial services or banking will be highly advantageous.

Strong experience working with advanced SQL and large datasets.

Experience with Python or R for data analysis.

Strong experience with Power BI, Tableau or similar visualisation tools.

Solid understanding of statistics, data modelling and predictive analytics.

Advanced Excel skills, including VBA/macros, would be advantageous.

Experience presenting data insights and recommendations to senior and non-technical stakeholders.

Strong problem-solving, analytical and communication skills.

Technical Skills

Advanced SQL

Python and/or R

Data Analysis

Power BI / Tableau

Statistical Analysis

Advanced Excel

Advantageous:

Predictive Analytics

Data Marts

GenAI / AI-enabled analytics

VBA / Macros

What We're Looking For

We’re looking for someone who can go beyond simply producing reports — someone who can question the data, understand the business problem, identify meaningful insights and confidently communicate recommendations.

The successful candidate will be comfortable working independently, engaging with senior stakeholders, solving complex analytical problems and helping less experienced team members develop their analytical and technical capabilities.

PBT Group | Data Specialists | Turning Data into Business Value

Skills

Data Analysis Data Modeling Power BI Python SQL Statistical Analysis Tableau Software