BI Report Developer at Auditor-General of South Africa

Roles & Responsibilities

Strategic Function

• Contributes to the strategy, vision, and governance of the business unit (BU).
• Deliver best practices, iterative improvement, and innovation at the strategic deployment level.
• Support the implementation of the centre balance score card (BSC) and other key projects and initiatives.
• Provide support in the implementation of automating Business Intelligence software solutions.

Product Management

• Translate business requirements into specifications that will be used to implement the required reports and dashboards, created from potentially multiple data sources.
• Design, build and deploy BI solutions such as reports, dashboards, self-service functionality, and predicative models in response to business needs.
• Design, develop, maintain and support data analytics platforms and models such as Power BI, SQL Server Analysis Services (SSAS)).
• Create analytical models to store and process data such as OLAP cubes, data marts.
• Participate with other specialists to convert legacy reports (primarily ClickView/Excel) to Power BI solutions.
• Transition developed reports and dashboards to the operations and support team.
• Conduct unit testing and troubleshooting.
• Assist with evaluating and improving existing BI systems.
• Collaborate with Digital Transformation and IT teams to integrate systems.
• Develop and execute database queries and conduct analyses.
• Develop and update technical documentation, aligned to governance standards.
• Participate in business analysis activities to gather required reporting and dashboard requirements.
• Provide support as required to ensure the availability and performance of developed reports and dashboards for both external and internal users.
• Ensure proper configuration management and change controls are implemented.
• Provide training and assistance to users for the generation of ad hoc reports.
• Identify opportunities in existing customer business processes for building reports and dashboards.
• Function as an integrator between the business and technology to create solutions for customers.
• Design and implement technology best practices, guidelines, and repeatable processes.
• Keep abreast with the latest trends and advancements in Business
• Intelligence/Data Analytics technologies and identify opportunitiesfor innovation.

Stakeholder Management

• Establish, build, and maintain collaborative and value-adding working relationships with relevant internal/external stakeholders.
• Scan the environment to ensure a clear understanding of stakeholder needs, proactively engage stakeholders to determine their needs and deliver on them in accordance to their needs.
• Engage with both internal and external stakeholders to identify and evaluate performance barriers in order to continuously improve service delivery.
• Consistently assess stakeholder feedback on performance objectives agreed with both internal/external stakeholders.
• Work in collaboration with Data Owners and Stewards to ensuretimeous delivery of the work.
• Establish and maintain relations with recognized professional bodies within their own professional sphere.
• Manage service level agreements (SLAs).

People Management

• Manage own performance to drive productivity.
• Participate and/or take lead in the business unit transformation and culture plans.
• Provide support to the management team regarding centre management and other people-related tasks.

Financial management and Operational Management

• Contribute to the compilation of centre budget, and manage project expenditure related to functional area.
• Ensure compliance to AGSA policies and procedures.
• Ensure compliance with internal processes and procedures.
• Manage supply chain processes within scope of work.

Other responsibilities (Applicable to AllJD’s)

• Perform and/or manage other projects, tasks, and assignments not stipulated on the Job description as and when required

Formal Education

• Minimum qualification of a Bachelor’s Degree in Information Technology,Business or related field, or equivalent combination of education.
• Honours or Masters will be advantageous.
• Relevant certifications in Microsoft Stack, Power BI, and data warehousing technologies (e.g., Microsoft Certified: Azure Data Engineer Associate) are desirable.

Experience/Requirements

• Minimum 8-10 years of related experience working as a Business
• Intelligence Specialist or similar role, with a focus on the Microsoft Stack, expertise in data warehousing, data lake technologies, and Power BI development.