Logo for Main Line Talent Group

Epicor Data Migration Consultant

Role overview

Summary

This role focuses on leading the data conversion for a global manufacturer transitioning to Epicor Kinetic. You will work closely with the client's Kinetic support lead to ensure a smooth migration of data from legacy systems, supporting the company's operational standardization efforts.

Qualifications

  • Extensive hands-on Epicor Kinetic experience, with multiple completed data conversions.
  • Strong SQL Server skills, including complex scripting and data transformation.
  • Deep experience with the Epicor Data Migration Tool (DMT).
  • Proven experience converting data from non-Epicor or custom legacy systems.
  • Solid functional understanding of Epicor manufacturing, including BOMs, jobs, operations, resources, and MRP.

Responsibilities

  • Extract data from legacy sources including a custom SQL Server application and a Sage BV environment.
  • Build repeatable, script-driven conversion routines for data migration.
  • Apply transformation and mapping logic to align legacy data with global standards.
  • Load data using DMT and ensure it integrates smoothly into a live multi-company environment.

Key facts

Hard skills

About the company

Main Line Talent Group logo

Main Line Talent Group

  • Staffing & Recruiting
  • 2–10
Main Line Talent Group seeks to connect talented professionals with high-quality job opportunities, much like how the Main Line railway connected people and places. The agency's team of experienced recruiters uses a targeted approach to match candidates with positions that align with their skills, experiences, and career aspirations. By drawing on the rich history and legacy of the Main Line, Main Line Talent Group reinforces its commitment to excellence and quality, just as the Pennsylvania Railroad did when building its iconic railway.

Your match analysis

See how your profile stacks up against this role.

We compared the job requirements to your profile to show where you're strong and where you fall short.

Job description

This is a remote position.

Our client, a global manufacturer of industrial processing equipment, is standardizing its operations on Epicor Kinetic under a common global design. Its Greater Toronto Area business recently merged three separate companies into a single operation. Two of those companies are already live on Kinetic. The third company’s finances are live on Kinetic, but its manufacturing operations still run on a legacy custom-built system that is being retired.

We are looking for an experienced Kinetic developer to lead the data conversion that brings this final company fully onto the platform. You will work from existing functional and technical specifications, with oversight from the client’s Kinetic support lead, who knows the data and processes in depth.

The work has two phases. First, you will convert master data and active transactions into the live production instance, transforming them to match global data standards. After go-live, you will load historical data as-is into a separate Kinetic archive instance used for reporting and transaction lookup.

Key responsibilities:

  • Extract data from two legacy sources: a custom on-premise SQL Server application covering BOMs, jobs, and operations, and a legacy Sage BV environment covering purchasing, sales orders, and financials, which may require report-based exports.
  • Build repeatable, script-driven conversion routines that can be rerun across multiple test cycles and the final cutover.
  • Apply documented transformation and mapping logic, including mapping legacy operations and resources to the merged company’s structure and mapping legacy part groupings to Kinetic product groups and part classes.
  • Consolidate and validate inconsistent data, especially free-form units of measure and supplier records that overlap with existing master data.
  • Load data primarily with DMT, using REST API, updatable BAQs, or other tools where needed.
  • Make sure converted data merges cleanly into a live, multi-company environment without disrupting current operations, and that MRP produces reliable results.
  • Convert historical transactions into the Kinetic archive instance after go-live.
  • Support related development requests as needed, such as BPMs.


Requirements

Required:

  • Extensive hands-on Epicor Kinetic experience, with multiple completed data conversions
  • Strong SQL Server skills, including complex scripting, data transformation, and use of staging or mapping databases
  • Deep experience with the Epicor Data Migration Tool (DMT)
  • Proven experience converting data from non-Epicor or custom legacy systems
  • Solid functional understanding of Epicor manufacturing, including BOMs, jobs, operations, resources, and MRP
  • Experience cleansing and standardizing poor-quality legacy data
  • Ability to work independently from functional and technical specifications
  • Availability to commit full-time for the duration of the conversion

Preferred:

  • Experience loading data into an already-live Kinetic environment
  • Experience converting historical transactional data into Epicor
  • Experience extracting data from Sage BV or other non-SQL legacy systems
  • Kinetic development skills, including BPMs, REST API, BAQs, SSRS, and dashboards
  • Experience with multi-company or post-merger Epicor environments
  • Comfort using AI tools to assist with data classification and cleanup


Related jobs

See all jobs

Other jobs at Main Line Talent Group