Business Intelligence Developer - WRHI - Gophelega

Main purpose of the job:

• To lead the development and maintenance of the business intelligence, data analytic systems, processes, and procedures for the Gophelega programme and to provide overall support for the data analytics of the Gophelega programme

Location:

• Pretoria – Tshwane

Key performance areas:

• Lead the design, development, and improvement of the Gophelega programme’s Business Intelligence solutions and manipulation of relevant data sources
• Manage the Gophelega programme performance dashboards, including regular data entry, quality control and dissemination
• Support teams in interpreting performance dashboards
• Support teams with data requirements as requested, including the setup and updating of monthly Quality
• Improvement Project dashboards and cascades
• Prepare data for presentations, reports and analyses as requested
• Contribute to the analysis and write up of the programme’s publications and reports
• Liaise with Gophelega
• SI Advisors to verify, quality assure and troubleshoot programme data
• Participate in data verification and reporting activities
• Provide data quality support as appropriate
• Identify and implement efficiencies in data collection, compilation, review, reporting, feedback and action plans
• Ensure the development and maintenance of ETL processes, and programme data warehousing
• Maintain full compliance with the system and data architecture, standards and procedures
• Prepare designs, estimates and functional specifications of databases
• Develop and maintain SSR and Power BI reports
• Provide technical solutions to enhance the Programme Data Warehouse and Business Intelligence solutions
• Work with the Strategic Information and Programme Teams in the development of standard and bespoke reports utilising data warehouse and data feeds
• Ensure all required data is available in the data repository, manage the specification and coordinate the development
• Be responsible for active maintenance of the data repository ensuring integrity, consistency, and relevant documentation
• Ensure the smooth operation of ETL processes and high availability of Business Intelligence infrastructure
• Participate in the timely and accurate programme submissions to donor requests
• Participate in the timely and accurate programme submissions to non-donor stakeholder requests
• Support the content development for JPPM, quarterly reports and other stakeholder meetings
• Support programme teams with target setting initiatives
• Communicates clearly and effectively with all levels of the institute staff around programmatic inputs and outputs
• Communication with local, regional and international collaborators and stakeholders including donors and sponsors when and if required
• Identify data analysis and presentation training needs
• Liaise with the relevant SI Advisors and Data Mentors to address training needs and possibly implement training interventions
• Take ownership and accountability for tasks and demonstrates effective self-management
• Follow through to ensure that quality and productivity standards of own work are consistently and accurately maintained
• Maintain a positive attitude and respond openly to feedback
• Take ownership of driving your own career development by participating in ongoing training and development activities such as conferences, workshops, etc.

Required minimum education and training:

• Degree in Computer Science, Sciences or Statistics, Information Science or any other relevant degree
• Experience with Microsoft SQL Server, T-SQL, SQL Server Reporting Services (SSRS), SQL Server Integration Services (SSIS) and SQL Server Analysis Services (SSAS), Microsoft Power BI, Microsoft SharePoint, Performance Point, Excel and Power Pivot

Required minimum work experience:

• Minimum 2 years building and maintaining ETL processes, Data Warehouses and maintaining full compliance to systems and data architecture, standards and procedure
• Valid SA driver’s licence

Desirable additional education, work experience and personal abilities:

• Experience implementing and managing M&E systems; Working with donor-driven programmes
• Recognised qualifications in MS SQL Server technologies advantageous
• Knowledge/awareness of data warehousing theory and methodologies
• Knowledge awareness and skills in data modelling, and or database architecture design advantageous
• Good understanding of data quality and ability to develop data quality reporting mechanisms
• Demonstrated leadership, management and change management ability
• Positive, energetic team leader with an ability to adapt to complex situations, manage stress, deliver goals pro-actively
• Organized with a thorough and accurate approach to work, attention to detail

Demands of the job:

• Travel may be required from time to time
• Overtime will be required
• Must be able to work in time-constrained, highly pressurized deadline-driven environments

Communications and relationships:

• Excellent communication skills (both written and oral) in English
• Ability to establish and maintain effective working relationships with internal stakeholders at all levels within the organization, as well as all external stakeholders

TO APPLY:

• Only if you do meet the minimum job requirements and experience as mentioned above, you may submit a detailed updated CV.
• Please Apply Online and complete your registration on Ditto Hire (our application tracking system) to enable and protect you as a candidate to accept the new POPIA terms and conditions. This will then create your permanent profile with which you can apply for all jobs as advertised by AJ PERSONNEL. However, you may remove your profile from AJ PERSONNEL when you are no longer in the job market.
• AJ Personnel is fully POPIA Compliant.
• Please take note that the applicants who do not adhere to the above criteria will not be considered for the respective position.
• The closing date for all applications: 11 May 2022.
• Wits Health Consortium will only respond to shortlisted candidates.
• Candidates who have not been contacted within two weeks of the closing date can consider their applications to be unsuccessful.
• Note WHC, in accordance with their Employment Equity goals and plan, will give preference to suitable applicants from designated groups as defined in the Employment Equity Act 55 of 1998 and subsequent amendments thereto.
• PLEASE NOTE: Our Client, WHC - RHI, maintains mandatory Covid-19 requirements, and as such only Covid-19 vaccinated incumbents will be considered for positions.

Please note:

• AJ Personnel is only responsible for advertising the advertisement on behalf of their client Wits Health Consortium.
• AJ Personnel does not have any salary or other information regarding the position.