Data Migration Consultant - ROA - RTR-FA AP/AR

Boardroom Appointments; Sandton; On-site; ZAR 900,000 - 1,200,000; Full time

Job summary

Boardroom Appointments in Sandton is seeking a Data Migration Consultant to manage the migration of data from legacy systems to the D365 F&O platform, coordinating across departments.

You'll lead mapping, cleansing, and ETL work with emphasis on RTR accounting, AP/AR, and journal entries, using SSIS and the D365 DMF.

The role requires a strong accounting background and extensive ERP migration experience, offering a challenging environment with opportunities to shape data processes.

Qualifications

• Bachelor's degree in Business Administration or Accounting.
• 8 years of accounting management/accounting experience in financial sector.
• Experience with RTR reporting systems.
• 5 years in a similar role with financial or business accounting experience.

Responsibilities

• Lead data mapping and migration of closing balances from legacy ERP to opening balances in CCBA D365 F&O ERP.
• Experience with Accounts Payable and Accounts Receivable processes.
• Handle journals and postings.
• Understand SSIS and the D365 DMF with batch handling.
• Oversee extraction, cleansing, and mapping for the ETL process.
• Coordinate template completion for the Construct process.
• Facilitate resolution of load errors and log defects in DevOps.
• Provide status reporting per functional area as needed.
• Collaborate with business resources to resolve data queries.

Skills

Data mapping

ETL processes

SSIS

D365 DMF

Accounts payable/receivable

Journals

Education

Bachelor's degree in Business Administration, Accounting or related field

Tools

D365 F&O

Job description

About the job Data Migration Consultant - ROA - RTR-FA AP/AR

Key purpose:

As a Data Migration Consultant, you'll work with various departments to manage the migration of data from legacy systems. You'll be responsible for supporting the development and implementation of effective solutions that allow businesses to maintain their business processes while making best use of our technology platform.

Duties and responsibilities:

• Responsible for the Data Mapping and Migration of the Closing Balances in the legacy ERP to be taken on as the Opening Balances in the CCBA D365 F&O ERP
• Experience in Accounts Payable as well as Accounts Receivable
• Journals experience
• Understanding SSIS packages as well as the D365 DMF (Data Migration Framework) with Batch handling
• Manage, facilitate, and drive the extraction criteria, data cleansing, object mapping, field mapping and value mapping for the ETL process
• Manage, facilitate, and drive the filling in of the templates by the Business for the Construct process
• Facilitate Issue resolution where there are load errors (Defects logged in DevOps)
• Status reporting per functional area as and when needed
• Engage with business resources per stream to resolve data queries

Qualifications and experience:

• Bachelors Degree in Business Administration, Accounting or a related field required
• 8 years of experience as an accounting manager/accountant in the financial sector required
• Experience with RTR reporting systems
• 5 years of experience in a similar position with financial and/or business accounting experience