National Training and technical assistance of Eurotrace for trade Statistics in Botswana

SADC SECRETARIAT

REQUEST FOR EXPRESSION OF INTEREST (INDIVIDUAL CONSULTANTS SELECTION)

COUNTRY: Botswana

NAME OF PROJECT: SADC REGIONAL STATISTICS PROJECT (RSP)

PROJECT ID: P175731

ASSIGNMENT TITLE: INDIVIDUAL CONSULTANCY TO CARRY OUT NATIONAL TRAINING AND TECHNICAL ASSISTANCE ON EUROTRACE TO BOTSWANA STATISTICS AGENCY

REFERENCE NUMBER: SADC/3/5/2/393

DATE OF ISSUE: 22 April 2025

Background

The SADC Secretariat through the SADC Regional Statistics Project has received a grant. The aim of this grant is to strengthen the institutional capacity of SADC and participating countries to produce, disseminate and use quality statistics while increasing regional harmonization and collaboration.

The Regional Infrastructure Development Master Plan (RIDMP), the SADC Regional Agricultural Policy (RAP), the Industrialisation Strategy and the Roadmap, among others, are complementary guiding frameworks for achieving the regional integration agenda. SADC has also developed various Protocols for domestication and implementation by Member States including the most recent one, the Protocol on Statistics, to enhance harmonization of statistics. The operating framework for implementing statistical activities as priorities for the region is the Regional Strategy for Development of Statistics (RSDS) and is aligned to SADC Vision 2050 and RISDP 2020-30.

Demand for quality and harmonized statistics has been on the rise to monitor progress in developmental agendas at national, regional, continental, and global level. The scope of data demand cuts across economic, social, and on emerging issues such as climate change, disaster-risk, environment and others related.

The SADC Secretariat intends to apply part of the proceeds of this financing to eligible payments under the contract for hiring an INDIVIDUAL CONSULTANCY TO CARRY OUT NATIONAL TRAINING AND TECHNICAL ASSISTANCE ON EUROTRACE TO BOTSWANA STATISTICS AGENCY

The SADC Secretariat invites submissions from suitably qualified and interested individual consultants to conduct the training, recruited as individual consultant following World Bank Procurement Regulations dated September 2023.

Title : INDIVIDUAL CONSULTANCY TO CARRY OUT NATIONAL TRAINING AND TECHNICAL ASSISTANCE ON EUROTRACE TO BOTSWANA STATISTICS AGENCY (1 Position)

Time Commitment : 100%

Accountable : Senior Officer, Research and Statistics

Duration of Assignment: 3 months

• The Objectives of the Assignment

•

• Overall objective

The overall objective of this exercise is to train Member States on the use of statistical software for merchandise trade statistics.

•

• Specific objectives

The specific objective of the assignment is to undertake an advance national training on EUROTRACE, especially Structured Query Language (SQL)server based EUROTRACE to Statistics Botswana to process and analyse trade data. Another objective is to provide technical assistance on assessment of the EUROTRACE system challenges faced by Statistics Botswana.

1.3 Expected results

The consultant is expected to achieve the following results in the following:

• Strengthened technical capacity of Statistics Botswana in the effectively and efficiently management and processing of trade data using SQL Server based EUROTRACE;

• Sources of challenges with EUROTRACE identified, documented and resolved; and

• Statistics Botswana to process and disseminate trade statistics using Eurotrace (SQL).

• QUALIFICATION AND EXPERIENCE REQUIREMENTS

This assignment is expected to be carried out by an individual consultant as the Master Trainer and strong experience and there should be evidence of in-depth knowledge of EUROTRACE. The specific profile is provided below:

2.1 Qualifications and Skills

•

• A minimum of a Degree in statistics, economics, IT, Data Science or related field, A Masters degree and above shall be an advantage.

• Certificate in trainings on EUROTRACE

• Written and oral fluency in the English language is essential.

• Excellent oral and written communication, analytical, presentation and report writing skills in English Language.

• Excellent time management and organizational skills to prioritize workload and deliver needful during the training week.

2.2 General Professional Experience

•

• The Expert Must have at least fifteen (15) years of experience in merchandise trade statistics compilation and dissemination.

2.3 Specific Professional Experience

