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.
