Senior Data Analyst / Engineer

PBT Group; Johannesburg; On-site; ZAR 600 000 - 900 000; Full time

Job summary

A leading company in Johannesburg is seeking a Senior Data Analyst / Data Engineer to transform complex data into actionable insights. The role involves designing ETL pipelines, conducting data analysis, and engaging with stakeholders to support strategic compliance objectives. Ideal candidates will have strong analytical skills, technical proficiency in ETL processes, and experience with data visualization tools. This position offers an opportunity to work on large-scale data projects in a dynamic environment.

Qualifications

• Minimum of 5 years’ experience in data analysis or data engineering.
• Proficient in SQL and ETL development.
• Experience with cloud platforms such as AWS or Azure.

Responsibilities

• Design and develop ETL pipelines for data processing.
• Perform advanced data analysis to identify trends.
• Collaborate with IT and compliance to understand data needs.

Skills

Analytical skills

Data visualization

Problem-solving

Stakeholder engagement

Education

Bachelor's degree in Data Science

Master’s degree (advantageous)

Tools

SQL

ETL (SSIS, Python)

Power BI

Tableau

AWS

Azure

Job description

The Senior Data Analyst / Data Engineer will play a key role in transforming complex data into actionable business insights to support strategic compliance objectives. This role requires strong analytical capabilities, technical proficiency in ETL processes, and the ability to engage with stakeholders across multiple levels of the organisation. The ideal candidate will be equally comfortable developing data pipelines and performing in-depth data analysis to support decision-making.

Key Responsibilities

1. Data Analysis & Engineering

• Design and develop ETL (Extract, Transform, Load) pipelines to ingest and process structured and unstructured data from multiple sources.
• Perform advanced data analysis to identify trends, patterns, and actionable insights.
• Develop management information (MI) and respond to ad-hoc data requests with accuracy and within agreed deadlines.
• Apply statistical techniques and predictive modelling to support data-driven strategies.
• Source and integrate internal and external data sources into existing reporting structures.

2. Data Management & Governance

• Ensure data accuracy and integrity through data cleansing, validation, and auditing procedures.
• Adhere to established data governance frameworks including data quality, lifecycle management, and privacy / security standards.
• Conduct integrity checks on all reports and scripts to ensure adherence to data quality principles.
• Identify opportunities to automate and streamline data collection and analysis workflows.
• Design and maintain reports and dashboards to track business performance and key metrics.
• Standardise the reporting process using appropriate BI tools and ensure audit-ready documentation.
• Convert manual reporting processes into automated solutions using visualisation platforms such as Power BI.
• Maintain existing reports to ensure they remain relevant and reliable for decision-making.

4. Stakeholder Engagement

• Collaborate with IT, compliance, and other business units to understand data needs and develop solutions accordingly.
• Lead internal workshops, forums, and presentations to communicate data findings and insights.
• Provide mentorship and support to junior data analysts to foster professional growth and learning.
• Represent the data function in governance and strategic decision-making forums.

Qualifications & Experience

• Bachelor's degree in Data Science, Statistics, Computer Science, Informatics, or related field (Master’s degree advantageous).
• Minimum of 5 years’ experience in data analysis or data engineering, with a proven track record of working on large-scale data projects.
• Proficient in SQL and ETL development (SSIS, Python or other scripting languages preferred).
• Working knowledge of DAX, data warehousing concepts, and data governance principles.
• Experience with cloud platforms such as AWS or Azure (especially ECS, S3, Redshift or equivalents).
• Familiarity with Hadoop ecosystem, Spark SQL, or Hive is advantageous.
• Strong background in data visualisation using tools such as Power BI, Tableau, or similar.

Technical Skills

• Advanced Excel (including macros and advanced formulas)
• Microsoft SQL Server, SSIS, SSRS
• AWS (especially ECS, S3), Azure (preferred)
• Python or Spark SQL (advantageous)
• Power BI / Tableau
• Oracle OBIEE or equivalent reporting platforms
• Business and process analysis

Soft Skills

• Excellent analytical, critical-thinking, and problem-solving skills
• Strong written and verbal communication, with the ability to convey complex data concepts clearly
• Effective stakeholder engagement and influence at senior levels
• Ability to manage multiple priorities under pressure
• Strong team player with mentoring and leadership capabilities
• Exposure to governance, risk, and compliance-related projects is an advantage
• In order to comply with the POPI Act, for future career opportunities, we require your permission to maintain your personal details on our database. By completing and returning this form you give PBT your consent
• If you have not received any feedback after 2 weeks, please consider you application as unsuccessful.

Create a job alert for this search

Senior Data Engineer • Johannesburg, South Africa