100% Remote ERP Subject Matter Expert (SME)

DMS Vision•Frisco, TX

4h•Remote

About The Position

The ERP Subject Matter Expert will join a US-based consulting practice and provide hands-on technical support for enterprise ERP migration and integration projects. The role focuses on data extraction, SQL view development, field mapping, integration design, and cross-module guidance for clients migrating from legacy ERP systems to modern HCM and payroll platforms. It is client-facing and project-driven, with the SME embedded in client teams to unblock migration work, ensure data accuracy through parallel testing, support production go-live, and assist with post-go-live warranty issues. The position works with ERP systems including PENTA, SAGE Timberline, Dynamics SL, and Dynamics 365 F&O; HCM platforms including Ceridian Dayforce; and integration systems such as HeavyJob (HCSS), PentaConnect APIs, Azure SQL, Oracle, and Microsoft Fabric. Tools include SQL Server Management Studio, Python ETL scripts, Postman, and Fabric Data Flows. The role is remote and has a stated duration of 6+ months.

Requirements

At least 10 years of hands-on experience with enterprise ERP systems such as PENTA, SAP, Oracle, Dynamics 365, or SAGE.
PENTA application and data-integration knowledge is required.
At least 3 years of hands-on experience with PENTA ERP HR/payroll and Project Management modules.
Deep knowledge of ERP database schemas, including core HR/payroll tables, payroll check history, YTD structures, and timecard tables.
Strong SQL skills, including complex extraction views, multi-table joins, and point-in-time query logic.
Experience with data migration projects from legacy ERP systems to modern HCM/payroll platforms.
Understanding of US payroll, including gross-to-net, federal/state/local tax withholding, deductions, earnings, and YTD accumulation.
Experience in a consulting or client-facing technical delivery role.

Nice To Haves

Experience with Ceridian Dayforce import templates and data specifications.
Familiarity with HeavyJob (HCSS) and construction-industry payroll, including certified payroll, prevailing wage, and union/non-union payroll.
Experience with PentaConnect REST APIs for PM, Timecard, AR, AP, and Core modules.
Knowledge of SAGE Timberline or Dynamics 365 Finance & Operations.
Construction or engineering industry background.

Responsibilities

Develop, validate, and optimize SQL extraction views against ERP HR, payroll, and financial databases.
Create extraction views for HCM/payroll migration templates covering employee data, earnings, deductions, tax, entitlements, and legacy payroll.
Implement effective-dating logic for historical and point-in-time data extraction.
Reconstruct year-to-date (YTD) values from check-history detail tables when summary tables contain only current totals.
Validate and refine field mappings from ERP source tables to target-platform specifications.
Build crosswalk and translation tables for earning codes, deduction codes, pay groups, tax jurisdictions, and employment-status codes.
Resolve grain mismatches across employee-, check-, and distribution-level data.
Provide expertise on ERP database schemas, including HR/payroll, Project Management, Billing, GL, and AP modules.
Advise on schema permissions, view-based extraction strategies, and data-access patterns.
Support data-quality assessments and exception reporting.
Provide subject-matter input on integration flows among ERP, HCM/payroll, and field-management systems.
Support REST API integration design for PM, Timecard, AR, AP, and Core modules.
Help evaluate automation options for manual processes such as job-cost true-up and GL exports.
Support multiple UAT cycles during the parallel-run phase.
Execute and validate data extracts for each test iteration.
Address defects and data-quality issues between testing cycles.
Support production data extraction and validation for go-live.
Participate in post-go-live warranty support for migration-related data issues.