landing_page-logo
Ontrac Solutions logo

Data Engineer – High-Impact ERP Data Project (Remote)

Ontrac SolutionsChicago, IL

Automate your job search with Sonara.

Submit 10x as many applications with less effort than one manual application.1

Reclaim your time by letting our AI handle the grunt work of job searching.

We continuously scan millions of openings to find your top matches.

pay-wall

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

Automate your job search with Sonara.

Submit 10x as many applications with less effort than one manual application.

pay-wall