Job Description

###

As a BI Specialist, with a focus on financial processes and reporting requirements combined with a passion for data solutions, the individual will be required to analyse business requirements, advice on and develop optimised BI solutions and visualize results utilizing technologies from the MS BI stack. The successful individual must 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 ideal candidate for this role should have a fundamental desire to deliver accurate, optimised and time efficient BI solutions aimed at improving business success.###

Position Overview

###

Specific Role Responsibilities

Query, Analyse and build management financial report 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 Excel, pivot tables and other 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 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 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 Diploma / Higher qualification with corporate or management finance an advantage 5+ Year's work experience in data analysis / mining 3+ Year's work experience in BI report writing using SSRS or other BI report and dashboard development tools 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 2+ Year's work experience in data warehouse design 2+ Year's work experience in designing and developing MS SSAS tabular models 3+ Years working experience in developing Power BI solutions DAX script writing would be an advantage C# intermediate experience would be an advantage Advanced understanding of data warehousing concepts as described by subject matter thought leaders Experience with core web development technologies - HTML, CSS, JavaScript, etc would be an advantage Experience as MS SQL DBA would be an advantage
###

Skills and Personal Attributes

Demonstrate skills in generating efficient, reliable working relationships with exco, 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 Critical-thinking and problem-solving skills Outstanding communication skills 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