Afternoon Enterprise System Jobs (NOW HIRING)

About the roleYou will be the expert who translates complex ERP structures into analytics-ready data. As our QAD/Progress OpenEdge authority, you’ll connect the dots between raw transactional tables, embedded 4GL business logic, and the information our data lake, Alteryx, and Power BI teams rely on for enterprise reporting.A day in the lifeMorning stand-up aligns you with data lake engineers on new extracts bound for OCI Object Storage / Oracle ADB. Before lunch, you untangle relationships across legacy QAD tables, updating a living data dictionary so that “what does this field mean?” has a durable, documented answer. In the afternoon, you troubleshoot a mapping anomaly impacting supply chain KPIs, refine validations, and push a fix through change control. You wrap the day reviewing a prototype that connects ERP/data lake content to a locally hosted LLM to accelerate mapping documentation.What you’ll ownDocument and map ERP data structures across QAD, Progress OpenEdge, and other source systems: tables, fields, relationships, and embedded business logic.Serve as the subject matter expert for the true meaning of fields/tables in source ERP systems.Translate business reporting needs into accurate data models and query logic.Reverse‑engineer schemas and relationships in systems with limited or outdated documentation.Produce and maintain source‑to‑target mapping documents capturing transformations and business rules.Build and maintain a living data dictionary for QAD/Progress OpenEdge (and others as needed) with field definitions, valid values, and business meaning.Integration and reporting enablementDesign extractions with the enterprise data lake as the landing zone—feeding raw and curated layers in OCI Object Storage / Oracle ADB—rather than point solutions.Build and support interfaces via database integrations, ODBC connections, and file‑based transfers.Troubleshoot data quality and mapping issues; implement corrective actions to protect data integrity.Monitor data flows and identify opportunities for optimization.Contribute to on‑premise LLM integration work (connecting ERP/data lake content to locally hosted models) for AI‑assisted data mapping, documentation, and query tooling.Data management and governanceEnsure data accuracy, consistency, and synchronization across enterprise systems.Develop validation, reconciliation, and exception‑handling processes.Collaboration and deliveryPartner with business stakeholders across:Work closely with data lake, Alteryx, and Power BI developers to provide structurally sound, semantically correct, reporting‑ready data.Translate business requirements into robust technical data‑mapping solutions.Participate in project planning, estimation, documentation, testing, and deployment.Provide technical guidance and best practices for ERP data structure and integration architecture.Security and complianceEnsure data handling and integrations comply with company cybersecurity standards.Support compliance related to automotive customer expectations and industry standards.Maintain documentation, version control, and change management processes.EducationBachelor's degree in:Equivalent combination of education and experience may be considered.Experience5+ years 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 embedded business logic.Proven history mapping, documenting, or reverse‑engineering ERP data structures with tangible artifacts (e.g., mapping documents, data dictionaries).Technical skillsAdvanced SQL for querying, troubleshooting, and reverse‑engineering unfamiliar or undocumented schemas.Experience interpreting ERP data dictionaries, table relationships, and legacy system logic (e.g., Progress OpenEdge 4GL structures).Ability to convert business reporting questions into precise source‑system queries.Experience with:Knowledge of:Preferred qualificationsExperience with one or more major ERP platforms: 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.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. #J-18808-Ljbffr