Assc Business Intelligence Off
Before submitting an application, UNHCR staff members intending to apply to this Job Opening are requested to consult the Recruitment and Assignments Policy (RAP, UNHCR/HCP/2017/2 and the Recruitment and Assignments Administrative Instruction (RAAI), UNHCR/AI/2017/7 OF 15 August 2017.Associate Business Intelligence Officer
The position is part of the Division of Human Resources (DHR), whose mission statement indicates that DHR is a strategic, trusted and innovative partner in enabling UNHCR to protect and respond to persons of concern by attracting, motivating, retaining and developing a talented, diverse and agile workforce, while nurturing a culture of excellence, respect and wellbeing for all.
The Associate Business Intelligence Officer will function under direct supervision of the Snr Business Intelligence Officer, HRSPAS, DHR. The primary objective of this role is to manage the underlying data environment and architecture. The incumbent will be responsible for the scripts required to extract, transform, clean, and move data and metadata so they can be loaded into a data warehouse, data mart, or operational data store. The incumbent will also be responsible for the multidimensional OLAP system based on the DHR data warehouse, and will be closely working with other sections of DHR to identify and understand source data systems, map source system data to data warehouse models. This position will work with the People Analytics team in establishing a data warehouse reporting environment which will provide authorized self-service access to a suite of pre-defined reporting available to staff, both in HR and more widely across the organization.
The incumbent will work closely with Snr. Business Intelligence Officer in the Data team of HRSPAS.
- Ensure the underlying data environment for HR BI team is managed effectively, and be responsible for the entire data warehouse.
- Ensure that the correct data is available in the data warehouse to drive the self-service reporting suite, to enable ad-hoc reporting, and to inform workforce planning activities.
- Oversee the automated daily refresh processes for the data warehouse, addressing any incidents that arise, and improving the refresh process over time.
- Enhance and maintain the multidimensional OLAP system to support self-service and analytical reporting capabilities.
- Perform regular review of the performance and capacity of the reporting infrastructure, and make ongoing improvements where appropriate.
- Liaise with IT with respect to the provision of regular source system data feeds into the BI staging area.
- Act as the primary contact for day-to-day matters between the HR BI team and DIST.
- Provide guidance and assistance to users of the BI data environment as required.
- Communicate physical database design requirements to the DIST database administrator.
- Develop processes for capturing and maintaining metadata for all data warehousing components.
- Implement changes or enhancements in the multidimensional OLAP system as and when necessary.
- Assign incidents and problems to the DIST Service Operations Team when these cannot be resolved at DHR level.
- Undertake any other related tasks as may be required.
ESSENTIAL MINIMUM QUALIFICATIONS AND PROFESSIONAL EXPERIENCE REQUIRED
- University degree in IT related field from a professional institution plus minimum of 3 years relevant experience at professional level with demonstrated ability to manage a similar technology environment. Graduate degree (equivalent of a Master's) plus 2 years or Doctorate degree (equivalent of a PhD) plus 1 year of previous relevant work experience may also be accepted.
- Hands-on use of Microsoft BI products, particularly in ETL (SSIS) and multidimensional OLAP (SSAS), relational database management (SQL Server BI DBA skills), managing the software platform.
- Proficient user of data warehousing and OLAP concepts.
- Strong skills across the Microsoft Office toolset (particularly Excel and Access).
- Proven ability to complete projects and achieve results.
- Excellent knowledge of English (written/oral/comprehension).
DESIRABLE QUALIFICATIONS & COMPETENCIES
- Knowledge of ERP HCM Suites such as PeopleSoft, in particular the data structure and elements contained within databases.
- Work experience in BI tools such as PowerBI, SSRS, Tableau, Qlikview, etc
- Experience working with UNHCR and/or other UN business functions.
- Successful completion of courses related to Microsoft Business Intelligence tools and/or HCM systems.
- Working knowledge of French or other UN languages. C001L2 - Accountability Level 2
C002L2 - Teamwork & Collaboration Level 2
C003L2 - Communication Level 2
C004L2 - Commitment to Continuous Learning Level 2
C005L2 - Client & Result Orientation Level 2
C006L2 - Organizational Awareness Level 2
M003L2 - Judgement and Decision Making Level 2
M006L2 - Managing Resources Level 2
X001L2 - Analytical Thinking Level 2
X002L2 - Innovation and Creativity Level 2
X003L2 - Technological Awareness Level 2 <p>The UNHCR workforce consists of many diverse nationalities, cultures, languages and opinions. UNHCR seeks to sustain and strengthen this diversity to ensure equal opportunities as well as an inclusive working environment for its entire workforce. Applications are encouraged from all qualified candidates without distinction on grounds of race, colour, sex, national origin, age, religion, disability, sexual orientation and gender identity.</p>
See below for this postion's Operational Context
For those people applying for High Risk Duty Stations, we strongly encourage them – before deciding to apply- to read the country specific security and welfare country profiles which can be found on the Intranet under Support Services - Duty of Care (https://intranet.unhcr.org/en/support-services/duty-of-care.html). Ensuring staff are better informed is part of the increased attention UNHCR is paying to Duty of Care.
Staff after having applied to High Risk Duty Stations will have access to country specific information webinars with Field Safety Section (FSS) and Staff Welfare Section (SWS) colleagues and provided with a tool to test their psychological preparedness for serving in High Risk Duty Stations. Applicants who applied for a position in a High Risk country will receive, after the deadline for applications has expired, a joint invitation from the Staff Welfare Section (SWS) and the Field Safety Section (FSS) to participate in these webinars. During the Webinars, latest updates on security and well-being will be provided, and FSS and SWS will address questions raised by participants. Applicants are highly encouraged to benefit, when applicable, from all measures as they provide most up-to-date security and well-being information helpful to assess staff’s readiness to serve in a High Risk Duty Station. A Staff Welfare Officer will also be available, if and when required, to discuss with interested applicants the results of the psychological preparedness tool as well as readiness for assignment in High Risk Duty Stations.
Refer to Job Description, especially under essential minimum requirements. This position is embedded into a new Section being established within the Division of Human Resources in Budapest. The Division¿s mission statement indicates that DHR is a strategic, trusted and innovative business partner in enabling UNHCR to protect and respond to persons of concern by attracting, motivating, retaining and developing a talented, diverse and agile workforce, while nurturing a culture of excellence, respect and wellbeing for all. The incumbent of this position supports the UNHCR¿s People Strategy and contributes to the implementation of the 2018 independent HR review which resulted in the establishment of HR strategic priorities and the reconfiguration and transformation of the Division from a largely transactional model into a strategic business partner for field operations and senior management. Budapest is a HQs duty station in Central Europe It is a HQs duty station and no security concern. Excellent interpersonal, collaboration and communication skills;
Excellent verbal and written communication, organizational and problem solving skills.
Please note that the closing date for vancancies in the Addendum 3 is Thursday 24 January 2019 (midnight Geneva time)