Status message

Create a new job?

Temporary Appointment of Programmer (SQL and PowerShell), P-2, UNICEF Global Shared Services Centre, Budapest, Hungary

Job
from UN Children's Fund
Closing date: 14 Dec 2018

For 70 years, UNICEF has been working on the ground in 190 countries and territories to promote children's survival, protection and development. The world's largest provider of vaccines for developing countries, UNICEF supports child health and nutrition, good water and sanitation, quality basic education for all boys and girls, and the protection of children from violence, exploitation, and AIDS. For every child, dignity. The UNICEF Global Shared Services Centre (GSSC) in Budapest, Hungary is a global hub to deliver to all UNICEF offices services related to HR Administration (on-boarding, maintenance, off-boarding), Payroll, Finance (invoice and payment processing, bank reconciliation, GL accounting, asset accounting, master data management) and Customer Care IT services. The GSSC is a center of excellence for the global delivery of efficient services with a culture of continuous business improvement, customer service, knowledge sharing and innovation to support the effective achievement of UNICEF’s programme results worldwide. How can you make a difference? UNICEF GSSC will be aggregating data from multiple sources, including SAP, Case Management tool NeoCase (soon to be replaced by ServiceNow) and other structured and unstructured data sources to perform data analysis and conduct detective data review to identify risks, trends and opportunities for process improvement. In addition, a series of tasks are needed to collect, extract, parse, and aggregate data to make available in a data warehouse for processing and consumption. This Temporary Appointment will help automate tasks currently performed manually and assist in the process of feeding the current data warehouse to allow the business teams to create needed reports and to efficiently and effectively monitor and evaluate performance, influence process improvement at field office levels and to support more informed decision-making processes. The selected candidate will bring expert skills in automation, scripting, database management and SQL programming to support the GSSC Customer Care section to provide a structured data source to be used for data analysis, performance measurement, KPI reports generation, identification of improvement areas, and to make strategic decisions. This will involve: •Manipulating and analyzing complex, high-volume, multi-dimensional data sets from different sources and aggregating it in a data warehouse deployed in MS SQL Server 2012•Conducting data clean up exercises•Utilizing Microsoft PowerShell or other tools to automate manual tasks related to the process of data extraction and system integration•Debugging of system failures, system bugs and apply fixes and support end users for continuous data extraction and analysisThe temporary appointee will work with the UNICEF GSSC’s Customer Care section in the activities defined above. The temporary appointee will use MS SQL Server 2012, Report Builder 3.0, MS Power BI, Microsoft PowerShell and other tools to automate current manual tasks related to data manipulation and systems integration. As an advocate for every child, you will have… •Bachelor’s Degree in computer science, information systems, or related discipline•A minimum of 2 years of relevant experience in database design and development, business analysis or software engineering •Strong understanding of data warehouse design concepts, principles and database structures•Working knowledge of automation and programming using Microsoft PowerShell is required. •Self-motivation with ability to work independently in a collaborative team environment, excellent interpersonal skills and a positive attitude•Detail-orientation and ability to ensure highest level of quality/rigor in delivered products, i.e.: dashboards, reports, data analysis, etc.•Fluency in English is required.•Fluency in another UN Language (Russian, Chinese, Arabic, Spanish, French) is desirable.Desirable Assets:•Experience in Microsoft SQL Server, Microsoft Power BI experience and SAP familiarity is a significant advantage.•Experience using REST, ASP, .NET, XML, Java and JavaScript in in automation and programming are assets. For every Child, you demonstrate… Our core values of Commitment, Diversity and Integrity and core competencies in Communication, Working with People and Drive for Results.

View our competency framework at http://www.unicef.org/about/employ/files/UNICEF_Competencies.pdf

International Professional (IP) staff are recruited internationally and serve in duty stations outside their country of nationality. They hold leadership, managerial or specialist functions. Duration This is a Temporary Appointment for a duration of 9 months. The anticipated start date of this Temporary Appointment is January 2018.

UNICEF is committed to diversity and inclusion within its workforce, and encourages all candidates, irrespective of gender, nationality, religious and ethnic backgrounds, including persons living with disabilities, to apply to become a part of the organization.

UNICEF has a zero-tolerance policy on conduct that is incompatible with the aims and objectives of the United Nations, including sexual exploitation and abuse, sexual harassment, abuse of authority and discrimination. UNICEF also adheres to strict child safeguarding principles. All selected candidates will, therefore, undergo rigorous reference and background checks, and will be expected to adhere to these standards and principles.

How to apply:

UNICEF is committed to diversity and inclusion within its workforce, and encourages qualified female and male candidates from all national, religious and ethnic backgrounds, including persons living with disabilities, to apply to become a part of our organization. To apply, click on the following link http://www.unicef.org/about/employ/?job=518397