Jump to content

Senior Data Warehouse Specialist


Recommended Posts

https://wipo.taleo.net/careersection/wp_2/jobdetail.ftl?lang=en&job=18185-FT

 
Senior Data Warehouse Specialist - 18185-FT
PCT Information Systems Division, PCT Services Department, Patents and Technology Sector
Grade - P4
Contract Duration - 1 year *
Duty Station : CH-Geneva
Publication Date : 14-Jun-2018   Application Deadline : 12-Jul-2018, 9:59:00 PM
 

IMPORTANT NOTICE

- The deadline for applications is indicated in local date and time.

- This post is a project post.

 

1.      Organizational Context

 

a.    Organizational Setting

 

This is a project based post located under the Capital Master Plan funded Global IP Platform Program. The program is aimed at introducing a single common IT platform (hereinafter referred to as ‘the Global IP Platform’), which connects the multiple IT platforms supporting the WIPO Global IP systems and the services of the WIPO Arbitration and Mediation Center (AMC).  The Global IP Platform would provide a single entry portal to users of WIPO Global Protection systems services and AMC services via a single WIPO account for each user and implement a user-friendly navigation policy with a common user interface and a central payment portal using a new global payment system.

 

b.    Purpose Statement

 

The main role of the incumbent is to perform the design, development, implementation, and management of an enterprise data warehouse solution for the Global IP Platform.

 

c.    Reporting Lines

 

The incumbent works under the supervision of the Global IP Platform Program Manager, with indirect supervision from the Senior Project Manager.

 

 

2.      Duties and Responsibilities

 

The incumbent will perform the following principal duties:

 

a.   Provide leadership and expertise in implementing an enterprise data warehouse.

 

b.   Define roadmap in design, build and test of an end to end data warehouse platform.

 

c.   Design end to end integration architecture and processes for data warehouses including data migration and data flow from the relevant source systems.

 

d.   Design technical specifications for segmentation and analytics requirements.

 

e.   Identify the necessary security and audit controls, and have a deep understanding of relational and dimensional data modeling as it crosses all areas of the enterprise.

 

f.    Coordinate testing and ongoing release management of the data warehouse system.

 

g.   Provides expertise in digital transformation activities including the adoption of emerging technologies and disciplines such as big data, machine learning, data science and data analytics.

 

h.   Define, implement and assure a secure and performant to-be operations framework for the enterprise data warehouse.

 

i.    Perform other related duties as required.

 

 

3.      Requirements

 

Education

Essential

Advanced university degree in Computer Science, Information Systems or a related field.  A first-level university degree plus two years of relevant experience in addition to the experience requested below may be acceptable in lieu of an advanced university degree.

 

Desirable

Certification in business intelligence and or data warehousing (e.g. CBIP).
Understanding of Agile and or PRINCE2.

 

Experience

Essential

At least seven years of experience in information systems solutions.
At least four years of professional experience in implementing complex data warehouse systems and data architectures with direct business impact, of which at least two years in working on database technology used for business intelligence and/or analytics.
Experience in working on leading RDBMS platforms (PostgreSQL, Oracle, SQL Server etc).
Experience with cloud based data warehouse solutions.

 

Language

Essential

Excellent knowledge of English.

 

Job Related Competencies

Essential

Excellent communication and interpersonal skills; ability to work in a team with both business and technical audiences at different levels and in a multicultural environment with sensitivity and respect for diversity.
Integrity in dealing with confidential and sensitive data.
Excellent analytical and problem-solving skills with demonstrated talent for identifying, scrutinizing, improving, and streamlining complex technology processes.
Excellent time management and work organization skills.

 

 

4.      Organizational Competencies

 

1.     Communicating effectively.

2.     Showing team spirit.

3.     Demonstrating integrity.

4.     Valuing diversity.

5.     Producing results.

6.     Showing service orientation.

7.     Seeing the big picture.

8.     Seeking change and innovation.

9.     Developing yourself and others.

 

5.       Information

 

Mobility:  WIPO staff members are international civil servants subject to the authority of the Director General and may be assigned to any activities, office or duty station of the Organization.  Accordingly, the selected candidate may be required to move from time to time to new functions and/or to another duty station.

 

Annual salary:

Total annual salary consists of a net annual salary (net of taxes and before medical insurance and pension fund deductions) in US dollars and a post adjustment.  The post adjustment (cost of living allowance) is variable and subject to change without notice in accordance with the rates as set within the UN Common System for salaries and allowances.  The figures quoted below are based on the June 2018 rate of 72.4%

 

P4

 

 

Annual salary

      $70,647

 

Post adjustment

      $51,148

 

Total Salary

      $121,795

 

Currency USD

 

 

         

 

Salaries and allowances are paid in Swiss francs at the official rate of exchange of the United Nations.

 

Please refer to WIPO’s Staff Regulation and Rules for detailed information concerning salaries, benefits and allowances.

 

Additional Information

 

* Initial period of one year, renewable, subject to funding and satisfactory performance.  Fixed-term appointments granted for approved projects shall be for a period whose minimum and maximum duration are tied to the funding and terms of reference of the project.  The overall duration of a fixed-term appointment for a project shall normally not exceed five years.  Fixed-term appointments granted for approved projects shall not be converted to a permanent or continuing appointment.

 

Applications from qualified women as well as from qualified nationals of unrepresented Member States of WIPO and underrepresented geographical regions are encouraged. Please click on the following links for the list of unrepresented Member States and the list of underrepresented regions and the WIPO Member States in these regions.

 

The Organization reserves the right to make an appointment at a grade lower than that advertised.

 

___________________________________________________________________

 

By completing an application, candidates understand that any willful misrepresentation made on this web site, or on any other documents submitted to WIPO during the application, may result in disqualification from the recruitment process, or termination of employment with WIPOat a later date, if that employment resulted from such willful misrepresentations.

 

In the event that your candidature is shortlisted, you will be required to provide, in advance, a scanned copy of an identification and of the degree(s)/diploma(s)/certificate(s) required for this position. WIPO only considers higher educational qualifications obtained from an institution accredited/recognized in the World Higher Education Database (WHED), a list updated by the International Association of Universities (IAU) / United Nations Educational, Scientific and Cultural Organization (UNESCO). The list can be accessed through the link: http://www.whed.net/. Some professional certificates may not appear in the WHED and these will be reviewed individually.

 

Additional testing/interviewing may be used as a form of screening.  Initial appointment is subject to satisfactory professional references.

 

Additional background checks may be required.

 

Link to comment
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

Loading...
 Share

×
×
  • Create New...