Data Engineer High-Impact ERP Data Project

Ontrac-solutions-llc
Chicago, IL

Industry: Private Equity–Backed Manufacturing

Location: Remote (US-Based Preferred)

Start Date: ASAP

Duration: 3–6 months with high potential for extension (Phase 2)

Are 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.



  • Design & 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.




  • 8+ 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 data.



  • Comfortable 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.




  • AS400 / DB2 (preferred), legacy ERPs



  • Python, SQL, Bash/Shell scripting



  • SQL Server, Oracle, Snowflake



  • Git or version control workflows



  • Power BI, Tableau (for future phases)




  • Immediate impact on a business-critical initiative



  • Flexible, remote work setup with autonomy



  • Work with a highly collaborative client team who values technical leadership



  • Opportunity to own a project end-to-end , not just maintain someone else's code



  • Visibility and influence with executive stakeholders



  • Possibility for follow-on work in analytics, visualization, and ERP transformation

Posted 2025-11-25

Recommended Jobs

Accounting Assistant

LaSalle Network
Lake, IL

We are seeking a detail-oriented and highly organized Accounting Assistant with a focus on Accounts Payable to join our finance team located near Lake Forest, Il. This role is crucial for supporting…

View Details
Posted 2025-08-19

Generator Technician

JC Davis Ventures LLC dba JC Davis Power
Elgin, IL

The role of Generator Technician at the Company requires a high level of specialized knowledge, skill and expertise in the relevant industry. You have demonstrated that with your experience and train…

View Details
Posted 2025-10-23

Server

Harrison Staffing
Ottawa, IL

We’re Hiring – Catering Servers in Ottawa! &##127775; Join the Harrison Staffing team and be part of unforgettable corporate events in the Ottawa area. What you’ll do: # Assist with buffet-style…

View Details
Posted 2025-11-19

Manager

BMO US
Chicago, IL

320 S Canal Street Chicago Illinois,60606 Supports the build, management, and execution of an enterprise-wide liquidity and funding management framework to optimize risks and maximize risk-ad…

View Details
Posted 2025-11-24

Lead Development Specialist, Security

Johnson Controls
America, IL

THIS IS A HYBRID POSITION. Candidates can reside anywhere in the U.S within proximity to a local JCI branch location. Unleash your potential with the Johnson Controls team! As a global leader…

View Details
Posted 2025-11-18

Ball Mill Operator

JM Huber Corporation
Quincy, IL

Portfolio Business :   Huber Engineered Materials   J.M. Huber Corporation is one of the largest privately held, family-owned companies in the United States. Established in 1883, we are a divers…

View Details
Posted 2025-11-14

NA Sales Representative, OCI Commercial Named

Oracle
Springfield, IL

Job Description Oracle is a fast-paced, collaborative environment passionate about crafting customer success. We offer the most comprehensive, cloud-based technology. At Oracle, learning is con…

View Details
Posted 2025-11-23

Director customer account management

UKG (Ultimate Kronos Group)
Springfield, IL

Why UKG: At UKG, the work you do matters. The code you ship, the decisions you make, and the care you show a customer all add up to real impact. Today, tens of millions of workers start and end…

View Details
Posted 2025-11-18

Area Chief of Staff

Banfield Pet Hospital
Naperville, IL

Job Description SUMMARY OF JOB PURPOSE AND FUNCTION The anticipated starting base salary range for individuals expressing interest in this position is $148,000 to $200,000 per year, plus product…

View Details
Posted 2025-11-09

Subject Matter Expert (Food Critic)

TransPerfect
Chicago, IL

Job description Work Location: Anywhere within the US (Remote) Engagement Model: Freelancer / Independent Contractor Weekly Workload: Up to 40 hours/week Required Experience: Professio…

View Details
Posted 2025-11-23