Консультант/-ка з розробки PL,SQL

Kindly note that all applications should be submitted through the IOM Global Career Site (Link).

Applications submitted in any other manner will not be considered.

Annex 2 – TERMS OF REFERENCE

FOR THE CONSULTANCY CONTRACT OF: PL/SQL Developer Consultant (IDP dashboard development)

1. Duty Station of the Consultancy: Kyiv, Ukraine
2. Duration of Consultancy: 4 months, with possibility of extension subject to availability funds and satisfactory job performance.
3. Nature of the consultancy: Category A Consultancy

Under the overall supervision the Chief of Mission and the Assessment and Data Coordination Manager, with the direct supervision of the Project Specialist (Evidence-based Governance) of IOM’s Data & Analytics Unit, the Consultant will support the Ministry of Social Policy on secondment from the IOM Ukraine Mission. The consultant will contribute to enhancing the Ministry’s work with the internally displaced persons (IDP) database and other relevant data sources by generating regularly updated dashboards related to displacement and long-term solutions. These dashboards will align with the policy needs of key Ministry departments and support evidence-based programming for the social protection of vulnerable populations.

1. 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.

1. Organizational Department / Unit to which the Consultant is contributing:

Response, Resilience and Recovery, Data and Analytics Unit.

1. Category A Consultants: Tasks to be performed under this contract:
   1. Collection and analysis of dashboards requirements.
   2. Develop data models and ETL processes to transform and load data into PowerBI.
   3. Develop SQL-requests, queries and formulate uploads from DB.
   4. Optimize and maintain existing PowerBI solutions for performance and scalability.
   5. Collaborate with other team members to integrate PowerBI with other systems and applications.
   6. Development of dashboard backend — creation of data sources by combining data from the IDPs database or connection to published data sources.
   7. Visualization of the data using Javascript libraries such as highcharts or d3.js.
   8. Quality checks — functionality tests, data accuracy checks.
   9. Systems performance analysis and minimize the size of data tables.
   10. Technical dashboards creation based on PowerBI repository data.
   11. Document and communicate changes to maintain a standardized approach.
   12. Implement solutions to align calculations, ensuring data integrity and uniform reporting.
   13. Perform such other duties as may be assigned.
2. 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.

1. Education, Experience and/or skills required

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.

Technical 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.

1. Travel required

Not applicable.

1. Competencies

Values

• Inclusion and respect for diversity: respects and promotes individual and cultural differences; encourages diversity and inclusion wherever possible.
• Integrity and transparency: maintains high ethical standards and acts in a manner consistent with organizational principles/rules and standards of conduct.
• Professionalism: demonstrates ability to work in a composed, competent and committed manner and exercises careful judgment in meeting day-to-day challenges.

Core Competencies – behavioural indicators

• Teamwork: develops and promotes effective collaboration within and across units to achieve shared goals and optimize results.
• Delivering results: produces and delivers quality results in a service-oriented and timely manner; is action-oriented and committed to achieving agreed outcomes.
• Managing and sharing knowledge: continuously seeks to learn, share knowledge and innovate.
• Accountability: takes ownership for achieving the Organization’s priorities and assumes responsibility for own action and delegated work.
• Communication: encourages and contributes to clear and open communication; explains complex matters in an informative, inspiring and motivational way.

1. How to apply:

Interested candidates are invited to submit their applications ONLY through this Link (Position number 12089) by  10 November 2024 the latest.  

Only shortlisted candidates will be contacted.  

IOM Careers

The International Organization for Migration (IOM) is the only international inter-governmental agency with a specific mandate for migration and is dedicated to promoting humane and orderly migration.