Project details

Overview

Project title

Higher Education Reform Project - 19/12 IT engineer and Data Warehouse Developer

Country Programme / Action Plan
Tender / Procurement notice
13 Aug 2019

Published

13 August 2019

Deadline

19 August 2019

Budget

22 000 USD


Procurement type


Individual consultants

Reference

43007-023 Package 19/12 IT engineer and Data Warehouse Developer

Funding Agency

ADB - Asian Development Bank


Estimated duration

10 months


Countries

Mongolia

Date Published: 13-Aug-2019 Deadline of Submitting EOI: 19-Aug-2019 11:59 PM Manila local time

Selection Profile

Consultant Type Individual
Selection Method Individual Consultants Selection (ICS)

Source National
Technical Proposal Not Applicable

Selection Title Higher Education Reform Project

Package Number 19/12
Package Name IT engineer and Data Warehouse Developer

Advance Action No
Engagement Period 10 MONTH
Consulting Services Budget USD 22,000
Budget Type Estimated

Approval Number 2766
Approval Date 28-Jul-2011
Estimated Short-listing Date 20-Aug-2019
Estimated Commencement Date 30-Aug-2019
Open to non-Member Countries No

Additional Information

Possibility of contract extension Not known
Possibility of consideration for downstream assignment Not known
Indefinite Delivery Contract (IDC) No
Country of assignment Mongolia
Country of eligibility for national consultants Same as country of assignment

Contact Information

Project Officer Jijgee Jagar
Designation Procurement Specialist
Email jijgee.herp@gmail.com

Agencies

Primary Agency Country Agency Role Contact Person Ministry of Education, Culture, Science & Sports Mongolia Executing Agency

Cost Estimate

Cost Items Amount in USD
Remuneration and Other Expenses
All activities and inputs in the TOR but not limited to remuneration, per diem, air travel, miscellaneous travel expenses, report preparation, production, and transmission, land transportation, communications, etc. 22,000

TOTAL 22,000

Terms of Reference

Expertise Higher Education Management System
Expertise Group Information Systems
TOR Keywords DWHAA

Source National
Objective and Purpose of the Assignment

The MECSS aims to develop and deploy Higher Education Management Information System (HEMIS) based on the needs on higher education sector. The HEMIS shall support the MECSS in policy planning and
implementation, decision making, monitoring and evaluation of the higher education system performance.
The HEMIS facilitates the collection, aggregation, acquisition, processing, storage and analysis and
supports the dissemination of data on education system in order that educational planners,
administrators and managers can have reliable and timely data and information. Workload at every level
and data duplication shall be reduced and eliminated using the HEMIS. Evidence-based policy making,
efficient facts/data use, fair and transparent budget allocation shall be made possible through the use
of HEMIS.

6 individual consultants as a team were recruited by the MECSS to develop and deploy the following 9
subsystems of the HEMIS: (i) Foundation Frameworks, (ii) Academic Foundation, (iii) Student Recruiting
and Admissions, (iv) Curriculum Management, (v) Student Administration, (vi) Academic Advising, (vii)
Financial Aid, (viii) Student Financials, and (ix) Consolidation and reports. The consultancy services
commenced from 02 January 2018 and have completed on 26 June 2019. The MECSS has accepted the 9
subsystems on 26 June 2019.

Based on the successful development and implementation of the 9 subsystems of the HEMIS, the MECSS has
decided to implement the second phase of the HEMIS. The second phase is the continuation of the previous
work The MECSS intends to recruit 12 individual consultants: (i) Team leader/Architect, (ii) System
Analyst; (iii) Business Analyst, (iv) Enterprise Analyst, (v) Data Analyst, (vi) System Implementer and
Tester, (vii) Process Analyst, (viii) Base System and Security Developer, (ix) Backend Developer, (x)
Full Stack Developer, (xi) API Developer, and (xii) IT Engineer and Data Warehouse Developer. The
objective of the assignment is to assist MECSS in development and implementation of 21 subsystems of
Data Warehouse and Analytical Applications (DWAA) of the HEMIS. Maintenance and administration of the
entire system will also be undertaken.

HEMIS Data Warehouse and Analytic Applications will comprise following subsystems:
1. HEMIS Datawarehouse Frameworks: Metadata repository, Data sourcing and mapping, ETL(Data extract, staging, transform, load), Business intelligence tool, and DW Foundation frameworks is the mid system
which will be used among all Data warehouse and analytic applications;
2. License Datawarehouse and Analytic application;
3. Institution Datawarehouse and Analytic application;
4. Curriculum Datawarehouse and Analytic application;
5. Academic program, plan Datawarehouse and Analytic application;
6. Student Admission Datawarehouse and Analytic application;
7. Student Record Datawarehouse and Analytic application;
8. Grading Datawarehouse and Analytic application;
9. Graduation and progression Datawarehouse and Analytic application;
10. Academic Project Datawarehouse and Analytic application;
11. Research Tracking Datawarehouse and Analytic application;
12. Alumni Datawarehouse and Analytic application;
13. Financial Aid Datawarehouse and Analytic application;
14. Student Financials Datawarehouse and Analytic application;
15. Facility and Building Datawarehouse and Analytic application;
16. External Education Datawarehouse and Analytic application;
17. Employee Datawarehouse and Analytic application;
18. Committee Datawarehouse and Analytic application;
19. Statistical and analytical reports, dashboards, indicators distribution portal;

Scope of Work

