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-08-23

Recommended Jobs

Crew Member

27106 Jersey Mike's Dixon Il
Dixon, IL

Job Description Job Description Jersey Mike's Subs has been making amazing subs since 1956 in Point Pleasant New Jersey! The Jersey Mikes tradition was founded on a strong sense of community an…

View Details
Posted 2025-07-29

Concessions Attendant

Compass Group
Highland Park, IL

  Position Title: Concessions Attendant - Ravinia Festival Pay Range : $9.00 plus tips We Make Applying Easy! Want to apply to this job via text messaging? Text JOB to 75000  and search …

View Details
Posted 2025-08-07

Billing Analyst

LaSalle Network
Chicago, IL

LaSalle Network is partnered with a leading civil engineering company in search of a dynamic Billing Analyst to join their expanding accounting team. Located in downtown Chicago, this forward-thinki…

View Details
Posted 2025-08-20

CLINICAL NURSE MANAGER

State of Illinois
Chicago, IL

Job Requisition ID: 48726  Opening Date: 08/14/2025 Closing Date: 08/27/2025 ​Agency:  Department of Human Services Class Title: PUBLIC SERVICE ADMINISTRATOR - 37015  Skill Option:  Spec…

View Details
Posted 2025-08-22

Sr. Product Manager, AI (R&D Lab)

Lgelectronics
Lincolnshire, IL

Step into the innovative world of LG Electronics. As a global leader in technology, LG Electronics is dedicated to creating innovative solutions for a better life. Our brand promise, 'Life's Good', e…

View Details
Posted 2025-08-20

Associate Veterinarian

Pathway Vet Alliance
Chatham, IL

Description Position at Grace Veterinary Clinic Associate Veterinarian Full-Time   Chatham, IL   No Weekends! $50k Hiring bonus and $10k relocation assistance available!   You’ll get to know…

View Details
Posted 2025-08-06

Entry Level Police Officer-Prospect Heights Police Department

National Testing Network
Prospect Heights, IL

Prospect Heights Police Department 14 East Camp McDonald Rd. Prospect Heights, Illinois 60070 Phone: 847-398-5511 Patrol Officer Examination Announcement Salary: Starting Step 1: $73,90…

View Details
Posted 2025-08-07

Housekeeper

Fitness Formula Clubs (FFC)
Oak Park, IL

Benefits: Dental insurance Health insurance Vision insurance We are looking to hire a Housekeeper who is outgoing, reliable, and coachable. At FFC high-quality customer service is a must!…

View Details
Posted 2025-08-06

Veterinary Dermatologist

Premier Veterinary Group - Chicago
Chicago, IL

Premier Veterinary Group is seeking a Small Animal Dermatologist to join our 24/7 Emergency and Specialty Referral Hospital in Chicago, Illinois.  Premier Veterinary Group has been long establish…

View Details
Posted 2025-07-30

Medical Assistant

DR ZAREENA ABBAS MD SC
Chicago, IL

Job Description Job Description Job Description: Medical Assistant Location: Chicago, IL Compensation: $17-18 hour (based on experience) Position Type: Full-Time in person   Job Summa…

View Details
Posted 2025-07-26