Jobs at:
UNOPS
Vacancy title:
Data Integration Process Specialist
Deadline of this Job:
7th Feb 2013
Job details:
Vacancy code VA/2013/B5004/1735
Position title Data Integration Process Specialist
Level ICS-10
Department/office NAO, UNDG
Duty station Entebbe, Uganda
Contract type Fixed Term
Contract level NOC
Duration One year
Application period 17-Jan-2013 to 07-Feb-2013
Print
United Nations Core Values: Integrity, Professionalism, Respect for Diversity
Apply Now
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-GeneralVacancy code VA/2013/B5004/1735
Position title Data Integration Process Specialist
Level ICS-10
Department/office NAO, UNDG
Duty station Entebbe, Uganda
Contract type Fixed Term
Contract level NOC
Duration One year
Application period 17-Jan-2013 to 07-Feb-2013
Print
United Nations Core Values: Integrity, Professionalism, Respect for Diversity
Apply Now
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 - DFS
The United Nations Department of Field Support, Information andCommunications
Technology Division (UN DFS-ICTD) is responsible for thedelivery of applications
that satisfy the requirements of the Departments ofPeacekeeping Operations and
Field Support (DPKO/DFS) missions as well asSpecial Political Missions (SPMs).
DFS has implemented a range of systems to address the principalrequirements of
peacekeeping operations and to support and enhance theprocesses DFS
undertakes.
UNOPS has been requested to assist in the implementation of this activity.
Functional Responsibilities
Under the supervision of the Data Management Lead in Entebbe,the Data
Integration Process Specialist will perform the following:
Write queries; develop stored procedures andETL packages for various
dashboard and transactional applications.
Monitor and troubleshoot the data processeson a daily basis in DPKO DW and
ODS
Maintain and improve performance,reliability and monitoring of all Data
Warehouse systems; applications includeMS SQL DTS, SSIS, Lotus Notes
Replication, SQL Replication, Changed DataCapture (CDC) and other 3rd Party
vendor applications.
Monitor automated system alerts, log files,and other Data Warehouse
monitoring tools.
Troubleshoot and resolve DW scheduled jobfailures, striving to meet
established SLA's.
Research problem tickets to resolve data,setup, code issues;
Provide detailed report of nightlyactivities, as well as communicate timely
updates when there are issues withthe Data Warehouse;
Interact with Tier I support, other Supportteams, as well as Development,
Integration groups.
Work on projects to better improve DataIntegration in DW environment.
Perform other data integration and admin related work (as needed)
Competencies
Professionalism - Strong theoretical background and knowledge of information
technology/information management best practice implementation in the field of
reporting and business intelligence and data integration. Strong analytical,
problem solving, writing and negotiation 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.
Education/Experience/Language requirements
Education:
Advanced University degree (Master’s degree or equivalent) in social sciences,
information technology, computer sciences or in field related to the post
description. A first level university degree with a combination of relevant academic
qualifications and extensive experience in information systems may be accepted in
lieu of an advance university degree.
Experience:
At least 5 years experience in a Tier II/III MS SQL DTS/SSIS Support and
development role and supporting large databases such as MS SQL Server or a
similar RDBMS.
Over 2 years experience of Transact SQL (T-SQL) and a good understanding
for improved query performance troubleshooting.
Excellent diagnostic, debugging, and problem solving skills.
Understanding of .Net, WAN, LAN, servers, networks, security models.
Experience with Business Intelligence and Data Warehousing, including
dimensional modeling.
Must have advanced understanding of XML, XSLT.
Ability to communicate with various levels of technical experience (developers/
operations/ end users/ project managers / business analysts).
Working knowledge and experience on Master Data Management project which
includes master data schema development, access business rules, master data
design, data profiling and data quality processes, data migration processes, MDM
Hub architecture.
Experience in release and change management is highly desirable.
Language: Fluency in English required.
Additional Considerations
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: FTA
Contract level: NOC
Contract duration: One year
Job application procedure
https://gprs.unops.org/Pages/ViewVacancy/VADetails.aspx?id=1735
Similar Jobs at Great Uganda Jobs
All jobs in Uganda advertised in January 2013
Latest Jobs
