The main objective is to assist the National Agency in building comprehensive and innovative IT solutions. The period of implementation of the contract will be 12 months, with a duration of 75 working days.
The main objective of the technical support to be provided to the NACP within the framework of this engagement is to assist the National Agency in building the comprehensive and innovative IT solutions for corruption prevention through expert assistance in 3 components:
deep analysis of the NACP data landscape including registries and systems that NACP operates, external registries/sources and open data datasets available to NACP, to propose an approach to effective collection, storage, processing and interoperability of data;
designing an effective and end-to-end data model of new means of detecting corruption schemes using risk analysis, as well as data model for collecting and processing statistical information on conducted inspections, analysis of potential for integration with databases and data sets;
provision of consultations on data processing, building data sets and data models for development and launch of the NACP IT solutions (eCase system), upgrading existing solutions (system of Logical and Arithmetical Control), and contributing to the corresponding TOR’s for the system in case of positive decision on supply and implementation analytical platform (DWH/DM system).
2. Scope of work and expected deliverables
Scope of work
Analysis of existing databases and datasets that NACP owns or has access to in terms of the data formats, data quality and interoperability.
Designing data models for collecting and processing statistical information on conducted inspections.
Designing data model of new means for detecting corruption schemes using risk analysis approach developed by NACP.
Assistance in finalization and launch of eCase system, provision of consultations on data migration from the previous system, approaches to organization of data collected within the system, it’s interoperability with existing and planned IT projects of the NACP.
Analysis of data-related functionality and participation in the development of technical requirements for the Portal of Anti-Corruption Officers.
Provision of technical expertise on data storage structures, data mining, data verification and data cleansing for the NACP IT systems, cooperation with NACP management to define and prioritize data-related needs within preparation of the NACP IT strategy for 2021-2023.
In case of positive decision on supply and implementation of DWH/DM analytical platform, contribution to the development of TOR for the system as a data analyst subject matter expert to determine and clarify requirements/scope of work for the project.
Other data-related analysis up to the request of the NACP management.
3. Expected deliverables:
Data analysis in form of the consolidated report on datasets needed/ processed/ available, the format of the data, accessibility and interoperability for the following projects:
e-Case (Case management system)
Updated Portal of declarations, including Logical and Arithmetical control module
Register of Political Parties Financial Reporting
Updated Register of corrupt officials
Portal of Anti-Corruption Officers
Portal of Whistleblowers.
Designed data model for collecting and processing statistical information on conducted inspections.
Designed data model of new means for detecting corruption schemes using risk analysis approach.
Prepared recommendations on data migration to eCase from the previous system, approaches to organization of data collected within the eCase system, its interoperability with existing and planned IT projects of the NACP.
Prepared recommendations on data-related functionality to technical requirements for the Portal of Anti-Corruption Officers.
Provided technical expertise on data storage structures, data mining, and data cleansing for the NACP IT systems, conducted interviews with NACP management to define and prioritize data-related needs within preparation of the NACP IT strategy for 2021-2023.
Prepared narrative report (5 pages long) with identification of key results and recommendations for further development.
The period of implementation of the contract will be 12 months, with the duration of 75 working days. The intended commencement date is the date of signature of the contract with the consultant.
5. Professional Requirements
Master’s/Bachelor's degree in IT, Mathematics or related field (or equivalent work experience)
At least 5 years in the IT industry
At least 3 years working experience as a Data Analyst, Data Scientist or Business Analyst
Technical expertise regarding data models, database design development, data mining and segmentation techniques
Experience using statistical computer languages (R, Python, SQL, etc.) to manipulate data and draw insights from large data sets
Experience working with and creating DB/DWH/DL architectures, design ETL/ELT will be considered as an advantage.
Knowledge of a variety of machine learning techniques (clustering, decision tree learning, artificial neural networks, etc.) and their real-world advantages/drawbacks
Knowledge of advanced statistical techniques and concepts (regression, properties of distributions, statistical tests and proper usage, etc.) and experience with applications
Open-source projects or work examples available on GitHub for review will be an advantage
Ability to work in a team
Strong analytical skills with the ability to collect, organize, analyze, and disseminate significant amounts of information with attention to detail and accuracy
Effective problem-solving, negotiation, and decision-making skills
Fluency in written and oral Ukrainian and English
6. Monitoring and evaluation
Definition of indicators
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 "Expected Deliverables" herein respectively. Moreover, the performance of the contractors will be judged upon successful implementation of all the specific activities indicated above.
By signing the contract, the contractors agree to hold in trust and confidence any information or documents ("confidential information"), disclosed to the contractors 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 purposes of the contract implementation and shall not be disclosed to any third party.
The contractor reports to the EUACI. The contractor shall be briefed prior to starting with the assignment. The contractor shall de-brief the EUACI prior to finalizing the assignment.
The contractor shall immediately inform the EUACI after 50% and again after 75% use of the overall foreseen working days under this contract.
7. Cross-cutting issues (integration of the youth, equal opportunities)
The project will be implemented to ensure equal opportunities for men and women and integration of the youth.
HOW TO APPLY
Deadline for submitting the proposals is 8 September 2021, 18:00 Kyiv time.
About EU Anti-Corruption Initiative
The EU Anti-Corruption Initiative (EUACI) is the comprehensive EU anti-corruption program in Ukraine financed by the EU and Denmark and implemented by the Ministry of Foreign Affairs of Denmark. The program contributes to reducing corruption in Ukraine at the national and local level through the empowerment of citizens, civil society, businesses, and state institutions.
The EUACI began in 2017 and has since established itself as a flagship program. A new 4-year phase was launched in May 2020 with a 22.9 million EURO budget, and the EUACI became an integrated part of the Foreign Ministry of Denmark. The EUACI is playing a pivotal role in ensuring the sustainable institutional development of anti-corruption institutions. Assistance provided to civil society organizations and investigative journalists enhances their capacities and promotes their essential role in anti-corruption efforts. Five cities are selected as Integrity Cities: the EUACI is cooperating with the city mayors and administrations, and civil society to strengthen transparency, accountability, and integrity.
Job posted on
2 September 2021
To apply for this and other jobs on Djinni