Data Migration Consultant

This is a fully remote position, open to applicants in Canada.

📋 Description

• Oversee the data conversion process to fully integrate the merged company into Epicor Kinetic.

• Transform master data and active transactions for the live production instance.

• Adjust data to comply with global data standards.

• Retrieve data from a custom on-premise SQL Server application and the legacy Sage BV environment.

• Develop repeatable, script-driven conversion routines for testing phases and the final transition.

• Implement documented transformation and mapping logic for operations, resources, product groups, and part classifications.

• Consolidate and verify inconsistent data, including units of measure and supplier records.

• Primarily load data using DMT, employing REST API, updatable BAQs, or other necessary tools.

• Ensure that converted data integrates smoothly into a live multi-company environment without interrupting operations.

• Guarantee that MRP yields reliable outcomes.

• Convert historical transactions into the Kinetic archive instance post-go-live.

• Provide support for associated development requests, such as BPMs.

⛳️ Requirements

• Extensive hands-on experience with Epicor Kinetic, having completed multiple data conversions.

• Proficient SQL Server skills, including complex scripting, data transformation, and the use of staging or mapping databases.

• In-depth experience with the Epicor Data Migration Tool (DMT).

• Demonstrated experience in converting data from non-Epicor or custom legacy systems.

• Strong functional understanding of Epicor manufacturing, encompassing BOMs, jobs, operations, resources, and MRP.

• Proven experience in cleansing and standardizing low-quality legacy data.

• Ability to work autonomously based on functional and technical specifications.

• Availability for full-time commitment throughout the conversion process.

• Experience in loading data into an already operational Kinetic environment.

• Familiarity with converting historical transactional data into Epicor.

• Experience extracting data from Sage BV or other non-SQL legacy systems.

• Development skills in Kinetic, including BPMs, REST API, BAQs, SSRS, and dashboards.

• Experience in multi-company or post-merger Epicor environments.

• Comfort in utilizing AI tools for data classification and cleanup.

🏝️ Benefits

• Contract position.

• Opportunity for remote work.

• Full-time commitment required for the duration of the conversion.