TERMS OF REFERENCE
BACKGROUND AND CONTEXT
General overview
Support of anti-corruption efforts in Ukraine is a high priority for the EU and Denmark contributing to the enhancement of democracy, as well as future economic growth and trade. The EU Anti-Corruption Initiative in Ukraine is a programme supported by the EU and Denmark and implemented by the Danish foreign ministry. The overall objective of the EUACI is to improve the implementation of anti-corruption policy in Ukraine, thereby ultimately contributing to a reduction in corruption.
EUACI is aimed at:
- strengthen the capacity and independence of the newly created anti-corruption institutions;
- increased efficiency of oversight over anti-corruption policies and legislation by the Verkhovna Rada;
- enhance the capacity of local government, civil society, and media to contribute to the fight against corruption.
Contracting authority
The contracting authority is the European Union Anti-Corruption Initiative in Ukraine, supported by the EU and Denmark and implemented by the Ministry of Foreign Affairs of Denmark, hereinafter referred to as the Customer.
Beneficiary
The Beneficiary is the National Anti-corruption Bureau of Ukraine (NABU). The NABU is a state law enforcement agency of Ukraine with the key objective of preventing, exposing, stopping, investigating, and solving corruption-related offenses committed by high officials, and averting new ones.
With the support of the EUACI, NABU is currently implementing three systems: the electronic case management system (eCase MS), the Information and Communication System (ICS) for exchanging information with government bodies, and the analytical Data Warehouse (DWH) system, which automates the processes of data acquisition, organization, storage, and analysis for NABU analysts.
The DWH already provides for receiving and consolidating the data from several priority public authorities, processing the accumulated arrays, also for the purpose of building a holistic informational picture based on the data collected from various sources, enabling free but controlled access to information for NABU analysts and detectives.
The availability of newly established data interchange interfaces further expands the ability to unify, merge and analyze data by NABU analysts and detectives for their activities.
OBJECTIVE
The objective of the assignment is to develop new data flows to enrich existing information entities of the DWH software package for the National Anti-Corruption Bureau of Ukraine with additional information from various authorities.
SCOPE OF WORK
The scope of work of the assignment covers the implementation of all activities required for the achievement of its objective as outlined above, including but not limited to:
- Implement data loading procedures using Oracle Data Integrator for 4 new data sources available in form of plain files, SOAP web services, xml data structures and Oracle database dumps.
- Further develop an existing physical and logical data model and its entities to store data from new sources according to Beneficiary requirements.
- Implement ETL processes using Oracle Data Integrator to fill newly developed entities and attributes with data from new sources.
- Develop and create data links with existing golden records to newly loaded entities.
Document implementation results in accordance with Oracle recommended methodology. The minimum requirements for the assignment is in Appendix 1.
DELIVERABLES
- Developed and tested DWH data model modification.
- Developed and tested ETL processes for loading and processing data from new sources.
- Project documentation developed and updated.
TIMING
The assignment will start following a notification issued by the contracting authority, but not earlier than the date of signing the contract between the EUACI and the Contractor. The tentative start date is 1 December 2023. All activities envisaged under this contract shall be completed with a total duration of up to 4 months. The project activities are expected to take place in Kyiv.
METHODOLOGY
It is envisaged that the assignment will be implemented by a team of experts familiar with the context and experienced with similar assignments.
By putting forward a team of experts, the Contractor shall ensure that the task will be developed with as much straightforwardness as possible, the proposed approach and the methodology shall be fine-tuned and a detailed work plan shall be elaborated. In the methodology, the bidders are requested to indicate their suggested division between the experts.
TEAM COMPOSITION AND QUALIFICATIONS
The Contractor’s team is expected to comprise the following profiles:
- Project Manager / Team Leader
- DWH Architect
- DWH/ETL Developer
The contractor can propose a composition of an experts team, which, in his opinion, is most appropriate for the assignment.
All members of the project team and the contractor company should execute non-disclosure agreements.
The project team should be delegated for the entire duration of the project. The composition of the project team may only be modified as a matter of exception, subject to agreement of the parties; the contractor should provide a qualified replacement in a short time.
Qualifications and Competence of Key Staff
Project Manager/Team Leader
General Qualifications
The Project Manager must at least have a Bachelor degree in Business Administration, Economics, Engineering, Computer Science, Telecommunication, IT or other relevant fields.
The Project Manager should have:
- 5+ years of experience with IT projects,
- 3+ years of experience as IT PM, and
- experience with ICT solutions in the public sector institution
Adequacy for the Assignment
The Project Manager should have:
- Project management and planning skills and the ability to lead large and complex projects
- Experience from international IT programs
- Documented experience from leading a portfolio of projects to reach business targets
- Managerial experience in a foreign donor-funded project related to the development/management of ICT solutions for a government agency
- Experience in a foreign donor-funded project would be an asset
- Managerial experience in designing and/or implementing at least one project in the area of data warehouse system for a government agency
The Project Manager should have managerial experience in designing and/or implementing at least one project in the area of data warehouse system for a government agency.
Experience in the Region and Language
- Relevant working experience from the region;
- Fluency in Ukrainian;
- Good knowledge of English.
DWH Architect
General Qualifications
The DWH Architect must at least have a Bachelor degree in Computer Science, Telecommunication, IT or other related technical fields.
- The DWH Architect should have
- 5+ years of working experience with IT architecture
- 3+ years of experience in data modelling and/or database development, SQL and PL/SQL.
Adequacy for the Assignment
The DWH Architect should have
- In-depth knowledge of relevant tools and technology, including DWH design, ETL tools, BI tools
- Experience with and ability to take partial responsibility for technically complex projects
- Ability to work independently with defined problems on a highly complex level within certain areas of expertise
- Ability to lead, train and coach other project members
- Experience in a foreign donor-funded project would be an asset
- Ability to assume roles such as head integrator or specialist in specific fields
The DWH Architect should have experience in designing and/or implementing at least one project in the area of data warehouse systems for a government agency.
Experience in the Region and Language
- Relevant working experience from the region;
- Fluency in Ukrainian;
- Good knowledge of English.
DWH/ETL Developer
General Qualifications
The DWH/ETL Developer must at least have a Bachelor degree in Business Administration, Engineering, Computer Science, Telecommunication, IT or other relevant fields.
The DWH/ETL Developer should have:
- 3+ years of working experience as an IT developer
- 3+ years of experience with IT projects
Adequacy for the Assignment
The DWH/ETL Developer should have
- Knowledge and practical application of the ETL tools, experience as a database developer, knowledge of SQL/PL SQL
- Ability to work independently with defined problems on a highly complex level within certain areas of expertise
- Ability to lead, train and coach other project members
- Experience with and ability to take partial responsibility for technically complex projects
- Experience in a foreign donor-funded project would be an asset
- Knowledge of relevant tools and technology
The DWH/ETL Developer should have experience in designing and/or implementing at least one project in the area of data warehouse systems for a government agency.
Experience in the Region and Language
- Relevant working experience from the region;
- Fluency in Ukrainian;
- Good knowledge of English.
ESTIMATED BUDGET
The full budget for this assignment all included may not exceed EUR 33,000 (approximately DKK 245,790). The Tenderer’s financial proposal shall include all costs for a fee and project-related reimbursable expenses.
PAYMENT
Payment will be made in a maximum of two installments.
The first installment, representing a maximum of 30% of the total contract value, will be made after receipt of the contractor’s updated work plan.
The second, and final payment will be made upon receipt and approval by the NABU all other supporting documents, including a final invoice.
Payment will require verification of completion of deliverables and approval by the Customer of the Contractor’s deliverables and expense outlay.
REPORTING AND MANAGEMENT
The performance of the Contractor will be judged upon reaching the purpose of this contract as well as obtaining its results, as indicated in the sections “Objective” and “Deliverables” herein respectively. Moreover, the performance of the Contractor will be judged upon the successful implementation of all the specific activities indicated in Section “Scope of work” of this document.
By signing the contract, the Contractor agrees to hold in trust and confidence any information or documents ("confidential information"), disclosed to the Contractor or discovered by the Contractors or prepared by the Contractors in the course of or as a result of the implementation of the contract, and agrees that it shall be used only for the contract implementation and shall not be disclosed to any third party.
In the period until acceptance, the EUACI, Contractor, and Beneficiary will hold regular project group meetings to exchange information and seek to clarify any questions of whatsoever nature. The purpose of the project group meetings is to ensure follow-up on any activities between the meetings, and to maintain a common overview of the current stage of the project at a detailed level, based on the applicable detailed schedule, and to ensure the day-to-day progress.
CROSS-CUTTING ISSUES
The project will be implemented to ensure equal opportunities for men and women and the integration of the youth.
HOW TO APPLY
The deadline for submitting the proposals is 8 November 2023, 17:00 Kyiv time.
All interested companies or experts should submit:
- Filled and signed Appendix 2 of this ToR (portfolio of relevant projects, technical approach, and workplan, CV of key staff)
- Financial offer.
The proposal shall include the aforementioned information and should be submitted within the above deadline to [email protected] indicating the subject line: NABU DWH development
Bidding language: English.
Any clarification questions regarding the bid request should be addressed to [email protected], no later than 31 October 2023, 17:00 Kyiv time.
EVALUATION
Bids will be evaluated in accordance with the criteria provided below:
|
# |
Criteria |
Weight |
|
1 |
Portfolio of projects |
20% |
|
2 |
Core team members - relevant experience, skills, and competencies |
40% |
|
3 |
Technical approach and methodology, including workplan |
20% |
|
4 |
Financial Offer |
20% |