Automation Developer

Job Title

Reverse engineer, read, and author MS Access 2003/VBA code; untangle ~100k lines of legacy logic to document workflows and stabilize critical functions.

Design and implement SQL Server schemas (approx. 500 fields, with ~100 Q&A fields flowing into existing application to support modernized processing.

Build robust ETL/data ingestion pipelines (e.g., parsing output files and loading into SQL DB for downstream processing); automate validation and reconciliation.

Integrate with Infor: design interfaces/APIs/bridge tables and orchestrations to pass configuration/estimator data between Access/SQL and the Infor ecosystem.

Maintain on prem performance and reliability: indexing, query tuning, statistics management, isolation levels, and transactional integrity.

Establish coding standards, version control, and technical documentation for legacy and modern components; implement unit/integration test harnesses.

Partner with business (estimators, dealers) to map legacy rules to modern data structures; convert tribal knowledge into testable specifications.

Prepare for the S4 migration (start-to-finish planning) by isolating dependencies, defining cutover strategies, and drafting rollback/safety nets.

Drive secure handling of ERP data (authentication, role based access, auditing), and plan for multi year on prem operation before any cloud move.