JD Edwards Data & ERP Consultant

particle41llc; USA; Remote; USD 96.000 - 165.000; Vollzeit

Zusammenfassung

particle41llc is seeking a data engineer to own data engineering for an ERP environment built on JD Edwards. You will collaborate with ERP, IT, finance, distribution, and manufacturing teams to build dependable data flows and enable reporting.

The role emphasizes extracting, modeling, and transforming JD Edwards data, building ETL/ELT pipelines, creating trusted datasets for BI, finance, and operations reporting, and ensuring data validation and reconciliation across the enterprise.

Qualifikationen

• Five+ years of hands-on JD Edwards experience with deep knowledge of its data model and table structures.
• Strong SQL skills with Oracle, SQL Server, or DB2/IBM i (AS400).
• Experience designing data models and developing ETL/ELT pipelines.
• Participation in at least one full-cycle ERP implementation, upgrade, or migration with ownership of data conversion or migration work.
• Working knowledge of JD Edwards Financials, Distribution/Logistics, and Manufacturing modules.

Aufgaben

• Extract, model, and transform data from core JD Edwards areas such as address book, item, sales order, and general ledger tables.
• Build and maintain ETL/ELT pipelines that move ERP data into a warehouse or reporting platform.
• Lead data mapping, cleansing, conversion, and reconciliation for implementations, upgrades, or migrations, including cutover support.
• Create trusted datasets for business intelligence, finance, and operations reporting.
• Establish data validation and reconciliation checks, investigate discrepancies, and address their root causes.
• Document data flows, mappings, and conversion rules, and translate business questions into data requirements.

Kenntnisse

JD Edwards data model knowledge

SQL proficiency

ETL/ELT pipeline design

Data modeling

Data validation & reconciliation

Client interaction

Tools

Orchestrator

BSSV

UBEs

Table Conversion

Form Design Aid

Snowflake

Azure Data Factory

Databricks

AWS Glue

Redshift

dbt

BI tools

Python

Oracle

SQL Server

Jobbeschreibung

Role overview

Own data engineering work for an enterprise resource planning environment built on JD Edwards. You will work closely with ERP, IT, finance, distribution, and manufacturing teams to build dependable data flows, support system changes, and make operational and financial data useful for reporting.

Responsibilities

• Extract, model, and transform data from core JD Edwards areas such as address book, item, sales order, and general ledger tables.
• Build and maintain ETL/ELT pipelines that move ERP data into a warehouse or reporting platform.
• Lead data mapping, cleansing, conversion, and reconciliation for implementations, upgrades, or migrations, including cutover support.
• Create trusted datasets for business intelligence, finance, and operations reporting.
• Establish data validation and reconciliation checks, investigate discrepancies, and address their root causes.
• Document data flows, mappings, and conversion rules, and translate business questions into data requirements.

Requirements

• At least five years of hands-on JD Edwards experience with deep knowledge of its data model and table structures; EnterpriseOne or World experience is relevant.
• Strong SQL skills with Oracle, SQL Server, or DB2/IBM i (AS400).
• Experience designing data models and developing ETL/ELT pipelines.
• Participation in at least one full-cycle ERP implementation, upgrade, or migration, with ownership of data conversion or migration work.
• Working knowledge of JD Edwards Financials, Distribution/Logistics, and Manufacturing modules.
• Clear spoken and written English, comfort working directly with client stakeholders, availability during US business hours, and ability to work as an independent contractor.

Nice to have

Experience with JD Edwards technical tools such as Orchestrator, BSSV, UBEs, Table Conversion, or Form Design Aid; cloud data platforms such as Snowflake, Azure Data Factory, Databricks, AWS Glue or Redshift, or dbt; BI tools; Python; relevant industry experience; certification; or consulting and staff augmentation work.

Benefits and work setup

This is a full-time client-team assignment for an independent contractor. The role is specifically open to candidates in the LATAM region and requires working US business hours.