PL/SQL Developer Consultant (IDP dashboard development)
Kyiv, Ukraine
JOB DETAIL
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.
- 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.
- Courage: Demonstrates willingness to take a stand on issues of importance.
- Empathy: Shows compassion for others, makes people feel safe, respected and fairly treated.
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 actions and delegated work.
- Communication: Encourages and contributes to clear and open communication. Explains complex matters in an informative, inspiring and motivational way.
Notes
- Any offer made to the candidate in relation to this vacancy notice is subject to funding confirmation.
- Appointment will be subject to certification that the candidate is medically fit for appointment, verification of residency, visa, and authorizations by the concerned Government, where applicable. Vaccination against COVID-19 will be required for IOM personnel who are hired or otherwise engaged by IOM. As part of the mandatory medical entry on duty clearance, candidates may be requested to provide evidence of full vaccination. Consultants engaged to work on a home-based consultancy who do not need to travel do not need to provide vaccination records, regardless of the length of the consultancy contract.
- IOM covers Consultants against occupational accidents and illnesses under the Compensation Plan (CP), free of charge, for the duration of the consultancy. IOM does not provide evacuation or medical insurance for reasons related to non-occupational accidents and illnesses. Consultants are responsible for their own medical insurance for non-occupational accident or illness and will be required to provide written proof of such coverage before commencing work.
- IOM does not charge a fee at any stage of its recruitment process (application, interview, processing, training or other fee). IOM does not request any information related to bank accounts.
- IOM only accepts duly completed applications submitted through the IOM online recruitment system. The online tool also allows candidates to track the status of their application.
For further information and other job postings, you are welcome to visit our website: IOM Careers and Job Vacancies
location
JOBS YOU WILL LOVE
