Cape Town City Centre: Junior Data Analyst (CPT)

About the Role

We are seeking a Junior Data Analyst to join our team in Cape Town City Centre. As a key member of our operations, you will be responsible for helping turn operational, commercial, and performance data into meaningful insights that support better decision-making across the business.

Key Responsibilities

• Data Collection & Processing: Gathering, clean, and organise large datasets from multiple sources, ensuring data accuracy and reliability.
• Data Analysis: Apply advanced analytical techniques to identify trends, generate insights, and support business decisions.
• Reporting & Visualization: Create reports and data visualisations using Power BI within the MS Fabric framework, presenting findings in a clear and easy-to-understand format.
• T-SQL and Python: Perform T-SQL queries (or Python scripts) to extract and manipulate data for analysis and reporting tasks.
• Collaboration: Work closely with Senior Analysts and other departments to understand business needs and contribute to ongoing projects.
• Documentation & Process Improvement: Document analysis processes, workflows, and procedures, identifying areas for optimization and efficiency improvements.
• Attention to Detail: Ensure high accuracy in all aspects of data cleaning, analysis, and reporting to maintain quality standards.
• Critical Thinking: Understand the data, ask relevant questions, and derive actionable insights to maximize its value.
• Communication: Present findings effectively through written and verbal communication, tailoring insights for technical and non-technical audiences.
• Excel Proficiency: Use advanced functions in Microsoft Excel, including pivot tables, v-lookups, and basic macros, for data organization and analysis.

Requirements

• 2 Years of experience in Data Visualization using tools like Power BI, Tableau, or similar platforms, or exposure to T-SQL for querying databases or Python for basic data manipulation.
• Strong organizational and time management skills to handle multiple reporting deadlines.
• Excellent attention to detail, ensuring accuracy in all aspects of work.
• Strong analytical and critical thinking abilities to interpret data and generate actionable insights.
• Effective communication skills to present findings to technical and non-technical audiences.
• Proficiency in Microsoft Excel, including functions like pivot tables, v-lookups, and basic macros.

Salary & Benefits

Salary details not specified