Data Engineer - High-Impact ERP Data Project

Ontrac Solutions IncChicago, IL, United States

job_description.job_card.30_days_ago

serp_jobs.job_preview.job_type

serp_jobs.job_card.temporary

job_description.job_card.job_description

Industry : Private Equity-Backed Manufacturing

Location : Remote (US-Based Preferred)

Start Date : ASAP

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

Make a Real Impact from Day One

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.

What You'll Do

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.

What You Bring

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.

Tech Environment

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)

Why You'll Love This Role

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

serp_jobs.job_alerts.create_a_job

Data Engineer • Chicago, IL, United States