Million Experts
HomeAboutServicesExpertsJobsOrganizationsBlogsContact

Million Experts logo

links

Home
Jobs
Experts
Organization

help

About Us
Contact Us
Services
Blogs
Copyright © 2025millionexperts.com
Privacy Policy
Home
/
Jobs
/
Data Migration Specialist

Data Migration Specialist

Job announcement

57

Post Date :

March 16 2025

Deadline :

March 20 2025

Reference Number :

job.mi

Vacancies :

1 vacancies

Minimun Experience :

5 Year(s)

Minimun Education :

Bachelors

Age :

18 - 55

Gender :

Not specified

Job shift :

Full-time

Job type :

On-site

Job level :

Senior

Salary :

As per organization salary scale

Location :

Micronesia

Sectors :

Computer Science

Business Administration

Business Analysis

Data analysis

Data Engineer

Data Analytics

About Job announcement

Job announcement channel

Description

Job Summary

Attachment: Terms of Reference (TOR)

Federated States of Micronesia

Project for Strengthening Public Financial Management (P161969)

Terms of Reference – Data Migration Specialist
FM-DOFA-480081-CS-INDV

LOCATION: Department of Finance & Administration – Treasury Division

DURATION: Contract duration of three (3) months

  1. Background:

The National Government of the Federated States of Micronesia (FSM) have partnered with the World Bank (WB) to implement development activities within the FSM. The current and pipeline portfolio includes projects in the sectors of Energy, Fisheries, Information & Communication Technology, Maritime Transport and strengthening Public Financial Management (PFM).

The objective of the project for Strengthening Public Financial Management Project is to improve the completeness, reliability and timeliness of financial reports of the National and four State Governments of FSM (Chuuk, Kosrae, Pohnpei, and Yap). The project is implemented through the Department of Finance & Administration (DoFA).

The project has five components:

  1. Strengthening the public financial management environment

  2. Financial Management Information System (FMIS)

  3. Revenue Management System (RMS)

  4. Change management and human resource development

  5. Project management

Component 2 of the project funds the supply and installation of a commercial-off-the-shelf (COTS) financial management information system (FMIS) to enhance FSM Governments´ revenue and expenditure management, and reporting capabilities. The current system used by each of the respective governments is Fundware, written in code (e.g., COBOL) dating back to the 1960’s. As part of the conversion to the new system, data and records in the Fundware system need to be reviewed and then migrated to the new system, FreeBalance. FreeBalance will provide the format for the data to be imported and the responsibilities of the Data Migration Adviser will be to extract the data from Fundware and provide it to FreeBalance in the format required.

  1. PURPOSE AND OBJECTIVE OF THE ROLE

The purpose of this role is to support DoFA and the State governments in extracting data from the legacy system (Fundware) to extract and prepare the cleansed data to populate the new FMIS.

  1. SCOPE OF SERVICES

The Data Migration Specialist will work in close coordination with the Treasury Advisor and under the policy direction of the Assistant Secretary Treasury. A mapping table has been completed for the conversion of data and will be run against any data that includes account codes before it is provided to FreeBalance.

The FMIS team have identified the current data locations. There are Microsoft Access databases setup for each entity’s export that includes an ODBC link to the COBOL tables. Fundware also includes tools to extract that data to SQL server and a limited amount of the data (mainly receivables) is available natively in SQL Server. Where the ODBC link does not provide all of the information required then reports will need to be run in Fundware, and the information extracted from there. Fundware reports can be exported as text files which will then need to be manipulated to extract the data required.

The tasks to be completed for the National Government and each of the 4 States includes the following:

  • Coordinate the export of data from Fundware for the following items and anything else that needs to be imported to FreeBalance:

    • Ledger balances for FY23 from the trial balance;

    • Trial balance for the date that the conversion is scheduled or transaction details for FY24;

    • Budget data for FY24, FY25 and FY26;

    • Supplier vendors that have been cleaned up to only include vendors used in the past 12 months or with outstanding encumbrances and where possible to remove duplicates;

    • Purchase orders, encumbrances, commitments and payable invoices that are open as at the conversion date;

    • Receivable customers details, cleaned up to include only those used in the last 12 months and removing duplicates;

    • Receivable invoices that are open at the conversion date;

    • Bank reconciliation uncleared transactions for each bank account;

    • Assets details for all fixed assets (currently held in an Excel spreadsheets);

    • Employee details and balances of leave and payments made for the year as at the conversion date;

    • Payroll deduction and allowance details

  • Transfer cleaned data to FMIS-vendor supplied templates for upload into the new system

  • Test the migrated data for completeness and accuracy

