Education

• 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 data science, data engineering and/or BI is preferable.

Core Functions / Responsibilities:

• Develop  extract, transform and load (ETL) procedures, mainly using MS SQL and/or MS PowerBI MDX/DAX code, required to generate and periodically update reporting datasources.
• Perform ETL processes required to generate and periodically update the MHD data warehouse content.
• Maintain, expand and build effective data models for PBI using Azure Synapse, SQL Server and other data sources.
• Maintain and build Azure Synapse pipelines using T-SQL procedures derived from the ETL procedures and based on defined data dictionaries and lineages, ensure that the data pipelines and databases are organized, efficient and reliable.
• Participate in tasks related to designing, developing, testing, and implementing a migration health data warehouse, including dimensional data models that address MHD reporting needs.
• Develop MS PowerBI reports and dashboards for use of global, regional, country and other stakeholders to monitor data quality and to report health indicators, measures and statistics.
• Closely work with the statistical and data validation assistants in monitoring and management of validation and reporting databases and dashboards.
• 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.
• Play a major role in incorporating Jupyter Notebook or similar data science technologies in the MHD data reporting landscape.
• Generate advanced PowerBI reports and dashboards for different audiences, such as MHD management, medical staff, health assessment programme, external partners and the public in general.
• 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.
• Perform any other related duties as may be assigned.

https://spain.iom.int/es/vacantes

Experience

• Relevant experience in database, data warehouse and data-driven application architecture design, development and implementation;
• Proven experience in dimensional data modelling, including the design of star schemas and the underlying source data fact and dimension tables;
• 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;
• Experience in data ingestion, and the creation and handling of data pipelines is required;
• Experience in data science and analysis using R, Python and Jupyter Notebooks is preferred;
• Background in health information management and/or processing or analysis is of 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.

Skills

• 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;
• Proficiency in T-SQL and building of pipelines using Azure Synapse Analytics;
• Manipulation of data in various formats, reporting from complex databases; knowledge and experience on health ca4e 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