Technical task (ToR)
Swiss import promotion program (Sippo), which is implemented by Swisscontact, supports business support organizations (BSO) in improving the quality of their export-oriented services. One of the partners of the SIPPO program in Ukraine is the "Ukrkondprom" Association, which represents the interests of confectionery manufacturers, food concentrate and coffee products.
In response to challenges, related to war, changes in market conditions and the need to expand export opportunities, there was a need to create a systematic approach to collection, data processing and analysis. This will allow the Association to effectively search for new counterparties, optimize analytical processes and reduce dependence on external sources.
The purpose of the task
To strengthen the analytical capacity of the "Ukrkondprom" Association by:
- identification of relevant open and commercial databases;
- testing their effectiveness;
- development of recommendations for integration into internal processes;
- implementation of data processing tools (Power BI, Tableau, Excel, etc).
As part of the task, the Contractor must:
- Conduct an audit of available databases (free and paid), that cover:
- importers of food products;
- trade networks, distributors, suppliers of raw materials;
- logistics platforms and trading platforms.
- Determine criteria for evaluating databases (relevance, amount, renewal, accessibility, cost etc).
- Prepare a catalog of recommended databases with a description of their contents, access conditions, advantages and disadvantages.
- Select at least 8 bases for testing.
- Conduct practical testing (demo access or temporary accounts).
- Evaluate functionality, convenience, precision, the possibility of integration with analytical tools.
- Prepare an analytical report with an assessment of each base.
- Provide subscription/license recommendations for the 2-3 most relevant databases.
- Develop a plan for the integration of databases into the internal processes of the Association.
- Prepare a final report summarizing the results and recommendations.
Expected results
- Catalog of databases, suitable for regular use.
- Base evaluation table by key criteria.
- Subscription/License Guidelines.
- Implemented analytics tools.
- Final report with results and integration plan
Implementation methodology
The executor must apply a step-by-step approach to the implementation of the task, which includes:
- A step-by-step approach: audit → testing → report.
- Practical testing with focus on real business tasks.
- Coordination with the SIPPO team and Ukrkondprom.
- Lack of conflict interests with potential counterparties
Duration and execution schedule
Expected duration of the task – before 15 December 2025.
Requirements for the Executor
The performer must respond to the following criteria:
- Experience in data analytics or information systems.
- Knowledge of Power BI, Tableau, Excel, SQL.
- Experience in developing data analysis techniques.
- Ability to present results in an analytical form.
- Proficiency in Ukrainian and English.
- Understanding the specifics of the confectionery industry, work of the Association and export processes
Payment and contract
An official contract will be concluded with the Contractor, developed by the Swiss Foundation for Technical Development Cooperation "Swiskontakt", which implements the SIPPO program in Ukraine.
Contract currency: hryvnia (UAH).
Payment format:
- 100% post-payment — after successful completion of the task and submission of report documentation;
- or payment in stages - as agreed between the parties.
All terms of cooperation, including the schedule, volume of work, reporting format and payment, will be fixed in the contract between the Contractor and Sviskontakt.
Accountability. The consultant is accountable to the SIPPO Ukraine team and coordinates his work with the representative of the SIPPO program in Ukraine and the program team
Applications and questions send to the address: ukrkondprom@gmail.com
