Job Title: Data Integration Process Associate (LOCAL POSITION)
Vacancy code VA/2013/B5004/1765
Position title Data Integration Process Associate (LOCAL POSITION)
Department/office NAO, UNDG
Duty station Entebbe, Uganda
Contract type Fixed Term
Contract level G6
Duration One year
Application period 22-Jan-2013 to 11-Feb-2013
United Nations Core Values: Integrity, Professionalism, Respect for Diversity
Background Information - UNOPS
“UNOPS plays a critical role in providing management services for our life-saving, peacebuilding, humanitarian and development operations. I have seen many examples of how these activities help suffering people in troubled parts of the world.”
-Ban Ki-moon, United Nations Secretary-General
UNOPS mission is to expand the capacity of the UN system and its partners to implement peacebuilding, humanitarian and development operations that matter for people in need.
Working in some of the world’s most challenging environments, UNOPS vision is to always satisfy partners with management services that meet world-class standards of quality, speed and cost effectiveness.
By assisting UN organizations, international financial institutions, governments and other development partners, UNOPS makes significant, tangible contributions to results on the ground.
UNOPS employs more than 6000 personnel and on behalf of its partners creates thousands more work opportunities in local communities. With its headquarters in Copenhagen, Denmark, a network of five regional offices and a further 20 operations and project centres, UNOPS oversees activities in more than 80 countries.
UNOPS is committed to achieving a truly diverse workforce.
Background Information - NAO
North America Regional Office
The UNOPS North America Regional Office provides services that help implement projects for a range of partners, and support operations run by the UNOPS Mine Action Cluster, Small Grants Cluster and Development Group Cluster. In addition, the office serves as a liaison between UNOPS headquarters and its Executive Board, which supports and supervises UNOPS activities globally.
Background Information - Development Group Cluster
Development Group Cluster
The UNOPS Development Group Cluster is based in the North America Office and supports a diverse and complex portfolio including partners such as the United Nations Development Programme (the Bureau for Development Policy, the Human Development Report Office, and the Special Unit for South-South Cooperation), the United Nations Population Fund, the United Nations Capital Development Fund, the United Nations Secretariat and a broadening community of primarily New York-based UN partners in the delivery of project management, implementation and administration services.
Background Information - Job-specific
The United Nations Department of Field Support, Information and Communications Technology Division (UN DFS-ICTD) is responsible for the delivery of applications that satisfy the requirements of the Departments of Peacekeeping Operations and Field Support (DPKO/DFS) missions as well as Special Political Missions (SPMs).
DFS has implemented a range of systems to address the principal requirements of peacekeeping operations and to support and enhance the processes DFS undertakes.
UNOPS has been requested to assist in the implementation of this activity.
Under the supervision of the Data Management Lead in Entebbe and Manager in New York, the Data Integration Process Associate will perform the following:
Ensure an effective data collection and processing system by reviewing and analyzing data input, processing and data output activities, manage incoming data feeds and data transfers
Assist in the design of logical and physical data models and develop data marts using dimensional modeling.
Assist in developing and documenting source to target data element mappings and transformation rules for ETL workflows
Assist in developing Data Integration packages using MS SQL-Server and SSIS.
Assist in developing Release Management/Deployment packages for handover to Operations team
Perform basic SQL Database administration activities in the development environment
Monitor and improve performance with network, security and database indexing considerations.
Liaise and provide database interaction recommendations to BI application developers
Troubleshoot and resolve DW scheduled job failures working closely with ICC.
Perform other data integration and admin related work (as needed)
Professionalism - Strong theoretical background and knowledge of information technology/information management best practice implementation in the field of data integration, cleansing, data warehouse, data modeling, SQL Server related technologies and analysis. Strong analytical and problem solving skills, including familiarity with software development lifecycle and the implementation and support of complex information ICT systems and projects.
Client Orientation: Ability to identify and analyze clients’ needs and develop appropriate technological solutions to the business needs. Experience in working with contracted service providers in a globally dispersed environment.
Planning and Organizing: Ability to organize, plan and implement work assignments, juggle competing demands and work under pressure of frequent and tight deadlines. Ability to lead a project team to completion and provide technical guidance to staff.
Communications: Proven ability to write in a clear and concise manner and to communicate effectively orally. Ability to effectively prepare specifications and other written reports/documentation in a clear and concise style. Ability to communicate with various levels of technical experience (developers/ operations/ end users/ management / support staff). Ability to handle sensitive and confidential information with a level of professionalism and integrity.
Teamwork: Strong interpersonal skills and ability to establish and maintain effective partnerships and working relations in a multi-cultural, multi-ethnic environment with sensitivity and respect for diversity, including gender balance.
High school diploma, Preferably a first level university degree or Certification from IT Institutions
At least 6 years of experience using MS SQL SSIS development in a Data Warehouse environment, supporting databases such as MS SQL Server or a similar RDBMS including at least two years experience of Transact SQL (T-SQL) and a good understanding for improved query performance troubleshooting.
Understanding of concepts in Master Data Management which includes master data schema development,
Experience with data profiling, data quality and data migration processes
Understanding of release and change management.
Excellent diagnostic, debugging, and problem solving skills.
Good understanding of Business Intelligence and Data Warehousing, including dimensional modeling.
Ability to communicate with various levels of technical experience (developers/ operations/ end users/ project managers / business analysts).
Fluent written and oral English required.
Please note that the closing date is midnight Copenhagen time (CET)
Applications received after the closing date will not be considered.
Only those candidates that are short-listed for interviews will be notified.
Qualified female candidates are strongly encouraged to apply.
For staff positions UNOPS reserves the right to appoint a candidate at a lower level than the advertised level of the post
The incumbent is responsible to abide by security policies, administrative instructions, plans and procedures of the UN Security Management System and that of UNOPS.
Contract type, level and duration
Contract type: FIXED TERM (LOCAL POSITION)
Contract level: G6
Contract duration: ONE YEAR
How to Apply:
Deadline: 11th Feb 2013