Data Analyst / BI Specialist
Zohorecruit · Cape Town, South Africa ·
- Work mode
- Hybrid
- Employment
- Contract
- Category
- Data analytics
- Experience
- 3+ years
Zohorecruit · Cape Town, South Africa ·
pfg · Langley Office - Langley BC
SEARADAR · Cascais, Portugal
Dataeconomy · Charlotte, United States
Enercare · Markham, ON, CA
weekday-1 · Vadodara, Gujarat, India
Hybrid, fixed-term Data Analyst / BI Specialist role in Cape Town: builds and maintains BI dashboards, certified datasets and governed self-service analytics using SQL, Power BI and ZAP BI, extracts data from APIs and warehouses, and frames and audits AI-agent-generated outputs, with growing Python/pandas exposure.
Paarl, Cape Town, South Africa | Posted on 07/10/2026
Driving data transformation and business intelligence, this full-time, hybrid role supports cross-platform data initiatives across SQL-based architectures, ZAP BI solutions, and emerging AI technologies. The role is designed to bridge technical data engineering and actionable business insight, transitioning static reporting into governed, self-service analytics.
As part of the Systems team, the successful candidate will build certified datasets, frame business objectives for AI agents, and establish data governance guardrails across internal integrations . The role offers an opportunity to upskill on enterprise analytics tools, refine pandas / Python workflows, and grow into a central data leadership capacity as market trends evolve .
Build, maintain, and support BI dashboards, reports, data models, and ZAP BI solutions .
Extract, transform, and analyse data using SQL databases, APIs, and enterprise data warehouse platforms .
Collaborate with business users to understand operational data needs, translating complex findings into plain-language stories .
Help automate data flows, streamline reporting processes, and build certified, trustworthy datasets to serve multiple enterprise tools without duplication .
Frame business questions into executable goals for AI agents, validating and auditing agent-generated SQL and outputs for accuracy and audit integrity prior to stakeholder delivery .
Support data governance practices, helping establish guardrails for self-service analytics and curating a single semantic layer for diverse consumers .
Contribute to integration and data warehouse projects across internal operational systems .
Exposure to or experience with Power BI, ZAP BI, and SQL (or similar products).
Understanding of data modelling principles (e.g., star schema, snowflake schema) and tabular vs multi-dimensional structures.
Experience working with API data sources, data warehouses, ERP systems, and ETL processes.
Prompt engineering skills and comfort working with AI-assisted analytics tools.
Ability to validate and audit AI/agent-generated outputs for accuracy and compliance before stakeholder sharing.
Beginner-level Python exposure for data manipulation (pandas, basic scripting) with a strong commitment to expanding this skill set.
Solid understanding of data governance principles and data quality management.
Strong analytical mindset, acute attention to detail, and proven data storytelling abilities.
Experience with cloud platforms such as Azure or AWS .
Functional exposure to finance or manufacturing processes .
Familiarity with natural language query tools or embedded analytics platforms .
Understanding of semantic layer concepts and headless BI architectures .
Exposure to data cataloguing or metadata management tools .
Required Software Skills
ZAP BI
SQL
Power BI
Full-time, hybrid role (one day a week in-office)