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-09-14

Recommended Jobs

Security Officer-Full Time Nights

Catherine Gratz Griffin Lake Forest Hospital
Lake Forest, IL

The salary range for this position is $20.00 - $28.00 (Hourly Rate) Placement within the salary range is dependent on several factors such as relevant work experience and internal equity. For positi…

View Details
Posted 2025-10-30

Body work mechanic

Super Ego Holding LLC
Elk Grove Village, IL

Body Work Mechanic – Flexible Hours Location: Elk Grove Village, IL | Company: Super Ego Holding Pay: From $45.00 per hour About the Role Super Ego Holding is looking for a skilled Bod…

View Details
Posted 2025-10-30

Experienced Diesel Mechanic All Shifts

A & R Transport
Morris, IL

A&R Logistics is a leader in the bulk transportation industry   We are seeking  hardworking and dedicated Diesel Mechanics to join our Bulk Transportation Team.   We offer a learning atmosphere to…

View Details
Posted 2025-08-06

IFS Functional Business Consultant

Arcwide
Chicago, IL

At Arcwide , we are more than just a consultancy, we are a team driven by commitment, teamwork, excellence, and passion . As the largest IFS Partner globally , we deliver world-class IFS Cloud …

View Details
Posted 2025-09-29

Licensed Mental Health Therapist (LMFT, LCPC, LCSW)

Gotham Enterprises Ltd
Peoria, IL

Job Description Job Description Remote Mental Health Therapist – LCSW, LCPC, LMFT Salary: $100,000 – $110,000 Schedule: Monday–Friday, 9:00 AM–5:00 PM The Role: We’re seeking license…

View Details
Posted 2025-10-24

Associate Director of Operations

Tried and True Media
Chicago, IL

Associate Director of Operations Full-time, remote About the Company Tried and True Media (TNT) is a dynamic performance marketing agency that has generated over $1.2 billion in sales for ou…

View Details
Posted 2025-09-29

Senior regulatory expert

Assent Compliance
Chicago, IL

Company Description Assent is the leading solution for supply chain sustainability tailored for the world’s top-tier, sustainability-driven manufacturers. Hidden risks riddle supply chains, many o…

View Details
Posted 2025-11-03

Certified Ford Technician

Murgado Ford of Chicago
Chicago, IL

At Murgado Ford of Chicago, part of the esteemed Murgado Automotive Group, we pride ourselves on delivering top-notch automotive service and maintaining an outstanding reputation in the industry. We a…

View Details
Posted 2025-08-28

Restaurant Kitchen Manager

Red Robin
Gurnee, IL

Restaurant Kitchen Manager Compensation Range: 55,000.00 - 68,800.00 The Restaurant Kitchen Manager is r esponsible for ensuring seamless day-to-day kitchen operations, with an unwavering comm…

View Details
Posted 2025-10-24

District manager

CSC Generation
Chicago, IL

With over 50 stores and the largest avocational cooking program in the US, Sur La Table offers an unsurpassed selection of exclusive and premium-quality goods for the kitchen and table – and the cu…

View Details
Posted 2025-10-30