The IT Engineer/Data Warehouse Developer will be responsible for overall coordination of the development
and implementation of the DWAA for HEMIS, including planning, developing, testing, deployment,
monitoring and evaluation. The role would involve the architectural design, development, and deployment
of the overall systems, and defining of the system solutions of each component based on user/client
needs, cost, and required integration with existing applications, systems, or platforms.

The main duties and responsibilities of the IT engineer/Data Warehouse developer will include the
following tasks but required to perform any other tasks in the areas of responsibilities, as deemed
necessary. The consultant will perform the assigned tasks under the direct supervision of Yu.Altantuya,
Officer in charge Education Statistics Information, Registration and Analysis of Public Administration
Department; and guidance of Director of Higher Education Policy Department, and work in close
collaboration with the MECSS Officials and the PIU.

Detailed Tasks and/or Expected Output

The team as a whole will:
• Produce a system development plan, including deliverables, milestones, schedules and significant staff
assignments;
• Conduct a consultation workshop with MECSS and related higher education agencies;
• Determine a comprehensive specification of business processes and functional requirements;
• Define technical specifications for the selected subsystem, modules design inheriting general
technical specifications of the DWAA;
• Develop and implement subsystems and modules of the DWAA;
• Test/pilot the system;
• Train end users; and
• Prepare and submit timely reports for review and approval by the respective parties

Detailed tasks as an IT Engineer:
- Evaluate the progress, monitor and manage risks of activities;
- Produce technical specifications or requirements;
- Verify stability, interoperability, portability, security, or scalability of systems architecture;
- Collaborate with the developers to select appropriate design solutions or ensure the compatibility of
system components;
- Provide technical guidance or support for the development or troubleshooting of systems;
- Evaluate current or emerging technologies to consider factors such as cost, portability,
compatibility, or usability;
- Identify system data, hardware, or software components required to meet user needs;
- Develop engineering calculations, diagrams and technical reports;
- Installing and configuring computer hardware, software, systems;
- Monitoring and maintaining HEMIS platform and networks;
- Maintain security, backup, and redundancy strategies;
- Prioritize and manage many open cases at one time;
- Respond in a timely manner to service issues and requests;
- Diagnose and troubleshoot technical issues, including account setup and network configuration;
- Repair and replace equipment as necessary;
- Evaluate the progress, monitor and manage risks of activities;
- Participate in preparation of user manuals and conduct trainings;
- Report progress of work to the Team Leader;
- Prepare a final subsystems development report, and submit to the Team leader for review and approval
of MECSS
Detailed tasks as a Warehouse Developer:
- Work with Data Analyst, System Analyst and Business Analysts to obtain the needed specifications to
build processes needed to move data from its origin to its ultimate destination, including the necessary
balancing controls to ensure data integrity for both new and maintenance efforts;
- Assist in the collaboration between analysts, developers, system owners in the testing of new and
changed data elements and services;
- Develop ETL to ingest and transform data from upstream databases and APIs into a data warehouse. The
tools used include Oracle Golden Gate, AWS Redshift, Kafka, and custom ETL;
- Data modeling, including designing and expanding slowly changing dimension and fact tables;
- Utilize PL-SQL to create complex functions, stored procedures, indexes and triggers;
- Contribute to architectural database design and code reviews with development team;
- Perform schema design, performance tuning, capacity planning, and change control management tasks;
- Design, implement and manage jobs for backup, re-indexing, database optimization and related tasks;
- Troubleshoot and resolve performance issues at the database, application and system levels;
- Support security of database systems and maintain confidentiality;
- Develop upgrade scripts for consistent deployment across all environments;
- Develop a modern data warehouse for reporting and analytics;
- Suggest and implement improvements to the database systems and processes;
- Document the structure, processes and design of all the solutions being implemented;
- Design and build Data Pipelines to collect, transform, store, analyze, explore and visualize;
- Work with the development team to understand data sources, use cases, and data models;
- Choose the right technology stack to align with the use of cases and scalability;
- Develop an alert & monitoring system and procedures for faster disaster recovery; and
- Provide technical directions and mentor other engineers and developers.

Minimum Qualification Requirements

General qualifications:
- Minimum bachelor’s degree in information technology, and other relevant discipline;
Project related experience:
- At least 5 years’ experience in maintaining data center;
- Minimum 5 years’ experience in setting up and maintaining infrastructure and platform of large-scale,
enterprise grade information management systems;
- Knowledge and experience in server, storage, network equipment, operating system, virtual machine,
Java virtual machine, Oracle database, fusion middleware, and cloud control;
- Experience working with middleware servers Oracle Weblogic, Business intelligence, HTTP, Identity
Directory Management, SOA, Service Bus, Identity and Access Management;
- Experience creating Oracle SOA composites is a plus;
- Experience working with operating system such as Linux and Windows server;
- Experience in writing complex and efficient PLSQL statements on Oracle Database and Data Warehouse;
- Knowledge of database design methodologies such as database best practices, data modeling, debugging complex queries and performance tuning;

Other experience and skills:
- Efficient multi-tasking abilities and skilled in completing time bound jobs;
- Excellent communication, interpersonal and team work skills; and
- Strong oral and written Mongolian and adequate English language skills;

Minimum General Experience 5 Years
Minimum Specific Experience (relevant to assignment) 5 Years
Regional/Country Experience Required

Schedule and Places of Assignment (chronological and inclusive of travel)

Schedule Type Continuous
Max. Working Days/Week Home Office 6 Field 5

City and Country Working Days Estimated Start Date Estimated End Date
Ulan Bator, Mongolia 220 30-Aug-2019 14-Jun-2020

Total 220