IRD SA NPC: Business Intelligence Developer

Please note: this opportunity closing date has passed and may not be available any more.
Opportunity closing date: 
Friday, 16 April, 2021
Opportunity type: 

Employment type: Fixed term contract
Reporting to: M&E Advisor

Interactive Research and Development South Africa (IRD SA NPC) is a South African Section 21 not-for-profit entity and an affiliate of Interactive Research and Development Global (IRD Global), and has fully operational offices in Johannesburg, Pretoria (Gauteng) and in Durban (KwaZulu-Natal).
Position Summary

The Business Intelligence (BI) Developer will work collaboratively with managers and end users to develop reporting systems that provide accessible information for decision-making. The BI Developer uses warehouse data to solve organizational problems through reports, analysis and data visualization. The BI Developer will provide project wide data warehouse expertise with emphasis on data design, access, usage, security and quality of information assets. The BI Developer will be in charge of developing, deploying, and maintaining BI interfaces. Those include query tools, data visualization and interactive dashboards, ad hoc reporting, and data modelling. The BI developer will build and maintain a data warehouse design to generate reports on business and public health intelligence to aid in project performance monitoring and project decision making.

Key Accountabilities (included but not limited to)
Data Analysis and Business Intelligence    

  1. Lead the design, development, and improvement of the projects Business Intelligence solutions and manipulation of relevant data sources;
  2. Manage the projects performance dashboards, including regular data entry, quality control and dissemination;
  3. Support technical and field teams in interpreting performance dashboards;
  4. Support technical team with data requirements as requested, including the setup and updating of monthly dashboards and cascades;
  5. Prepare data for presentations, reports and analyses as requested;
  6. Contribute to the analysis and write up of the project’s quarterly and annual reports;

Data Management and Reporting

  1. Liaise with project M&E Advisor to verify, quality assure and troubleshoot program data;
  2. Participate in data verification and reporting activities;
  3. Provide data quality support, as appropriate;
  4. Identify and implement efficiencies in data collection, compilation, review, reporting and feedback;
  5. Ensure the development and maintenance of ETL processes, and project data warehousing;
  6. Maintain full compliance to the system and data architecture, standards and procedures;
  7. Prepare designs, estimates and functional specifications of databases;
  8. Develop and maintain SSRS and Power BI reports;
  9. Provide technical solutions to enhance the project’s data warehouse and Business Intelligence solutions.
  10. Work with the project technical and management teams to develop standard and customized reports utilizing data warehouse and data feeds;
  11. Ensure all required data is available in the data repository, and/or manage the specification and coordinate the development of systems to ensure data is available in the repository;
  12. Be responsible for active maintenance of the data repository ensuring integrity, consistency, and relevant documentation;
  13. Ensure the smooth operation of ETL processes and high availability of Business Intelligence infrastructure.

Coordination and Communication:

  1. Work closely with M&E Advisor to ensure smooth implementation of BI activities;  
  2. Participate in the timely and accurate program submissions to donor requests;
  3. Support the content development for the project, quarterly reports and other stakeholder meetings;
  4. Support technical teams with target setting initiatives;
  5. Communicate clearly and effectively with management team around project inputs and outputs
  6. Stay updated with business operations and business intelligence processes.
  7. Liaise with the M&E Advisor to address training needs and possibly implement training interventions.



  • 2-3-year’s work experience building and maintaining ETL processes, data warehouses and maintaining full compliance to systems and data architecture, standards and procedure;
  • Experience implementing and managing health program M&E systems;
  • Experience working with PEPFAR/USAID/CDC programs;
  • 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;
  • Recognised qualifications in MS SQL Server technologies is advantageous;
  • Strong understanding of DOH and PEPFAR data and reporting systems;


  • Must be pro-active, self-motivated, energetic, flexible, adaptive and innovative
  • Broad knowledge, skills and abilities associated with the design and implementation of data collection and data reporting systems;
  • Broad knowledge of statistical analysis, programming and database design methodologies;
  • Expert knowledge of Excel and other software for Dashboard development;
  • Strong ability to interpret and analyse complex datasets and knowledge of data analysis software;
  • Strong and effective oral and written communication skills;
  • Strong interpersonal skills in working with colleagues, functional peer group managers and management in other parts of the organization as well as partner and funding organizations;
  • Ability to work under general direction and with minimal supervision, prioritize program activities, manage multiple activities with competing timelines and deadlines, and multitask;
  • Ability to work in time constrained, high pressure, deadline-driven environment;
  • Knowledge of concepts of TB/HIV public health, epidemiology, statistics, and surveillance is advantageous;
  • Valid driver’s licence;


  • Internal:

    • M&E Advisor, Data Manager, M&E Officer, NIMDR-TB Professional Nurse,  Sub-District Coordinator, Project Lead

  • External:

    • TB, DR-TB and TB-HIV District and Facility Co-ordinators, District Department of Health, NGO’s, Partners, Private Sector, Funding Agencies

Working conditions:

  • Willingness and availability to travel within district
  • On occasion, to work long and/or irregular /or after hours/ holidays and weekends if the needed to reach objective and deadlines

Interested candidates are welcome to apply, please provide two (2) current, relevant employment references. Submit a brief CV and supporting documents, indicating the job title in your cover letter and subject line on email to Lee-Anne Ogle: Human Resources Dept. @ fax +27 (0) 865722820 or e-mail
Closing date for applications: Friday, 16th April 2021
Salary range CTC: Market Related. Bio-data will also be taken into consideration.
Should you not hear from us within 2 weeks of the closing date, kindly regard your application as unsuccessful
IRD SA is an equal opportunity employer


NGO Services

NGO Services

NGO Events