Location: Bedfordview, JHB
Benefits offered: Lucrative salary + In-house medical aid (Imperial Motus Med – 50/50 contribution)
Retirement Fund (50/50 contribution)
Type of Contract: Permanent
CV Submission Deadline: 03 September 2023
Job Description
As a Senior 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 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 Senior BI Specialist need to technically oversee planned and developed solutions to ensure alignment to the BI strategic objectives as well as confirming that solutions meet quality and compliance requirements. 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.
Job Scope
Assist in the development of technical standards to be followed within the BI department
• Oversee solutions delivered by intermediate and junior developers to ensure that solutions comply to quality and compliance objectives
• Guide intermediate and junior developers in the implementation and execution of BI strategies
• Resolution of technical escalations on BI project reported incidents
• 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 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
Minimum qualification/experience required (CVs may match nearest experience or qualification equivalent)
Grade 12 / Matric (NQF equivalent)
MS BI certification
Data analytics certification
Diploma / Higher qualification with corporate or management finance an advantage
Proven track record of leading BI solution development projects and BI service delivery teams
• 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 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
What are your EE/AA requirements?
Preferably persons with disabilities
Any specific information you would like to add which is critical to the role?
• Cloud experience is a must
• Technical team leading experience a must
• Strong SQL coding
• Strong SQL server analysis experience
• Strong Data Analytics
• DAX code advantageous
Send CV and supporting documents to: admin@thisability.co.za
