DATA ENGINEERING ASSISTANT

Contract

This is a G-7 contract. This kind of contract is known as General Service and related categories. It is normally only for nationals. It usually requires 7 years of experience, depending on education. More about G-7 contracts.

Org. Setting and Reporting This position is located in the Global Technical Team (GTT) in the Department for General Assembly and Conference Management (DGACM), Vienna. The incumbent reports to the Integration and Data Engineer (P4).

Responsibilities Within delegated authority, Data Engineering Assistants will be responsible for the following duties:

• Responds to requests for data extract, transform and load and prepares design document and decision support for the creation of data pipelines and maintains data catalogue in their area
• Assembles data sets in their area, supports assembly of complex data sets
• Provides input to the design and development of data infrastructure and drafts documentation and formal design documents
• Maintains specific information products in their area and assists more senior staff in providing information products to others
• Provides design and decision support for the creation of data pipelines and maintains data catalogues
• Develops and maintains resources to extract, transform, and load data features from complex datasets for integration in existing systems
• Designs and develops data infrastructure and drafts documentation and formal design documents
• Maintains data governance, protection and security in their area
• Maintains data management tools in their area
• Maintains and administers database infrastructure with a focus on cost and performance optimization, as well as security
• Performs analysis, debugging, and optimization/fine-tuning of database functions, queries, processes, and server operations

• Performs other duties as assigned.

  Competencies •Professionalism: Thoroughly understands data analysis life cycle from ingest and wrangling to analysis and visualization to present findings. Strong experience with best practices and IT operations in an always-up, always-available service. Regularly applies Agile Software Development methodologies. Works with unstructured datasets. Independently supports managing and communicating data warehouse plans to internal clients. Works with big data stores and other technologies that can process massive datasets. Documents their work. Takes pride in the work for the organization and understands the impact that can be brought into the organization by allowing data-driven and evidence-based decisions. Independently plans their work and activities based on a high-level plan. Shows pride in work and in achievements; demonstrates professional competence and mastery of subject matter; is conscientious and efficient in meeting commitments, observing deadlines and achieving results; is motivated by professional rather than personal concerns; shows persistence when faced with difficult problems or challenges; remains calm in stressful situations. Takes responsibility for incorporating gender perspectives and ensuring the equal participation of women and men in all areas of work.

•Communication: Speaks and writes clearly and effectively; listens to others, correctly interprets messages from others and responds appropriately; asks questions to clarify, and exhibits interest in having two-way communication; tailors language, tone, style and format to match audience; demonstrates openness in sharing information and keeping people informed.

•Technological Awareness: Keeps abreast of available technology; understands applicability and limitation of technology to the work of the office; actively seeks to apply technology to appropriate tasks; shows willingness to learn new technology.

Education High school diploma or equivalent. Must have passed the United Nations Global General Service Test (GGST) and the relevant substantive knowledge test for Data Engineering Assistant at Headquarters or an equivalent locally administered test at Offices Away from Headquarters.

Job - Specific Qualification Passing the Global General Service Test (GGST) is required for recruitment consideration in the General Services and related categories in the United Nations Secretariat. Applicants who have not passed the GGST at the time of application may be invited for the test after submitting an application.

The GGST is a proctored entry-level examination at the duty station. Any travel expenses incurred in order to take the examination are the responsibility of the candidate and will not be reimbursed by the Organization.

Having passed the Administrative Support Assessment Test in English at the United Nations headquarters, ECA, ESCA, UNOG, UNOV, ICTR or ICTY may be accepted in lieu of the GGST.

Work Experience A minimum of five years of experience in in data science, data analytics, applied mathematics, information management, software development, database systems or related area is required.

Experience in the following implies daily hands-on use: A minimum of five years of experience in Azure cloud-based infrastructure management is required.

A minimum of five years of experience with MS-SQL database programming language and MS-SQL Server administration is required.

A minimum of five years of experience with MS-SQL server optimization and low-level fine-tuning is required.

A minimum of one year of experience in designing data integration and pipeline architectures which must include ingesting data through different methods such as message queues, database connections, flat files, REST, or specific API’s, is required.

Experience in delivering data use cases using Azure Data Factory is desirable.

Training and practical experience with the PRINCE 2 methodology is desirable.

Languages English and French are the working languages of the United Nations Secretariat. For the post advertised, fluency in oral and written English is required. Knowledge of another official United Nations language is an advantage.

Assessment Evaluation of qualified candidates may include an assessment exercise and/or a competency-based interview.

Special Notice Appointment against this position is for an initial period of one year and renewal therefore subject to the availability of the post or funds, budgetary approval or extension of the mandate.

