Manufacturing Systems & ERP Data Specialist; Aviation

Position: Manufacturing Systems & ERP Data Specialist (Aviation)
*
* Location:

** Sanford, FL area (onsite)
** Contract Type:
** 1099 Independent Consultant
** Project Duration:
** Estimated 1-2 Months (Project-based)
We are an aviation manufacturing company seeking a highly skilled
** Manufacturing Systems & ERP Data Specialist
** for a critical data extraction, migration, and validation project. We are transitioning away from our legacy
** Quantum Control ERP
** system and require an expert to manage the end-to-end extraction, cleansing, and verification of our historical enterprise data. The primary focus of this role is data integrity; you will ensure all legacy data is fully extracted from the backend schema and rigorously validated before ingestion into our new environment.
*
* Note:

** This is not an application development role but will require deep backend database expertise and structural data auditing.
** Core Responsibilities
** Data Extraction:
Navigate and query the backend Quantum Control database schema (Oracle/Firebird) to extract complex relational tables, historical transactions, and master data.

Data Validation & Quality Assurance:
Design and execute validation frameworks, reconciliation scripts, and checksums to ensure zero data loss or corruption during export.

Transformation & Staging:
Cleanse, format, and map the extracted legacy data into flat files (CSVs) or a staging environment, maintaining strict relational integrity.

Discrepancy Resolution:
Identify, document, and fix data formatting issues, orphan records, or broken links inherited from the legacy system.

Audit Reporting:
Provide comprehensive validation reports confirming that exported record counts, financial balances, and inventory items perfectly match the legacy system.
** Required

Qualifications & Skills
** Aviation/Industrial ERP Expertise:
Proven experience working with specialized aviation or manufacturing ERP architectures; direct, hands-on knowledge of Quantum Control ERP database schemas is highly preferred.

Database Expertise:
Strong proficiency in advanced SQL and Oracle PL/SQL with a proven track record of reverse-engineering complex, undocumented ERP schemas.

Migration

Experience:

Extensive hands-on experience managing data extraction, data cleansing, and validation for large-scale enterprise system decommissionings.

Analytical Rigor:
Deep background in data reconciliation, audit processes, and building automated data verification routines.

Industry Knowledge (Preferred):
Prior experience handling inventory, serialization, or parts-logistics data structures (experience with Quantum Control or aviation manufacturing ERPs is a major plus).You should be proficient in:

ERP & MRP Systems