• Demonstrated experience for at least 10 years using EUROTRACE for processing and dissemination of merchandise trade statistics at national, regional or continental level;

• Demonstrated experience as a resource person in delivering at least 5 trainings/technical assistance activities to developing countries at national, regional and continental level in Eurotrace software

• The expert must be independent and free from conflicts of interest in the responsibilities they take on.

• Duration of the assignment

The Individual Consultant will work within the 3 months from the date of signing the agreement.

• Facilities to be provided by the Client

The assignment will mostly be home-based and shall require travel to the Botswana to conduct the training and technical assistance.

• Location of Employment

The assignment will involve traveling to the Botswana to conduct the training and technical assistance.

• The attention of interested Consultants is drawn to Section III, paragraphs, 3.14, 3.16, and 3.17 of the World Bank’s “Procurement Regulations for IPF Borrowers” dated September 2023 (“Procurement Regulations”), setting forth the World Bank’s policy on conflict of interest.

• A Consultant will be selected in accordance with the Individual Consultant Selection Method set out in the Procurement Regulations.

• Mode of Application

Interested Individuals Consultants meeting the stated requirements should submit their Expressions of interest including updated detailed curriculum vitae (CVs) and copies of professional certificates must be delivered in a written form using a drag and drop electronic tender box by Friday 9 May 2025 on or before 23:59 hours, Botswana local time. No public opening will be held.

SADC Collab link: https://collab.sadc.int/s/e86ZoLGT2dQACnC

Kindly note that only highly technically scored bidder will be contacted for negotiations meeting.

• VALIDITY OF THE TECHINICAL PROPOSAL

Your Technical proposal should be valid for a period of 120 days from the date of deadline for submission.

• Additional requests for information and clarifications can be made through the address below:

The Procuring entity: SADC Secretariat

Head of Procurement Unit

Contact person: Ms. Mercy Mikuwa

Telephone: +267 364 1989 / 3951863

Fax: 3972848

E-mail: [email protected]

Copy to: [email protected]

Annex 1- CURRICULUM VITAE (CV)

Education: {List college/university or other specialized education, giving names of educational institutions, dates attended, degree(s)/diploma(s) obtained}

________________________________________________________________________

Employment record relevant to the assignment: {Starting with present position, list in reverse order. Please provide dates, name of employing organization, titles of positions held, types of activities performed and location of the assignment, and contact information of previous clients and employing organization(s) who can be contacted for references. Past employment that is not relevant to the assignment does not need to be included.}

|

|

|

|

|

|

|

|

|

Membership in Professional Associations and Publications: ______________________________________________________________________

Language Skills (indicate only languages in which you can work): ______________

______________________________________________________________________

Adequacy for the Assignment:

Detailed Tasks Assigned on Consultant’s Team of Experts:

Reference to Prior Work/Assignments that Best Illustrates Capability to Handle the Assigned Tasks

{List all deliverables/tasks as in REOI or TORS in which the Expert will be involved)

|

|

|

|

|

Experts contact information: (e-mail …………………., phone……………)

Certification:

I, the undersigned, certify that to the best of my knowledge and belief, this CV correctly describes myself, my qualifications, and my experience, and I am available to undertake the assignment in case of an award. I understand that any misstatement or misrepresentation described herein may lead to my disqualification or dismissal by the Client, and/or sanctions by the Bank.

{day/month/year}

Name of Expert Signature Date

Annex 2 Detailed TORs

TERMS OF REFERENCE

CONSULTANCY TO CARRY OUT A NATIONAL TRAINING AND TECHNICAL ASSISTANCE ON EUROTRACE TO BOTSWANA STATISTICS AGENCY

BACKGROUND INFORMATION

•

• Background

The Southern African Development Community (SADC) is a Regional Economic Community comprising 16 Member States, namely; Angola, Botswana, Comoros, Democratic Republic of Congo, Eswatini, Lesotho, Madagascar, Malawi, Mauritius, Mozambique, Namibia, Seychelles, South Africa, Tanzania, Zambia, Zimbabwe. Established in 1992, SADC is committed to Regional Integration and poverty eradication within Southern Africa through economic development and ensuring peace and security.

Article 14 of the SADC Treaty establishes the SADC Secretariat as the principal executive institution of SADC. The Secretariat perform