Project Context and Scope
Overย ten years after the onset of the crisis in eastern Ukraine and following the Russian invasion in February 2022, the country has been embroiled in a full-scale war. The consequences of violence have spread across the entire territory of Ukraine, and over 5 million people are estimated to have been internally displaced. This situation is likely to become protracted as fighting continues and new waves of displacement are expected. In support of the ongoing and future humanitarian response, IOMย is providing support to various government entities in Ukraine at the national, region and local level, including the Ministry of Social Policy.
ย Organizational Department / Unit to which the Consultant is contributing
Response, Resilience and Recovery, Data and Analytics Unit. Tasks to be performed under this contract
- Collection and analysis of dashboards requirements.
- Develop data models and ETL processes to transform and load data into PowerBI.
- Develop SQL-requests, queries and formulate uploads from DB.
- Optimize and maintain existing PowerBI solutions for performance and scalability.
- Collaborate with other team members to integrate PowerBI with other systems and applications.
- Development of dashboard backend โ creation of data sources by combining data from the IDPs database or connection to published data sources.
- Visualization of the data using Javascript libraries such as highcharts or d3.js.
- Quality checks โ functionality tests, data accuracy checks.
- Systems performance analysis and minimize the size of data tables.
- Technical dashboards creation based on PowerBI repository data.
- Document and communicate changes to maintain a standardized approach.
- Implement solutions to align calculations, ensuring data integrity and uniform reporting.
- Perform such other duties as may be assigned. Performance indicators for the evaluation of results
Outcome: 40 hours of work per week,ย monthly reports to IOM fully correspond requested tasks.ย The Ministry is fully satisfied with the consultants' work and confirms that results correspond to the assigned tasks.
Among the output to be delivered, the Consultant will provide biweekly written reports to IOM, outlining their achievements and any challenges they faced during the reporting period.ย
The Consultant will meet with their supervisor from Data & Analytics team at least once per week to discuss progress and will generally keep supervisor informed about significant developments or if any assistance or interventions from IOM may be required.
Outcome 1. Analysis of existing Ministry dashboards and data sources conducted:
- Identified the existing visualization tools and reporting systems used by the Ministry.
- Assessed the relevance and quality of data sources for analytical purposes, such as data on internally displaced persons (IDPs).
- Recommended optimal approaches for integrating these sources into new analytical models.
Outcome 2. Work on preparing the necessary databases for analytical purposes completed:
- Selected and cleaned relevant data to create new databases.
- Verified the accuracy and completeness of the data to ensure its relevance and suitability for use.
- Prepared database structures for quick processing and updating of information.
Outcome 3. Analytical dashboards based on state data on IDPs created:
- Developed dashboard interfaces for visualizing key indicators, such as the number of IDPs, their distribution across regions, demographic data, needs, and assistance.
- Set up regular data updates in the dashboards to meet the Ministry's requirements.
- Ensured the dashboards comply with the Ministry's demands for usability, accuracy, and informativeness. Education
- University degree in Computer or Data Sciences, Statistics, Information and Technology, Geography/Geographic Information System, Communications, or a related field from an accredited academic institution with four years of relevant professional experience. Experience
- 4+ years of experience in developing PowerBI solutions and web-based dashboards and charts or visualizations and maps.
- Proven expertise in data analysis and visualization tools like SQL, Python, R, Excel.
- Strong understanding of API integrations and usage of Javascript visualization libraries such as Highcharts and Highmaps or d3.js.
- Strong understanding of data modeling, ETL processes, and data visualization.
- Proficient in DAX, M, SQL, and other relevant technologies.
- Excellent analytical and problem-solving skills.
- Strong communication and interpersonal skills. Skills
- Excellent written and oral communication and interpersonal skills.
- Extensive knowledge of SQL and experience in PL/SQL development (for Oracle Database 11g, 12c, 19).
- Experience in writing functions, procedures, packages, jobs, and triggers.
- Experience working with APEX 5 and higher.
- Experience with SOAP (and REST) services in PL/SQL (HTML, CSS, XML, VBScript, apex_web_service).
- Experience in implementing data exchange with other services using JSON, XML (generation, parsing).
- Knowledge of IDP issues would be an advantage.
- ะกonfident user of the Microsoft Office Suite. Languages
- Fluency in Ukrainian is essential. Proficiency in English is highly desirable but not essential IOMโs official languages are English, French and Spanish. Proficiency of language(s) required will be specifically evaluated during the selection process, which may include written and/or oral assessments. ย Travel required
- Not applicable. Required Competencies ย IOMโs competency framework can be found atย this link. Competencies will be assessed during the selection process. ย Valuesย - all IOM staff members must abide by and demonstrate these three values:
- Inclusion and respect for diversity: Respects and promotes individual and cultural differences. Encourages diversity and inclusion.