JD Edwards Data Architect for ERP & BI

particle41llc; United States; Remote; USD 96,000 - 165,000; Full time

Job summary

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.

Qualifications

• 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.

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.

Skills

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

Job description

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.