Description

You will lead the analysis and modeling of legacy Oracle database schemas to support warehouse management system modernization.

Responsibilities

• Analyze existing Oracle DB schemas and data structures within legacy CatalystPro systems.
• Identify and document data domains, entities, and relationships across inventory, order management, shipping, and receiving functions.
• Map business functions to database modules and tables in collaboration with SMEs and engineering teams.
• Define data modularization strategies and logical domain boundaries to support service decomposition.
• Create ER models, data flow diagrams, and entity maps to guide modernization planning.
• Propose and validate data migration strategies from legacy systems to modern WMS platforms.
• Partner with architects to ensure a clean separation of concerns within modular architectures.

Required Skills

• 8+ years of experience in data analysis or data modeling.
• Strong expertise in Oracle DB, including PL/SQL, schema design, and data profiling.
• Proven experience working with WMS, Supply Chain, or Logistics systems.
• Experience analyzing legacy monolith systems and supporting decomposition initiatives.
• Familiarity with Domain-Driven Design (DDD) and microservices architecture principles.
• Ability to design data migration and integration reconciliation plans.

Preferred Skills

• Experience with GCP or on-premise WMS platform migrations.

Key Skills

Education

Any Gradute