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

MedTech Enterprise Sales Director

Veeva Systems
Chicago, IL

Veeva Systems is a mission-driven organization and pioneer in industry cloud, helping life sciences companies bring therapies to patients faster. As one of the fastest-growing SaaS companies in histo…

View Details
Posted 2025-08-23

Full Time Hospitalist Job IN

Enterprise Medical Recruiting Enterprise Medical Recruiting
Chicago, IL

Are you looking for a workplace that values teamwork and prioritizes quality? An exceptional Hospital in northern Indiana is currently seeking BC/BE Adult Hospitalists/Nocturnists to launch a new Noc…

View Details
Posted 2025-09-10

Operations Assistant

Midwest Express Clinic
Illinois

About the Company Provider of urgent and primary care centers for individuals in the Midwest, focused on an affordable approach to delivering urgent and primary care services. The Company’s primar…

View Details
Posted 2025-07-30

2025067 Software Engineer

John Deere
Chicago, IL

There are over 7 billion people on this planet. And by 2050, there will be 2 billion more... many moving into urban centers at an unprecedented rate. Making sure there is enough food, fiber and infra…

View Details
Posted 2025-09-14

Full Time Physician Float

Concentra
Chicago, IL

Monthly and Quarterly Bonus Incentives! Are you looking for a physician practice with a family environment, but with the benefits and support a large organization can provide?  Where daily patient …

View Details
Posted 2025-09-08

Field Service Engineer - Automation, Packaging - FULLY REMOTE

RemX
Chicago, IL

Job Description Job Description ** $38/hr. - $42/hr. DOE. plus full benefits, OT, bonus pay, PTO, paid travel, company card, per diem, full training provided **   RemX is seeking a Field Servic…

View Details
Posted 2025-08-06

Construction Manager (self performing)

Lakeshore Sport & Fitness
Chicago, IL

Job Description Job Description The construction manager will be responsible for oversight of our projects in 3 Midwest club locations Chicago, Milwaukee and Madison, WI and will work closely wit…

View Details
Posted 2025-07-26

Licensed Practical Nurse

Pana Community Hospital
Pana, IL

Department:  Emergency Department Job Title: LPN Status: Non- exempt; Part-time Hours:11:00 a.m.- 11:00 p.m. Salary Range: $23.50-$31.00 Description: Pana Community Hospital Emergency Departmen…

View Details
Posted 2025-08-28

Radiologic Technologist - New Grads Welcomed

Radius Staffing Solutions
Bellevue, IL

Job Description Job Description Radiologic Technologist Central Illinois | Up to $12,000 Sign-On Bonus + Shift Differentials Join a mission-driven healthcare team in the heart of Central Illin…

View Details
Posted 2025-07-29

FEEDMILL DRIVER| JBS Live Pork-Midwest Region| Bushnell, IL & Oakville, IA

JBS
Bushnell, IL

Description Position at JBS USA JBS is seeking an hourly Feed Mill Driver Team Member! Position starts at $25 per hour with the ability to go up DOE and $2/hour Shift Differential.  Nature of Pos…

View Details
Posted 2025-08-06