Data Integration Engineer- ERP Systems

Position Summary The Data Integration Engineer is responsible for understanding and mapping ERP system data structures — including tables, fields, and business logic — to support enterprise reporting and integration needs. This role bridges the gap between raw ERP data and our analytics platforms, ensuring the underlying data is accurately understood, extracted, and made query-ready for downstream consumption by our data lake, Alteryx, and Power BI development teams.

The ideal candidate possesses deep, hands-on expertise with QAD and Progress Open Edge and a proven ability to translate complex, often undocumented source-system data into accurate, reliable models that support manufacturing, supply chain, quality, logistics, customer, and supplier reporting needs.

Experience with other major ERP platforms is a plus but does not substitute for QAD/Progress Open Edge expertise. Comfort using modern AI-assisted tools to accelerate this work is also a plus.

Essential ResponsibilitiesERP Data Mapping & Schema Expertise Document and map ERP data structures — tables, fields, relationships, and embedded business logic — across QAD, Progress Open Edge, and other source systems.

Serve as the subject matter expert on "what does this field/table actually mean" for source ERP systems, filling a critical knowledge gap between raw data and reporting.

Translate business reporting requirements into accurate data models and query logic.

Reverse-engineer schemas and data relationships in systems with limited or outdated documentation.

Produce and maintain source-to-target mapping documents for each extracted table/field, capturing transformation logic and business rules.

Build and maintain a living data dictionary for QAD/Progress Open Edge (and other source systems as needed), documenting field definitions, valid values, and business meaning so this knowledge is captured as a durable asset rather than tribal knowledge.

Integration, Data Lake & Reporting Support Partner closely with the data lake, Alteryx, and Power BI development teams to ensure extracted data is structurally sound, semantically correct, and reporting-ready.

Design extractions with the data lake as the landing target — feeding raw and curated lake layers (OCI Object Storage / Oracle ADB) — rather than building one-off, point-to-point extracts for individual reports.

Build and support interfaces using database integrations, ODBC connections, and file-based transfers as needed to support extraction work.

Troubleshoot data quality and mapping issues and implement corrective actions to maintain data integrity.

Monitor data flows and proactively identify opportunities for process optimization.

Opportunity to contribute to on-premise LLM integration work (e.g., connecting ERP/data lake content to locally hosted models) for internal AI-assisted data mapping, documentation, and query tooling.

Data Management & Governance Ensure data accuracy, consistency, and synchronization across enterprise systems.

Develop validation, reconciliation, and exception-handling processes.

Collaboration & Project Delivery Partner with business stakeholders across:

Collaborate closely with the data lake, Alteryx, and Power BI developers to ensure data feeding their platforms is accurate and usable.

Translate business requirements into technical data-mapping solutions.

Participate in project planning, estimation, documentation, testing, and deployment activities.

Provide technical guidance and best practices for ERP data structure and integration architecture.

Security & Compliance Ensure data handling and integrations comply with company cybersecurity standards.

Support compliance requirements related to automotive customer expectations and industry standards.

Maintain proper documentation, version control, and change management processes.

Education Bachelor's degree in:

Equivalent combination of education and experience may be considered.

Experience5+ years of experience in data integration, ERP systems, or enterprise application development.
3+ years supporting manufacturing organizations.

Required:

Hands-on experience with QAD and Progress Open Edge, including reading/interpreting Progress Open…