Job Description
Position Title: SQL Database and PowerBI Specialist
Reference Code: VN 117/2024
Job classification: G-7
Duty station: Manila (Global) Administrative Centre (MAC)
Type of Appointment: One-year fixed-term with possibility of extension
Salary: Php 1,095,086.00 per annum net of taxes
Context
Under the supervision of the Migration Health Data Analyst and close coordination with the Migration Health Informatics (MHI) Manager and Migration Health Informatics Officer, and as member of the MHI business intelligence, data validation, analysis, and reporting team, the successful candidate is responsible for developing, enhancing and managing migration health databases, reports and dashboards for stakeholders at the headquarters, regional health coordination units, field operations and partner organizations. The successful candidate 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 successful candidate 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.
Required Qualifications and Experience
Education
- University degree in Information Technology, Medical Informatics, Computer Science, Engineering or a related field from an accredited academic institution, with five (5) years of relevant professional experience; or,
- Completed high school degree from an accredited academic institution, with seven (7) years of relevant professional experience;
- Certifications related to database administration and/or reporting is preferable.
Experience:
- Minimum seven years of relevant experience in database, data warehouse and data-driven application architecture design, development and implementation.
- Extensive experience in the use of MS SQL Server, and PowerBI; 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 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.
How to apply
Interested candidates are invited to submit their applications by 21 Nov 2024 at the latest, referring to this advertisement.
In order for an application to be considered valid, IOM only accepts online profiles duly completed. For further information, please refer to: https://www.iom.int/vacancies/vn-117-2024-sql-database-and-powerbi-specialist
IOM welcomes applicants from qualified individuals, irrespective of their race, religion, skin, color, nationality, disability status, ancestry, sexual orientation, gender identity or expression, marital status, family structure, mental health status, or any other characteristic.
Only shortlisted candidates will be contacted.
FEES
IOM does not charge any fees at any stage of its recruitment process (application, interview, processing, training or other fee). IOM does not request any information related to bank accounts.