Data Integration Engineer- ERP Systems

Job Description

Job Description

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 OpenEdge 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 OpenEdge expertise. Comfort using modern AI-assisted tools to accelerate this work is also a plus.

Essential Responsibilities

ERP Data Mapping & Schema Expertise

• Document and map ERP data structures — tables, fields, relationships, and embedded business logic — across QAD, Progress OpenEdge, 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 OpenEdge (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.

Experience

• 5+ 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 OpenEdge, including reading/interpreting Progress OpenEdge 4GL data structures and business logic embedded in legacy schemas.
• Demonstrated experience mapping, documenting, or reverse-engineering ERP data structures — not just building integrations against them — with concrete work product such as mapping documents or data dictionaries.

Technical Skills

• Strong SQL skills for querying, troubleshooting, and reverse-engineering unfamiliar or undocumented schemas.
• Experience reading and interpreting ERP data dictionaries, table relationships, and business logic embedded in legacy systems (e.g., Progress OpenEdge 4GL structures).
• Ability to translate business reporting questions into accurate source-system queries.
• Experience with:
• Knowledge of:

Preferred Qualifications

• Experience with one or more additional major ERP platforms, such as SAP S/4HANA, SAP ECC, Oracle ERP, Microsoft Dynamics 365, Infor LN, Plex, or Epicor.
• Familiarity with Alteryx and/or Power BI, or other reporting/ETL platforms.
• Experience with SOAP services, DevOps, CI/CD pipelines, and source control systems.
• Experience with on-premise/self-hosted LLM deployment (e.g., Ollama, Open WebUI) or integrating internal data sources with locally hosted AI models.
• Project management experience or PMP certification.