Oracle Retail Canonical Data Model Consultant

Job Title: Oracle Retail Canonical Data Model Architect

Location: Remote

Role Description

• Lead the end-to-end design of canonical, system-agnostic data models for core Oracle Retail entities.
• Collaborate with Catalyst architects and business stakeholders to define entity attributes, hierarchies, and business rules, translating requirements into normalized, versioned schemas.
• Establish crosswalk and ID-mapping strategies between source RMS systems and canonical keys, including schema versioning and change-management standards.
• Define and manage the schema contract lifecycle, publishing canonical schemas to a schema registry while ensuring backward compatibility across consuming applications.
• Drive schema reviews and formal sign-offs with Catalyst leadership, maintaining data dictionaries and governance documentation.
• Partner with integration engineering teams to implement canonical models across RMS-to-Kafka ingestion and transformation pipelines, ensuring schema-registry enforcement and versioning at publish time.

Required Skills

1. Data Modeling

• Canonical and system-agnostic data models
• Normalized and versioned schemas
• Entity attributes, hierarchies, and business rules

2. Schema Management

• Schema versioning and change management
• Schema contract lifecycle management
• Schema registry and backward compatibility
• Schema reviews and documentation

3. Data Governance

• Data dictionary and governance documentation
• Formal review and sign-off processes

4. Data Integration

• Crosswalk and ID-mapping strategies
• Oracle Retail RMS integration
• Ingestion and transformation pipelines
• Apache Kafka topics and schema-registry enforcement

5. Stakeholder Collaboration

• Catalyst architects and business stakeholders
• Integration engineering teams
• Catalyst leadership and governance stakeholders

Work Authorization

Applicants must be legally authorized to work in the United States.

Equal Employment Opportunity

Themesoft Inc is an Equal Employment Opportunity employer. We consider qualified applicants without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, age, disability, veteran status, or any other status protected by applicable federal, state, or local law.