Data Engineer – High-Impact ERP Data Project
Ontrac Solutions - Chicago, IL
Apply NowJob Description
Industry: Private Equity–Backed ManufacturingLocation: Remote (US-Based Preferred)Start Date: ASAPDuration: 3–6 months with high potential for extension (Phase 2)Make a Real Impact from Day OneAre you a seasoned Data Engineer looking for a project where your work directly drives financial decisions and business transformation? Join us on a high-priority initiative for a PE-backed manufacturer undergoing a major ERP shift. Your mission: help establish a critical monthly inventory valuation process by unlocking data from a legacy AS400 system.This is a unique opportunity to lead a highly visible, hands-on project from the ground up—solving real business problems, working with engaged stakeholders, and setting the stage for long-term modernization.What You’ll DoDesign & build an interim data extraction pipeline from a legacy AS400 (IBM iSeries) system.Create a monthly “book of record” for inventory valuation, enabling financial close and business reporting.Engineer a method to lock monthly labor and material inputs for data consistency and audit-readiness.Collaborate directly with finance, ops, and executive stakeholders—no red tape.Set the foundation for Phase 2: advanced visualization and ongoing maintenance.What You Bring8+ years of experience as a data engineer or technical data consultant.Solid track record of working with legacy systems, especially AS400/DB2 (strongly preferred).Strong skills in ETL pipeline development, SQL, and handling structured enterprise fortable working in fast-paced, private equity-backed or high-growth environments.Deep understanding of inventory valuation, cost inputs, or financial close processes.You’re a self-starter, comfortable owning deliverables and working independently.Tech EnvironmentAS400 / DB2 (preferred), legacy ERPsPython, SQL, Bash/Shell scriptingSQL Server, Oracle, SnowflakeGit or version control workflowsPower BI, Tableau (for future phases)Why You’ll Love This RoleImmediate impact on a business-critical initiativeFlexible, remote work setup with autonomyWork with a highly collaborative client team who values technical leadershipOpportunity to own a project end-to-end, not just maintain someone else's codeVisibility and influence with executive stakeholdersPossibility for follow-on work in analytics, visualization, and ERP transformation #J-18808-Ljbffr
Created: 2025-09-18