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