<p>We are a market-leading U.S. consumer packaged goods (CPG) food manufacturer specializing in top-selling, allergy-friendly, and plant-based baked goods. Founded with a mission to create safe, delicious products for individuals with severe food allergies, our products are distributed to major retail and distribution partners nationwide.</p><p>Position Overview</p><p>We are seeking a highly motivated, in-house <strong>ERP &amp; Database Engineer</strong> to take full ownership of our business data systems—assessing, updating, and optimizing our technical infrastructure.</p><p>We currently operate on an on-premise manufacturing ERP running on a Firebird 3.0 database (approx. 14 GB across 250+ tables). Internal reporting is driven by a legacy dashboard built in Visual Basic 6.0 (VB6), Microsoft Access, and ODBC connections. The ideal candidate will quickly master our existing legacy environment, document data flows, recommend a modernized path forward, and lead the technical execution.</p><p><br></p><p><strong><em>Key Responsibilities</em></strong></p><p><br></p><p>Phase 1: Assessment &amp; Strategy</p><ul><li><strong>System Mapping:</strong> Map data flows between the core ERP, Firebird database, legacy VB6/Access dashboard, and EDI invoicing infrastructure.</li><li><strong>Database Audit:</strong> Identify custom tables/queries, resolve duplicate or inconsistent records, repair missing keys, and extract business logic embedded in legacy reports or spreadsheets.</li><li><strong>System Health Check:</strong> Review database maintenance, automated backups, file growth trends, and database version status.</li><li><strong>Knowledge Capture:</strong> Interview key internal stakeholders across Engineering, Accounting, Sales, and Production to document legacy logic and operational workflows.</li><li><strong>Strategic Recommendation:</strong> Present a comprehensive plan (including cost, timeline, and risk analysis) choosing one of the following paths:</li></ul><ol><li>Maintain the current ERP, clean core data, and replace the legacy dashboard.</li><li>Maintain the current ERP and build a separate, well-modeled reporting database to power dashboards.</li><li>Replace the legacy ERP with a new enterprise system and execute the data migration.</li></ol><p>Phase 2: Remediation &amp; Execution</p><ul><li>Lead the selected technical roadmap from design and architecture through system cutover.</li><li>Establish automated database maintenance, tested backup procedures, monitoring, and upgrade schedules.</li><li>Retire the legacy VB6/Access dashboard in collaboration with our internal Systems Analyst (currently developing a modern Python replacement).</li><li>Maintain comprehensive documentation and train internal team members to ensure long-term system maintainability and continuity.</li></ul><p><br></p>

<p>Key Qualifications &amp; Experience</p><ul><li><strong>Relational Database Expertise:</strong> 5+ years of hands-on experience managing production relational databases (SQL, schema design, and query optimization).</li><li><strong>ERP Experience:</strong> Proven background supporting, customizing, integrating, or migrating ERP software within a manufacturing environment.</li><li><strong>Legacy System Reverse Engineering:</strong> Track record of assessing, reading, and documenting legacy code bases you did not originally build (specifically VB6, Access/VBA, and ODBC integrations).</li><li><strong>Database Administration (DBA):</strong> Demonstrated experience with database backups/restores, routine maintenance, and version upgrades.</li><li><strong>Technical Communication:</strong> Ability to translate complex technical tradeoffs clearly to executive owners, operational managers, and finance teams.</li></ul><p>Preferred / Plus Skills</p><ul><li>Experience with specialized small-to-midsize manufacturing ERP systems (e.g., DBA Manufacturing or similar).</li><li>Experience with EDI workflows, particularly X12 invoicing (810) with major retail and distribution partners.</li></ul><p><br></p>

<h3 class="rh-display-3--rich-text">Technology Doesn't Change the World, People Do.^®</h3> <p>Robert Half is the world’s first and largest specialized talent solutions firm that connects highly qualified job seekers to opportunities at great companies. We offer contract, temporary and permanent placement solutions for finance and accounting, technology, marketing and creative, legal, and administrative and customer support roles.</p> <p>Robert Half works to put you in the best position to succeed. We provide access to top jobs, competitive compensation and benefits, and free online training. Stay on top of every opportunity - whenever you choose - even on the go. <a href="https://www.roberthalf.com/us/en/mobile-app" target="_blank">Download the Robert Half app</a> and get 1-tap apply, notifications of AI-matched jobs, and much more.</p> <p>All applicants applying for U.S. job openings must be legally authorized to work in the United States. Benefits are available to contract/temporary professionals, including medical, vision, dental, and life and disability insurance. Hired contract/temporary professionals are also eligible to enroll in our company 401(k) plan. Visit <a href="https://roberthalf.gobenefits.net/" target="_blank">roberthalf.gobenefits.net</a> for more information.</p> <p>© 2025 Robert Half. An Equal Opportunity Employer. M/F/Disability/Veterans. By clicking “Apply Now,” you’re agreeing to Robert Half’s <a href="https://www.roberthalf.com/us/en/terms">Terms of Use</a> and <a href="https://www.roberthalf.com/us/en/privacy">Privacy Notice</a>.</p>