Specialist: Business Intelligence (Fixed-Term Contract)

JOB DESCRIPTION

• As a Specialist: BI, with a focus on financial processes and reporting requirements combined with a passion for data solutions, the individual will be required to develop optimised BI solutions and visualise results utilising technologies from the MS BI stack and OneStream application.
• The individual needs to be able to identify opportunities for improvement of business support processes driven by data and data flows.
• 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.

DUTIES / KEY RESPONSIBILITIES

• Assist in the development of technical standards to be followed within the BI department
• Deliver solutions to junior developer/s to ensure that solutions comply with quality and compliance objectives
• Resolution of technical escalations on BI project reported incidents
• Query, analyse and build management reports
• Utilising the MS BI stack and OneStream application to produce the most effective as well as situation- and business-appropriate solution - including Microsoft SQL Server, SSIS, OneStream, MS Excel, pivot tables and other tools
• Build and maintain data warehouse processes such as data pipelines, dimensions and fact tables
• 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 refactor inefficient code
• Collaborate with IT operations and testing resources to ensure timely releases of projects and make sure database environments are sustainable
• Collaborate with IT operations to perform root cause analysis
• Be able to take directions and complete tasks on time with minimal supervision
• Participate in special projects as needed and perform 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 a brief and intelligible format, suitable for the target audience, which includes executive leadership department managers and the executive board of directors
• Establish, support, and apportion data tools to the unit He/she will actively determine prospective data and analytical requests to support management requirements
• Carry out quality assessment of data, data reports and the accompanying decisions
• Analyze findings and offer action-driven recommendations and insights to executive leaders and managers based on results
• Trail industry yardstick, trends and benchmarks, and convey such information to executive leaders

EDUCATION

• Proven track record of involvement with BI solution development projects
• 5+ Years work experience in data analysis/ mining
• 1+ Years work experience in BI cloud solution development, incl databases, data lakes data processing and visualisations
• 2+ Years work experience in designing and developing MS SSAS tabular models
• 3+ Years work experience in developing Power BI solutions
• 2+ Years work experience in data warehouse design
• Experience and understanding of financial reporting
• Impressive experience in designing managerial level presentations and reports
• Experience in analysing and carrying out interpretations by utilizing intricate data sets
• Advanced SQL Query writing skills
• Advanced Excel skills
• Experience in SSIS or another BI ETL Tool
• DAX script writing would be an advantage
• C# intermediate experience would be an advantage
• Advanced understanding of data warehousing concepts
• Experience with core web development technologies - HTML, CSS, JavaScript, etc would be an advantage
• Experience as MS SQL DBA would be an advantage
• Demonstrate skills in generating efficient, reliable working relationships with staff, and customers
• Outstanding skills in finding resolution to complicated problems while performing independently in a multifaceted and dynamic environment
• Critical-thinking and problem-solving
• Outstanding Communication skills

OTHER REQUIREMENTS

• Honesty and integrity
• Criminal and credit clear
• Punctual
• Attention to detail
• Team player
• Client-focused
• Strong analytical ability

Closing Date 28 August 2026