Associate Programme Specialist (Data Manager /Architect)

Contract

This is a P-2 contract. This kind of contract is known as Professional and Director staff. It is normally internationally recruited only. It's a staff contract. It usually requires 2 years of experience, depending on education.

Salary

The salary for this job should be between 87,818 USD and 119,278 USD.

Please keep in mind that the salary displayed here is an estimation by UN Talent based on the location and the type of contract. It may vary depending on the organization. The recruiter should be able to inform you about the exact salary range. In case the job description contains another salary information, please refer to this one.

**OVERVIEW** ------------ Post Number : 1CAUIS0026PA Grade : P-2 Parent Sector : UNESCO Institute for Statistics (UIS) Duty Station: Montreal Job Family: Computer Sciences / Information Technologies Type of contract : Project Appointment Duration of contract : 2 years Recruitment open to : Internal and external candidates Application Deadline (Midnight Paris Time) : 26-MAY-2023 UNESCO Core Values: Commitment to the Organization, Integrity, Respect for Diversity, Professionalism ***Duration of contract: 2 years with possibility of extension subject to availability of funds and satisfactory performance.*** **OVERVIEW OF THE FUNCTIONS OF THE POST** ----------------------------------------- **Background** The UNESCO Institute for Statistics (UIS) is a statistical agency that produces cross-nationally comparable data for education, science, culture, and communication and information. Established in 1999, the UIS provides statistical and technical inputs for global, regional and development agendas, including the UN Transforming Education Summit, the Global Education Cooperation Mechanism, G7, and G20. The UIS maintains the most comprehensive education statistics database in the world, which is used for various purposes, including for monitoring the Sustainable Development Goals (SDGs). The UIS aims to serve the needs of Member States by providing sound statistical information that informs policies and decision-making, benchmarks progress towards national and international goals, and promotes learning from the experience of others. The UIS is focused on improving the analysis and dissemination of data, expanding user-focused access to value-added products, and providing access to broader, real-time and emerging data, particularly for emergency responses. The UIS IT and Data Production Services team supports the successful implementation of this vision through technology, tools, and processes that enable stakeholders to make the best use of the data produced by UIS. **Purpose** Under the overall authority of the UIS Director and direct supervision of the Head of Information Technology Services and Data Production Services , the Data Manager / Architect will be responsible for the design, development, implementation, and maintenance of the key UIS databases and data structures, in addition to facilitating various data release activities. S/he will also be involved with the coaching of internal data users, in addition to contributing his/her expertise to the UIS overall data and database strategy. Long Description ---------------- Specifically, the incumbent will be responsible for the following 1. Act as the primary resource for: 1. Data Architecture and Maintenance 1. Research, propose and implement data centered infrastructure and solutions for current and future information products. (e.g., visualizations, API’s, web applications, bulk data export facilities, etc.) 2. Design, develop, test and deploy data structures and SQL code to support UIS programme team data requirements. 2. Data Release – Production Support 1. Support the data production of programme teams 2. Produce data products required by UIS tools and stakeholders such as the UIS data browser and Bulk Data Download files. 3. Integrate alternate data sources into the production UIS databases. 3. Database Administrator 1. Managing, monitoring and maintaining company databases 2. Making requested changes, updates and modifications to database structures and data 3. Ensuring database security, integrity, stability and system availability 4. Maintaining database backup and recovery infrastructure. Long Description ---------------- 2\. Perform coaching duties to internal UIS data users so they can effectively and efficiently make use of UIS data. 3\. Contribute to the UIS’s digital strategy to increase the visibility and usage of UIS data and information products among its user target segments. **COMPETENCIES (Core / Managerial)** ------------------------------------ Communication (C) Accountability (C) Innovation (C) Knowledge sharing and continuous improvement (C) Planning and organizing (C) Results focus (C) Teamwork (C) Professionalism (C) **-** ----- For detailed information, please consult the [UNESCO Competency Framework](https://en.unesco.org/sites/default/files/competency_framework_e.pdf). **REQUIRED QUALIFICATIONS** --------------------------- ***Education*** - Advanced university degree (Master’s degree or equivalent) in computer science, statistics, applied mathematics, data management, information systems, information science or a related quantitative field. A first-level university degree in combination with two additional years of qualifying experience may be accepted in lieu of the advanced university degree. ***Work Experience*** - Minimum of two years of experience in data management, integration, modelling, optimization and other relevant areas. - Minimum 2 years of experience in database administration. - Experience in programming languages such as Python or R. - Experience with database programming languages (SQL, etc.). - 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. - Experience in DevOps tool chains consisting of tools like Git, Jenkins or Bamboo – or equivalent tools - and experience with the deployment of data pipelines. - Experience supporting cross-functional teams and collaborating with stakeholders in support of analytics initiatives. Long Description ---------------- ***Skills and Competencies*** - Advanced data modelling skills, including data architecture and design. - Ability to manage large and complex data sets. - Ability to design and implement data security measures. - Proficiency in database design, implementation, and optimization. - Knowledge of big data technologies such as Hadoop, Spark, and NoSQL databases. - Experience with data governance and master data management. - Strong understanding of business requirements and ability to translate them into technical solutions. - Strong data analysis and visualization skills. - Strong analytical and problem-solving skills. ***Languages*** - Excellent knowledge (spoken and written) of English. **DESIRABLE QUALIFICATIONS** ---------------------------- ***Education*** - Relevant certifications such as Certified Data Management Professional (CDMP), AWS Certified Big Data - Specialty, or Microsoft Certified: Azure Data Engineer Associate is desirable ***Work Experience*** - Experience in delivering big data use cases is desirable, including projects using technology such as Apache Spark, Hadoop or others. - Experience in Artificial Intelligence, particularly Machine Learning techniques for data mining and extraction of large amounts of data is desirable. In this context, familiarity with concepts of bias and fairness (i.e., how to identify, assess, and minimize harmful biases, discrimination, and unfair outcomes in algorithmic systems and data) is particularly desirable. - Experience working with self-service analytics applications like Microsoft PowerBI, Tableau, Qlik and others for data discovery. - Experience working in team environments that utilize an Agile methodology. - Experience working with the C# programming language. ***Languages*** - Working knowledge of French. - Knowledge of another UNESCO official language (Arabic, Chinese, Russian or Spanish). **BENEFITS AND ENTITLEMENTS** ----------------------------- UNESCO’s salaries consist of a basic salary and other benefits which may include if applicable: 30 days annual leave, family allowance, medical insurance, pension plan etc. The approximate annual starting salary for this post is 65,895 US $. For full information on benefits and entitlements, please consult our [Guide to Staff Benefits.](https://en.unesco.org/sites/default/files/unesco-staff-compensation-booklet_en.pdf) **SELECTION AND RECRUITMENT PROCESS** ------------------------------------- Please note that all candidates must complete an on-line application and provide complete and accurate information. To apply, please visit the [ UNESCO careers website.](https://careers.unesco.org/careersection/2/joblist.ftl) No modifications can be made to the application submitted. The evaluation of candidates is based on the criteria in the vacancy notice, and may include tests and/or assessments, as well as a competency-based interview. UNESCO uses communication technologies such as video or teleconference, e-mail correspondence, etc. for the assessment and evaluation of candidates. Please note that only selected candidates will be further contacted and candidates in the final selection step will be subject to reference checks based on the information provided. **Footer** ---------- *UNESCO recalls that paramount consideration in the appointment of staff members shall be the necessity of securing the highest standards of efficiency, technical competence and integrity. UNESCO applies a zero-tolerance policy against all forms of harassment. UNESCO is committed to achieving and sustaining equitable and diverse geographical distribution, as well as gender parity among its staff members in all categories and at all grades. Furthermore, UNESCO is committed to achieving workforce diversity in terms of gender, nationality and culture. Candidates from non- and under-represented Member States ([last update here](https://en.unesco.org/careers/geographicaldistribution)) are particularly welcome and strongly encouraged to apply. Individuals from minority groups and indigenous groups and persons with disabilities are equally encouraged to apply. All applications will be treated with the highest level of confidentiality. Worldwide mobility is required for staff members appointed to international posts.* *UNESCO does not charge a fee at any stage of the recruitment process.*