Cape Town City Centre: Data Analyst

Data Analyst Help shape data-driven decision making in a growing analytics team. Remote (with 12 days/month in Cape Town office) | R40 000 R60 000 per month About Our Client This innovative data-led company delivers high-impact business intelligence solutions across a variety of sectors. With a strong focus on Power BI and Microsoft analytics platforms, they are committed to evolving their capabilities through modern technologies like Microsoft Fabric. You’ll join a collaborative, forward-thinking environment where your insights will directly inform business strategy. The Role: Data Analyst This role exists to turn complex data into clear, actionable insights that guide key business decisions. As a Data Analyst, you’ll own the process from data collection and transformation through to dashboard development and stakeholder presentation. Your expertise in Power BI and data modelling will support business performance, efficiency, and strategic initiatives as the company transitions to a unified analytics platform. Key Responsibilities Minimum 3 years’ experience in data analysis or business intelligence Develop and maintain Power BI dashboards, reports, and semantic models Write complex DAX formulas and implement row-level security Conduct statistical analysis to identify trends, patterns, and actionable insights Connect to multiple data sources (SQL, Excel, APIs, cloud services) and perform ETL Ensure data quality, consistency, and accuracy across reporting outputs Support business units with ad-hoc data requests and KPI tracking Collaborate with stakeholders to define requirements and present insights Stay current with Microsoft Fabric and other evolving data technologies About You 3 years in data analytics or BI, with 2 years in Power BI development Proficient in Power BI Desktop, Power BI Service, DAX, Power Query (M language), and SQL Skilled in data modelling, star schema design, and semantic layer creation Excellent attention to detail, analytical mindset, and problem-solving skills Strong communication skills, able to convey complex insights clearly Comfortable working with large datasets and optimising performance Preferred: Experience with Microsoft Fabric, Azure Synapse, Data Factory, or PL-300/DP-600 certifications Advantageous: Familiarity with Python, PySpark, data lakes, version control, or other BI tools