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.

Job Specifics Location: Modderfontein, JHB Role Type: Permanent Work Type: On-Site Job Overview An established organisation is seeking a Data & BI Support Analyst to support its Business Intelligence function. The successful candidate will work closely with the BI Manager to transform multi-source data into accurate, timely, and actionable insights. This role combines strong data fundamentals with modern, AI-assisted analytics to accelerate reporting, dashboard development, and decision support. Key Responsibilities Design, build, and maintain data pipelines (ETL) from SQL databases, Excel/CSV files, and other data sources Develop, publish, and continuously improve dashboards and reports using Power BI, including data modelling, DAX, and Power Query Write efficient and reliable SQL queries for data extraction, validation, and KPI calculations Support the implementation of data quality controls, including completeness, accuracy, and reconciliation checks Apply best practices to validate and verify data prior to internal or external distribution Leverage AI-enabled tools (e.g. Copilot, ChatGPT or similar) to accelerate insight generation, including trend analysis, anomaly detection, hypothesis development, and executive-ready narratives Collaborate with the BI Manager and business stakeholders to translate business requirements into analytical outputs and insights Contribute to continuous improvement of reporting processes and analytical delivery Qualifications and Experience Grade 12 (or equivalent) Relevant tertiary qualification (Degree or Diploma) in Data Analytics, Information Systems, Statistics, Computer Science, or a related field 2–4 years’ experience in a Data Analyst or BI support role, preferably within operational or service-driven environments Technical Skills and Knowledge Intermediate to advanced SQL (joins, aggregations, performance optimisation) Power BI expertise, including data modelling, DAX, Power Query, and dashboard performance optimisation Advanced Excel skills, including Pivot Tables, Power Query, and data cleansing techniques Exposure to Python or similar tools for reporting or automation (advantageous) Awareness of data governance, data quality, and data privacy principles (e.g. POPIA) Experience with AI-assisted analytics tools for insight generation (advantageous) Think-Cell experience (nice to have) Strong analytical storytelling skills, with the ability to translate data into clear, actionable insights Behavioural and Personal Competencies Strong written and verbal communication skills, with the ability to tailor messaging to different audiences Analytical and critical thinking with sound judgement and decision-making ability Strong planning, organisation, and time management skills Ability to work collaboratively within a team and engage effectively with stakeholders High levels of integrity, professionalism, and work ethic Adaptable and resilient, with the ability to perform effectively in a changing environment Proactive problem-solving mindset and a bias towards action and continuous improvement