SQL Database and Power BI Analyst (Teleradiology) At International Organization for Migration

Job Description

Position Title: SQL Database and Power BI Analyst (Teleradiology)

Job classification: Ungraded

Duty station: Manila (Global) Administrative Centre (MAC)

Type of Appointment: Six months with possibility of extension

Salary: Php 58,000 per month net of taxes (All-inclusive Salary)

Context

Under the supervision of the Sr. Global Radiology Coordinator, in close coordination with the Teleradiology Data Analyst, international radiologists and Teleradiology technical team, and as member of the data validation, analysis, and reporting team; the successful candidate is responsible for developing, enhancing and managing Teleradiology databases, reports and dashboards for the headquarters, regional health coordination units, field operations and partner organizations, as well as support the team in implementing the migration health data warehouse for radiology data, statistical reporting and publication.

Core Functions / Responsibilities

• 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 radiology 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 radiology indicators, measures, and statistics.
• Ensure that the data pipelines and databases are organized, efficient and reliable.
• Closely work with the statistical and data reporting 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 for radiology service, including dimensional data models that address Migration health reporting (MHD) reporting needs.
• Perform ETL procedures required to generate and periodically update the MHD data warehouse content.
• Support Teleradiology 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 Sr Global Radiology coordinator, Teleradiology Data Analyst, and International radioligsts and Teleradiology technical team to provide inputs and keep abreast of development in Teleradiology and MHD reporting systems used for Radiology reporting, including Teleradiology primary and QC applications, Mimosa, UKTB, JIMS, and other radiology related data sources of health assessment programmes.
• Liaise directly with regional offices, missions and field operations about requests for data and statistical report generation.
• Any other related duties as may be assigned.

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

Experience:

• Demonstrated 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.