Johannesburg: Data & BI Support Analyst

Data & BI Support Analyst Job Title: Data & BI Support Analyst Reports to (Superior): (BI) Manager Job Purpose: Work closely with the Business Intelligence (BI) Manager to transform raw, multisource data into reliable, timely, and actionable insights. This role blends strong data fundamentals with modern AI-assisted analysis to accelerate delivery of dashboards, reports, and decision support. PERSON SPECIFICATION Qualifications & Experience: Grade 12 Tertiary qualification ( Degree/Diploma in Data Analytics, Information Systems, Statistics, Computer Science or related field) 2–4 years in a Data Analyst role supporting BI/reporting, ideally in operations or service environments. Skills & Knowledge Required: SQL (intermediate to advanced): joins, aggregations, etc. Power BI: data modelling, DAX, Power Query; dashboard UX and performance optimisation. Excel (advanced): Pivot Tables, Power Query, data cleaning techniques. Nice to have: AI tool proficiency: Copilot/ChatGPT or similar for insight generation; prompt engineering best practices and result validation. Nice to have: Think-Cell Analytical storytelling: turning data into clear narratives and recommendations. Awareness of data governance and privacy (e.g., POPIA). Exposure to Python or suitable alternatives to enable report automation. Key performance indicators KPIs On-time delivery of dashboards/reports against SLAs. Data quality metrics: completeness, accuracy, reconciliation rates. Stakeholder satisfaction scores and adoption of dashboards. Measured impact of AI-assisted insights (time saved, decision quality Personal Attributes: Written Communication – The ability to express ideas clearly in memoranda, reports, letters or other documents with appropriate organization and structure, correct grammar and language and terminology that is adjusted to the Job Description: Characteristics and needs of the audience. Verbal Communication – The ability to express ideas effectively in individual or group situations (including non-verbal communication), adjusting language or terminology to the characteristics and needs of the audience. Strategic Thinking – The ability to see the “big picture” and understand the drivers for organizational success. Leading Others – The ability to lead, motivate and empower others to reach organizational goals and to inspire others to work towards a desired future state. Conflict Management – The ability to effectively manage and resolve conflict situations in the workplace. Interpersonal Sensitivity – The ability to demonstrate an awareness of how others feel and its empathetic towards the needs and feelings of others. Teamwork – A genuine intention to work cooperatively with others, to be part of a team, to work together as opposed to working separately or competitively. Business Acumen – The ability to understand the key business issues and relevant external factors impacting on the success of the organization. Drive and Commitment – The ability to set and achieve the highest possible standards of performance for oneself. Portrays a strong bias towards action. Tenacity – The ability to stay with a position or plan of action until the desired objective is achieved or it is no longer reasonably attainable. Negotiation – The ability to effectively explore alternatives and positions in situations that consist of many different opinions and objectives in order to reach outcomes that gain all parties support and acceptance. Persuasiveness – The ability to communicate in a convincing manner and to influence people. Planning, Organizing & Controlling – The ability to establish courses of action for self and/or others to ensure the efficient completion and control of work. Task Structuring – Plans, prioritizes and structures own work, seeks closure, achieves own objectives and manages own time. Analytical Thinking – The ability to identify causal relationships or use inference chains to break a large problem into manageable pieces in a systematic manner. Judgement – The ability to evaluate information, carefully consider a wide range of possibilities and display logical reasoning. Decision Making – The ability to arrive at sound conclusions and/or decisions. Implementing Decisions – The ability to follow through on decisions and to take responsibility for the implementation thereof. Adaptability – The ability to maintain effectiveness when changes in the work environment take place. Motivation and Work Ethic – Must show enthusiasm and commitment in order to continually contribute towards maintaining standards of excellence. Must display a concern for fairness and justice. Must display high levels of integrity. Problem Solving & Decision Making – The ability to take initiative in routine decision-making and problem-solving situations is essential in order to make objective judgments. Must be able to cope with any problems and challenges. JOB SPECIFICATION: The main tasks and responsibilities associated with the position are listed below. This is not an exhaustive list of tasks and responsibilities and any other tasks and/or responsibilities that could be reasonably expected for the position may be required. Design, build, and maintain data pipelines (ETL) from SQL databases, Excel/CSV and other sources. Develop, publish, and iterate dashboards and reports in Power BI (data modelling, DAX, Power Query). Write performant SQL for data extraction, validation, and KPI calculations. Assist with implementing data quality checks in reporting. Use AI tools (e.g., Copilot, ChatGPT) to accelerate insight generation: trend summarisation, anomaly detection, hypothesis framing, and executive-ready narratives. Apply sound best practices in validating data before distributing any analytical data for internal or external consumption by stakeholders. Collaborate with the BI Manager and stakeholders to translate requirements into data artefacts, dashboards, and insights. Working conditions: Office base Note: Management and/or superiors may from time to time assign additional duties to you that must be carried out in a professional working manner. Management reserves the right to amend or alter this job description and the employee’s specific tasks, within the generally agreed appointment from time to time and can give any lawful instruction, according to the growing needs of the company.