SQL Database and Power BI Analyst (Teleradiology) VN 155/2023
JOB DETAIL
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 Senior Global radiology coordinator and close coordination with the Teleradiology Data Analyst and international radiologists, and Teleradiology technical team, and as member data validation, analysis, and reporting team, the successful candidate is responsible for developing, enhancing and managing Teleradiology databases, reports and dashboards for 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, being the main source of information for periodic data validation, statistical reporting and publication, operational performance analysis, health profiling and indicators monitoring, and shall play a major role in providing modern data science and business intelligence (BI), data analysis and presentation tools (dashboards) for use by MHD Teleradiology 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 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 data analyst 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 Teleradiology and 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 radiologists and Teleradiology technical team to provide inputs and keep abreast of development in Teleradiology and MHD reporting systems used for Radiology related HAP 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
- 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.
- Demonstrated 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 21 Sep 2023. VN Number and Position Title (VN 155/2023 – SQL Database and Power BI Analyst (Teleradiology)) 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.
