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 overall supervision of the Senior ICT Officer ( Project Management) and direct supervision of the ICT Officer (Software Development), the successful candidate will have the responsibility for supporting the development and enhancement of dashboards and reports (SQL Server Reporting Services and Microsoft PowerBI), migrate data reports and database queries from legacy to operational databases and generating new reports requested by IOM Headquarters (HQ), field operations and partner organizations. He/She shall also assist in the establishment and management of a data warehouse to become a central data repository and main source for Migrant Assistance, Movement Operations and Medical reporting, publications, operational performance analysis and statistical information dissemination.Under the overall supervision of the Senior ICT Officer ( Project Management) and direct supervision of the ICT Officer (Software Development), the successful candidate will have the responsibility for supporting the development and enhancement of dashboards and reports (SQL Server Reporting Services and Microsoft PowerBI), migrate data reports and database queries from legacy to operational databases and generating new reports requested by IOM Headquarters (HQ), field operations and partner organizations. He/She shall also assist in the establishment and management of a data warehouse to become a central data repository and main source for Migrant Assistance, Movement Operations and Medical reporting, publications, operational performance analysis and statistical information dissemination.
- Create SQL reports to attain high reusability, performance and maintainability.
- Implement the database/ report design of the system provided by the System/ Solution Architect.
- Perform data analysis using BI tools and present data in required formats (e.g. dashboards, graphical or geographical representations, and dimensional data modeling) as per business’ requirement.
- Create SSIS/SSRS packages/reports to meet customer requirements; perform unit and integration tests and resolve any resulting issues/bugs.
- Manage the portfolio of business intelligence assets and subscriptions.
- Communicate project status, issues and risk factors to project team members and project managers.
- Provide maintenance and technical support for existing reports/databases.
- Respond promptly within accepted timeframes to user support and enhancement requests ensuring continued operation of the said reports/ database.
- Review support issues, recommend, and implement long term solutions.
- Provide Tier 3 support.
- Perform other related duties as may be assigned.
- A University degree in Computer Science, Information Technology or a related field from an accredited academic institution, with four years of relevant professional experience in data modelling and SQL programming preferably with documented experience of using system analysis methods and data modelling tools.
-
A professional certification in the relevant field such as Prince2, BRMP certification or Enterprise and Business Architecture will be a distinct advantage.
- Experience in databases, business intelligence, visualization and reporting tools, design, development, implementation and support.
- Extensive experience in use of MS SQL Server, MS Reporting Services:
-
Specifically, SQL 2016 and SQL 2017.
-
Experience in MS Analysis and Integration Services.
-
- Proven capability in Business Intelligence systems (MS SQL Server BI or Oracle Business Objects) and development of data-driven applications and data presentation tools.
- Ability to manipulate data in various file formats, reporting from complex databases, understanding of statistical principals necessary for data analysis; and working with PowerBI and related tools.
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.
- Assigns responsibilities fairly and manages performance, taking account of individual strengths, workloads and interests.
- Is inclusive in decision-making and actively seeks feedback from team members and colleagues in order to identify opportunities for improvement.
- Takes sound and timely managerial decisions that are consistent with the Organization's vision and purpose.
- Establishes and maintains relationships with a broad range of stakeholders to understand needs and gain support.
- Delegates appropriately to make the most of others’ talents, clarifying expectations and allowing autonomy in important areas while providing necessary support.
- Encourages others to take responsibility for their performance; promotes ownership, responsibility and accountability for desired results at all levels.
- Creates an atmosphere of trust and confidence in which others can talk and act without fear of repercussion.
- Gives proper credit to others, shows appreciation and rewards achievement and effort.
- Aligns own actions to the Organization’s vision, values and mandate.
- Translates strategic direction into short and medium-term plans and objectives for own team; revises objectives to reflect changes in organizational goals.
- Identifies key issues/priorities in complex situations and how they may be related to one another.
- Clearly communicates links between the Organization’s strategy and the work unit’s goals.
Interested applicants may send their applications to hrmanila@iom.int no later than 08 January 2023. VN Number and Position Title (VN 037/2022 – ICT Associate (Reporting Analysis)) 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.