Job Description

###

As a BI Specialist, with a focus on

RPA (Robotic Process Automation)

and the integration of machine learning and Generative AI concepts to improve operational and financial processes efficiencies. Striving to innovate, optimise and update business processes for the advancement of an efficient and effective transactional and reporting environment combined with a passion for data solutions.



The individual will be required to analyse business requirements, advice on and develop optimised BI solutions and visualise results utilising technologies from the MS BI stack.



The individual need to be able to identify opportunities for improvement of business support processes driven by data and data flows. This role requires the individual to be able to guide business and technical users through the full solution development life cycle.



The incumbent will need to take a leading role in customer interaction sessions as well as driving specific projects & solution deliverables.



The ideal candidate for this role should have a fundamental desire to deliver accurate, optimised and time efficient BI solutions aimed at improving business success through the usage of AI & ML technologies.

###

Position Overview

###

Specific Role Responsibilities

Assist in the development of technical standards to be followed within the BI department Guide intermediate and junior developers in the implementation and execution of BI strategies Guide intermediate and junior developers as well as business users with the objective to achieve an optimal technical solution to given requirements Query, Analyse and build management reports Covering the entire development life cycle of BI projects, including defining the issue statement, business and technical analysis, solution design, development, testing (internal and with business), solution implementation, end to end documentation and solution & user support Utilising the MS BI stack products to produce the most effective as well as situation and business appropriate solution - included SSRS, SSAS, MS PowerBI, Microsoft SQL query, MS Power Tools, R, Python and other relative tools Maintain an awareness and understanding of technological advances; provide continuous research and assessment of new resources and technology available Provide technical assistance to other BI team members (Information sharing) Train end users and technical support staff as required Perform code reviews, analyse execution plans, and re-factor inefficient code Collaborate with IT operations and testing resources to ensure timely releases of projects Be able to take directions and complete tasks on-time with minimal supervision Participate in special projects as needed and performs other BI related duties as assigned Work in a team environment Work on multiple assignments concurrently under aggressive deadlines Independently generate outputs which represent operational data in brief and intelligible format, suitable for the target audience, which includes executive leadership department managers and executive board of directors Establish, support, and apportion data tools to the unit managers. He/she will actively determine prospective data and analytical requests to give support to management requirements Carry out quality assessment of data, data reports and the accompanying decisions Conduct analysis of findings and offer action-driven recommendations and insights to executive leaders and managers on the basis of results Trail industry yard stick, trends and benchmarks, and convey such information to executive leaders
###

Qualifications and Experience

Grade 12 / Matric (NQF equivalent) MS BI certification Data analytics certification Bachelor of Science with Mathematics / Statistics

Required Experience/Skills:

Proven usage of the Microsoft Power Platform including Power Apps, Power Automate, Power Virtual Agents & Power BI Advance understanding of generative AI concepts and usage Proven usage and implementation of ML models - preferably using the Microsoft Stack Advanced SQL Query writing skills Critical-thinking and problem-solving Outstanding communication skills Outstanding skills in finding resolution to complicated problems while performing independently in a multifaceted and dynamic environment Work experience in data analysis / mining Advanced Excel skills

Added Advantage:

R & Python Scripting Experience and understanding of financial reporting Work experience in developing Power BI solutions DAX script writing would be an advantage Work experience in BI cloud solution development, incl databases, data lakes data processing and visualisations Work experience in designing and developing MS SSAS tabular models Experience in SSIS or another BI ETL Tool Impressive experience in designing managerial level presentations and reports C# intermediate experience Advanced understanding of data warehousing concepts Experience with core web development technologies - HTML, CSS, JavaScript, etc
###

Skills and Personal Attributes

Criminal and credit clear Reliable or own transport Punctual Attention to detail Team player Client focused Strong analytical ability Honesty and integrity Attend training initiatives to improve work quality and enhance own skills * Own and live up to the Company values