Established in 1951, IOM is a Related Organization of the United Nations, and as the leading UN agency in the field of migration, works closely with governmental, intergovernmental and non-governmental partners. IOM is dedicated to promoting humane and orderly migration for the benefit of all. It does so by providing services and advice to governments and migrants.
IOM is committed to a diverse and inclusive work environment. Internal and external candidates are eligible to apply to this vacancy. For the purpose of the vacancy, internal candidates are considered as first-tier candidates.
Under the supervision of the Migration Health Informatics (MHI) Manager and close coordination with the Migration Health Data Analyst and Migration Health Informatics Officer, and as member of the MHI business intelligence, data validation, analysis, and reporting team, the SQL Database and PowerBI Specialist is responsible for developing, enhancing and managing migration health databases, reports and dashboards for stakeholders -- headquarters, regional health coordination units, field operations and partner organizations. The incumbent shall support the team in implementing the migration health data warehouse, being the main source of information for MHD periodic data validation, statistical reporting and publication, operational performance analysis, health profiling and indicators monitoring. The incumbent shall play a major role in providing modern data science and business intelligence (BI), data analysis and presentation tools (dashboards) for use by MHD global reporting, IOM missions, external partners and public audience.
- Perform extract, transform and load (ETL) procedures mainly using MS SQL and/or MS PowerBI MDX that are required to generate and periodically update the various validation and reporting databases
- Automate and document medical data validation and reporting mechanisms using optimized MS SQL database queries, views and jobs
- Develop MS PowerBI reports and dashboards for use of global, regional, country and other stakeholders to monitor data quality and data validation issues and to report health indicators, measures and statistics
- Ensure that the data pipelines and databases are organized, efficient and reliable
- Closely work with the statistical and data validation assistants in monitoring and management of validation and reporting databases and dashboards
- Participate in tasks related to designing, developing, testing, and implementing a migration health data warehouse, including dimensional data models that address MHD reporting needs
- Perform ETL procedures required to generate and periodically update the MHD data warehouse content
- Support MHI team in use of data science, analysis and business intelligence (BI) tools for the generation of advanced, web-based reports and dashboards aimed at operational performance analysis, secondary health data analysis and population group health profile analysis.
- Generate PowerBI tools and dashboards for different audiences, such as management, medical staff, health assessment programme, external partners and the public in general.
- Optimize and document existing MS Report Server web reports and develop new reports as requested by field operations, regional offices and headquarters.
- Develop and enhance data presentation tools or applications and integrate these tools into MHD reporting or application platforms
- Work closely with MHI Manager, Migration Health Data Analyst, and MHI Officer to provide inputs and keep abreast of development in MHI systems used for HAPs reporting, including Mimosa, UKTB, JIMS, LIMS, iHAP, MedStock and other data sources of health assessment programmes.
- Liaise directly with regional offices, missions and field operations about requests for data and statistical report generation.
- Perform any other related duties as may be assigned.
- University degree in Information Technology, Medical Informatics, Computer Science, Engineering or a related field from an accredited academic institution, with five years of relevant professional experience; or
- Completed high school degree from an accredited academic institution, with seven years of relevant professional experience;
- Certifications related to database administration and/or reporting is preferable.
- Relevant experience in database, data warehouse and data-driven application architecture design, development and implementation;
- Extensive experience in the use of MS SQL Server in writing complex SQL queries and stored procedures involving multiple tables, and creating indexed views to facilitate data manipulation and manage data storage
- Experience in the use of PowerBI, MDX query, and DAX expressions, in designing, implementing data security and managing reports and dashboards for regular data monitoring
- Hands-on knowledge of MS Reporting Services is an asset
- Experience in data management and analysis using Stata, R, Python, Jupyter Notebooks and MS Azure Synapse Analytics an advantage
- Work experience or consulting with government agencies or international health agencies highly desirable and experience as co-investigator for public health or medical research/statistical projects an advantage;
- Proven skills in Business Intelligence systems and tools, such as MS PowerBI and DAX or Excel PowerPivot, and the development of data-driven applications and data presentation tools;
- Manipulation of data in various formats, reporting from complex databases; knowledge and experience on health assessment data and indicators, understanding of statistical principles necessary for data analysis would be an advantage;
- Knowledge of statistical principles, methods and software packages and data analysis preferably with a special focus on health and demographics;
- Good analytical and problem-solving skills, as well as effective communication, documentation and independent writing skills.
For this position, fluency in English is required. Knowledge of a second official UN language is desirable.
- Shows respect and sensitivity towards gender, culture, ethnicity, religion, sexual orientation, political conviction and other differences.
- Encourages the inclusion of all team members and stakeholders while demonstrating the ability to work constructively with people with different backgrounds and orientations.
- Promotes the benefits of diversity; values diverse points of view and demonstrate this in daily work and decision making.
- Challenges prejudice, biases and intolerance in the workplace.
- Upholds and promotes the Standards of Conduct and Unified Staff Regulations and Rules.
- Delivers on commitments; manages the organization’s resources reliably and sustainably.
- Embraces and encourages transparency, balancing this with the need for discretion and confidentiality as appropriate.
- Maintains impartiality and takes prompt action in cases of unprofessional or unethical behaviour.
- Does not abuse one’s position and acts without consideration of personal gain. Is motivated by professional rather than personal concerns.
- Demonstrates professional competence and mastery of subject matter and willingness to improve knowledge and skills.
- Seeks to raise professional standards in self and others through daily work and activities.
- Adapts quickly to change and is decisive and versatile in face of uncertainty.
- Shows self-control and persistence when faced with difficult problems, and remains calm in stressful situations.
- Is conscientious and efficient in meeting commitments, observing deadlines and achieving results.
- Proactively seeks responsibility in delivering towards the goals of the Organization.
- Plans and organizes work with a clear and deliberate focus, ensuring commitments are easily identified and progress is widely communicated.
- Stands by the actions of team or department, publicly accepting ownership.
- Takes responsibility of own shortcomings and those of the work unit, where applicable.
- Speaks and writes clearly and effectively.
- Seeks to share information with others, with due respect for diversity and the confidentiality of specific sensitive information.
- Listens and seeks to understand without bias, and responds appropriately.
- Shares information and keeps others up to date; actively seeks others' views and ideas and respects their contribution.
- Disseminates and shares knowledge openly and actively contributes to knowledge/network communities for topics relevant to area of expertise.
- Encourages knowledge-sharing across units/departments and ensures that knowledge is captured, recorded and disseminated appropriately.
- Builds networks for the effective communication and exchange of knowledge and ideas and puts others into contact with various sources of knowledge.
- Contributes to an environment that is conducive to innovation and learning.
- Fosters a sense of team spirit by developing a shared understanding, accountability and enthusiasm for the team’s work.
- Displays a high level of cultural awareness, sensitivity to different ways of working and leverages individual strengths in order to build a better team.
- Shares credit for team accomplishments and ensures that the contribution of others is recognized.
- Helps create a positive team spirit, putting aside personal considerations to help the team achieve its goals.
- Produces high-quality results and workable solutions that meet clients’ needs.
- Anticipates constraints, identifies solutions and takes responsibility for addressing critical situations.
- Monitors own and others’ work in a systematic and effective way, ensuring required resources and outputs.
- Aligns projects with Organization’s mission and objectives and demonstrates a good understanding of the impact of team’s and own work on external and internal counterparts.
Interested applicants may send their applications to hrmanila@iom.int no later than 02 January 2023. VN Number and Position Title (VN 111/2022 – SQL Database and PowerBI Specialist) should be specified in the SUBJECT field.
IOM welcomes applicants from qualified individuals, irrespective of their race, religion, skin, color, nationality, age, disability status, ancestry, sex, sexual orientation, gender identity or expression, marital status, family structure, mental health status, or any other characteristic.
Only shortlisted candidates will be contacted and an offer will be made following the confirmation of funding.