A high level data conversion process is as follows:

This plan does not include all of the information to be extracted at this stage.

  1. OUTPUTS

  2. Work Plan

  3. Extract the data required from Fundware and cleanup to remove duplicates

  4. Write clean data to the excel spreadsheets provided by FreeBalance

  5. Test Reports on Migration

  6. QUALIFICATION AND EXPERIENCE REQUIREMENTS

The prospective candidate shall have previous experience in FMIS implementations and have direct experience in data migration and manipulation. Previous experience working with Fundware or other applications written in COBOL is a plus.

Mandatory Qualification and Experience:

  1. Bachelor’s degree in computer sciences, business or accounting

  2. Minimum of 5 years of overall technical experience is required

  3. A very good knowledge and previous experience using Microsoft Access, Excel and SQL Server

  4. Excellent communication and organizational skills, including a wide range of architectures and technologies

Desirable Qualifications and Experience

  1. Previous experience in working with Fundware (legacy system) or FreeBalance (new system)

  2. Experience with converting text files to a format that can be read (e.g. SQL Server or Access) and removing the headers from reports

  3. DURATION, LOCATION and CONDITIONS of ASSIGNMENT

The position is a full-time position in Palikir, State of Pohnpei, FSM. Domestic travel to other states will be required from time-to-time.

The position is an integral part of the Project Implementation Unit, and will report to the Assistant Secretary Treasury and the PFM Project Manager.

The duration will be until the end of the project in August 2025.

How to apply

  1. Further information can be obtained at the address below during office 0800 to 1700 hours.

  2. Expressions of interest must be delivered in a written form to the address below (in person or by e-mail) by 5:00 p.m. (local Pohnpei time, GMT+11), Friday, March 21, 2025.

  3. Department of Finance & Administration
    Attn: Lynda Roades
    PFM Project Manager
    Project for Strengthening Public Financial Management
    Palikir, Federated States of Micronesia

  4. E-mail:pfm1@dofa.gov.fm

  5. and cc to: Central Implementation Unit: ciu.pfm@gov.fm

  6. DURATION, LOCATION and CONDITIONS of ASSIGNMENT

The position is a full-time position in Palikir, State of Pohnpei, FSM. Domestic travel to other states will be required from time-to-time.

The position is an integral part of the Project Implementation Unit, and will report to the Assistant Secretary Treasury and the PFM Project Manager.

The duration will be until the end of the project in August 2025.

Similar Jobs
Job announcement

ICRS Socio Economic Counselling Assistant

Job announcement
Nigeria

On-site

Full-time

7
27 August 2025
03 September 2025
As per organization salary scale
1 vacancies

On-site

Full-time

ICRS Socio Economic Counselling Assistant

27 August 2025

03 September 2025

1 vacancies

7

As per organization salary scale

Job announcement

Job announcement

Nigeria

Job announcement

Operations Manager

Job announcement
Bangladesh

On-site

Full-time

6
27 August 2025
29 September 2025
As per organization salary scale
1 vacancies

On-site

Full-time

Operations Manager

27 August 2025

29 September 2025

1 vacancies

6

As per organization salary scale

Job announcement

Job announcement

Bangladesh

Job announcement

HR Officer

Job announcement
Syria, Syrian Arab Republic

On-site

Full-time

35
25 August 2025
30 August 2025
As per organization salary scale
1 vacancies

On-site

Full-time

HR Officer

25 August 2025

30 August 2025

1 vacancies

35

As per organization salary scale

Job announcement

Job announcement

Syria, Syrian Arab Republic

Job announcement

Backend Engineer - python

Job announcement
Remote

Remote

Full-time

75
24 August 2025
14 September 2025
As per organization salary scale
1 vacancies

Remote

Full-time

Backend Engineer - python

24 August 2025

14 September 2025

1 vacancies

75

As per organization salary scale

Job announcement

Job announcement

Remote

Job announcement

Small Business Counselor

Job announcement
United States of America

On-site

Full-time

79
23 August 2025
21 September 2025
As per organization salary scale
1 vacancies

On-site

Full-time

Small Business Counselor

23 August 2025

21 September 2025

1 vacancies

79

As per organization salary scale

Job announcement

Job announcement

United States of America

Job announcement

Support Services Officer

Job announcement
COLOMBIA

On-site

Full-time

46
23 August 2025
08 September 2025
As per organization salary scale
1 vacancies

On-site

Full-time

Support Services Officer

23 August 2025

08 September 2025

1 vacancies

46

As per organization salary scale

Job announcement

Job announcement

COLOMBIA