Call for Expression of Interest – Data Analyst for 2017 Audit Report of the Federation of Nigeria

Term of Reference

Data Analysis

9^th December 2019

Background

Established in 2016, Paradigm Leadership Support Initiative (PLSI) is a civic organization promoting citizens’ participation in Nigerian public audit to foster accountability, good governance and development of rural communities. PLSI is seeking data analysts to work on its “Value for Money” project supported by Open Society Initiative for West Africa (OSIWA).

PLSI work to increase civic activity around public audit and other fiscal data in Nigeria. The organization strives to ensure citizens engage with public officials and elected representatives using audit data to demand accountability and improved service delivery in their respective communities.

Objectives

Analyze and summarize 2017 audit report of the federation of Nigeria to highlight contract irregularities in the education, health and other key sectors of the economy.

Scope of work

Data analyst will be responsible for the following:

• Analyze 2017 audit report of the federation to highlight irregularities with contracts awarded in the education, health and other sectors of the economy.
• Identify mismanagement and misappropriation of public funds in contracts awarded in the education, health and other sectors as contained in the 2017 Audit report of the federation.

Duties and Responsibilities

To achieve the objective stated above, the data analyst will perform the following tasks:

• Examine capital projects audited in ministries, departments and agencies through various data sets in the 2017 audit report of the federation.
• Examine contract irregularities in key areas in health, education, water and infrastructure audited in the 2017 audit report of the federation.
• Examine trends in lack of efficiency, effectiveness and economy in the utilization of funds paid out to contractors vis-à-vis Auditor-General’s comment.
• Work with PLSI Program Manager to ensure all required and necessary data are combed and analyzed.
• Summarize observations and comments of auditor-general on audited projects examined.
• Create a single view spread sheet of analyzed data of 2017 audit report of the federation.
• Ensure data is properly cleaned up for easy visualization.
• Obtain a final sign off from PLSI
• Prepare the electronic files
• Submit all final files to PLSI on CD-Rom

Duration of Assignment

Contractor is expected to work 45 days during the period from Monday 16^th December to Wednesday 29^th January 2020.

Deliverables

• Preparation of draft spreadsheet of analyzed data of audited capital (developmental and administrative) spending in 2017 audit report of the federation.
• Final draft of spreadsheet of analyzed data of audited capital (developmental and administrative) spending in 2017 audit report of the federation reflecting comments by PLSI.

Institutional Setting and Reporting Mechanism

The contractor will be contracted by PLSI and shall report to the Executive Director while working very closely with the Program Manager. The contractor may be provided with office space if required and will receive necessary support from the Program Manager.

Duty Station

The contractor will be based in Nigeria.

Required Skills and Experience

• At least a University degree in science, social science or other related fields
• Evidence of previous work done
• Experience with Microsoft office application
• Ability to prioritize and deliver a variety of task on time
• Ability to plan for and produce quality result in meeting deadline
• Good written and communication skills

Payment Modality

PLSI standard of payment is the output-based lump-sum scheme and the payment will be made upon completion of the tasks as agreed at the time of signing the contract.

Application Procedure

The application should contain the following:

• Letter of confirmation of interest and availability indicating why s/he is the best candidate for the job.
• Personal CV with a minimum of two (2) professional referees with their email addresses.
• Submission of previous work done in related field.
• Financial proposal with a breakdown of service fee and other cost that are expected to be incurred.

These documents should be addressed to the Executive Director and sent to info@plsinitiative.org or hard copy mailed to Suites 23 & 24, Fundex Building, off Kenneth Dike Way, Ashi-Bodija, Ibadan. Kindly note that only shortlisted candidates will be contacted after the deadline.

Selection process

In the selection process, PLSI shall ensure:

• Fairness
• Non-discrimination
• Confidentiality
• Transparency