Manufacturing Systems & ERP Data Specialist (Aviation)

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.

• 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