This position is subject to local recruitment pursuant to staff rule 4.4 of the United Nations Staff Rules. All staff in the General Service and related categories shall be recruited in the country or within commuting distance of each office, irrespective of their nationality and of the length of time they may have been in the country. A staff member subject to local recruitment shall not be eligible for the allowances or benefits exclusively applicable to international recruitment.

At the United Nations, the paramount consideration in the recruitment and employment of staff is the necessity of securing the highest standards of efficiency, competence and integrity, with due regard to geographic diversity.

All employment decisions are made on the basis of qualifications and organizational needs. The United Nations is committed to creating a diverse and inclusive environment of mutual respect.

The United Nations recruits and employs staff regardless of gender identity, sexual orientation, race, religious, cultural and ethnic backgrounds or disabilities. Reasonable accommodation for applicants with disabilities may be provided to support participation in the recruitment process when requested and indicated in the application.

The United Nations Secretariat is committed to achieving 50/50 gender balance and geographical diversity in its staff. Female candidates are strongly encouraged to apply for this position.

Education qualification exceeding the specified requirement of this job opening including university degrees and certificates shall not give rise to additional entitlements or benefits, or facilitate a move to the Professional category. The movement of staff members from the General Service and related categories to the Professional category in the United Nations Secretariat is exclusively allowed through the Young Professionals Programme competitive examinations. Only a few staff members pass the competitive examinations. Passing the competitive examinations does not guarantee movement to the Professional category. For further information, please visit https://careers.un.org/lbw/home.aspx?viewtype=GP

United Nations Considerations According to article 101, paragraph 3, of the Charter of the United Nations, the paramount consideration in the employment of the staff is the necessity of securing the highest standards of efficiency, competence, and integrity. Candidates will not be considered for employment with the United Nations if they have committed violations of international human rights law, violations of international humanitarian law, sexual exploitation, sexual abuse, or sexual harassment, or if there are reasonable grounds to believe that they have been involved in the commission of any of these acts. The term “sexual exploitation” means any actual or attempted abuse of a position of vulnerability, differential power, or trust, for sexual purposes, including, but not limited to, profiting monetarily, socially or politically from the sexual exploitation of another. The term “sexual abuse” means the actual or threatened physical intrusion of a sexual nature, whether by force or under unequal or coercive conditions. The term “sexual harassment” means any unwelcome conduct of a sexual nature that might reasonably be expected or be perceived to cause offence or humiliation, when such conduct interferes with work, is made a condition of employment or creates an intimidating, hostile or offensive work environment, and when the gravity of the conduct warrants the termination of the perpetrator’s working relationship. Candidates who have committed crimes other than minor traffic offences may not be considered for employment.

Due regard will be paid to the importance of recruiting the staff on as wide a geographical basis as possible. The United Nations places no restrictions on the eligibility of men and women to participate in any capacity and under conditions of equality in its principal and subsidiary organs. The United Nations Secretariat is a non-smoking environment.

The paramount consideration in the appointment, transfer, or promotion of staff shall be the necessity of securing the highest standards of efficiency, competence, and integrity. By accepting an offer of appointment, United Nations staff members are subject to the authority of the Secretary-General and assignment by him or her to any activities or offices of the United Nations in accordance with staff regulation 1.2 (c). In this context, all internationally recruited staff members shall be required to move periodically to discharge new functions within or across duty stations under conditions established by the Secretary-General.

Applicants are urged to follow carefully all instructions available in the online recruitment platform, inspira. For more detailed guidance, applicants may refer to the Manual for the Applicant, which can be accessed by clicking on “Manuals” hyper-link on the upper right side of the inspira account-holder homepage.

The evaluation of applicants will be conducted on the basis of the information submitted in the application according to the evaluation criteria of the job opening and the applicable internal legislations of the United Nations including the Charter of the United Nations, resolutions of the General Assembly, the Staff Regulations and Rules, administrative issuances and guidelines. Applicants must provide complete and accurate information pertaining to their personal profile and qualifications according to the instructions provided in inspira to be considered for the current job opening. No amendment, addition, deletion, revision or modification shall be made to applications that have been submitted. Candidates under serious consideration for selection will be subject to reference checks to verify the information provided in the application.

Job openings advertised on the Careers Portal will be removed at 11:59 p.m. (New York time) on the deadline date.

No Fee THE UNITED NATIONS DOES NOT CHARGE A FEE AT ANY STAGE OF THE RECRUITMENT PROCESS (APPLICATION, INTERVIEW MEETING, PROCESSING, OR TRAINING). THE UNITED NATIONS DOES NOT CONCERN ITSELF WITH INFORMATION ON APPLICANTS’ BANK ACCOUNTS.