Data Analyst Jobs in Cape Town

Virgin Active South Africa is looking for a Data Analyst to join its team in Cape Town. This is a permanent position offering a market-related salary, and applications close on 28 December 2026, so interested candidates should apply promptly.

About the company and the work

Virgin Active is one of South Africa’s best-known health and fitness brands, and its stated purpose is to change people’s lives for the better through wellness. The company delivers social wellness experiences that help people meet their personal wellness goals through holistic physical, mental, nutritional and social wellbeing. This role combines hands-on business intelligence development, strong SQL expertise and rigorous data validation to build the gold data and semantic layer that provides trusted, business-ready datasets for Power BI and wider reporting. You will work closely with business stakeholders and data engineering teams to understand business logic, turn it into reliable data models, and reconcile new outputs against existing datasets and reports.

Role details and duties

The confirmed facts are: the employer is Virgin Active South Africa (Pty) Ltd, the role is in Cape Town, it is a permanent position, the salary is market related, the reference number is 209777, and the advert closes on 28 December 2026. The key duties, as stated in the original advert, include:

• Gold data and semantic layer development: helping design, build and maintain gold-layer fact tables, dimensions and SQL views in Databricks
• Writing, maintaining and optimising complex SQL using joins, CTEs, window functions and date-effective logic
• Working with stakeholders to understand and challenge business rules, clarify exceptions, and translate them into data logic
• Investigating existing SQL, datasets and reports to understand how measures are derived, and documenting sources
• Developing interactive dashboards and reports using Power BI
• Building and optimising semantic data models within Power BI
• Writing advanced SQL queries to extract and transform data from Azure-based platforms
• Developing DAX measures and calculated fields aligned to business KPIs
• Consuming curated datasets from Azure Data Factory and Azure Databricks environments
• Working with Azure SQL and data lake structures
• Supporting reporting performance optimisation within the Azure architecture
• Performing rigorous data testing, validation and reconciliation
• Validating KPIs, metrics and calculation logic before release
• Identifying and resolving discrepancies across source systems
• Documenting business rules and data transformation logic
• Translating business requirements into reporting and visualisation solutions
• Presenting insights clearly to executive and operational stakeholders
• Providing continuous enhancements to dashboards and reporting frameworks
• Supporting self-service BI enablement

Requirements

Applicants should meet the following requirements, as stated in the original advert:

• A Bachelor’s degree in Data Analytics, Computer Science, Finance, or a related field
• 3 to 5 years of experience in BI development or data analytics roles
• Strong expertise in Power BI, including data modeling, DAX and visualisation best practices
• Advanced SQL
• Data testing and validation methodologies
• Experience working with Azure data platforms
• Understanding of data warehousing and dimensional modeling concepts
• Experience with performance tuning Power BI datasets
• Knowledge of Azure Data Factory and Databricks data flows
• A strong analytical mindset and attention to detail
• Excellent communication and business engagement skills
• Hands-on experience developing SQL transformations, fact tables, dimensions or semantic models for production reporting
• The ability to interpret complex business logic and existing SQL, and to understand data grain and join cardinality
• Proven experience reconciling new datasets against established reporting and investigating record-level differences

The advert also lists core interpersonal skills: emotional intelligence, active listening, cultural awareness and fluency, and empathy. It also lists operational and leadership skills: attention to detail, resilience and composure, problem solving and conflict resolution, adaptability, relatability, situational awareness, curiosity, time management, and digital fluency.

Where to find and apply safely

Apply only through the original Careers24 listing for this vacancy, using the Apply button on this page, which links directly to that advert. Do not pay anyone to secure this job, and do not share banking details or passwords with anyone claiming to arrange the placement. If a message about this vacancy asks for money, treat it as a scam and report it.

Practical tips

Because the closing date is 28 December 2026, apply as soon as you can and make sure your application clearly shows your degree, your 3 to 5 years of BI or data analytics experience, and your Power BI, DAX and advanced SQL skills. Mention any Azure Data Factory, Databricks and Power BI performance-tuning experience, since these are specifically listed in the advert. Give examples of dashboards or semantic models you have built, and of reconciliations you have performed, and double-check every detail in your application before submitting it.

How the process works

Applications are submitted through the Careers24 listing for this vacancy. Shortlisted candidates can expect the employer to assess their BI development experience, SQL skills and ability to translate business requirements into reliable reporting.

Important information

This post is for information only and is not the employer. Always confirm the details, including the closing date, in the original advert before applying. This is a different vacancy from the Senior Data Analyst role in Cape Town and from other data analyst roles in Durban and Pretoria that are also listed on this site.

#DataAnalystJobs #CapeTownJobs #VirginActiveJobs #PowerBIJobs #SQLJobs #ITJobs #SouthAfricaJobs #JobsInSouthAfrica