Oracle Retail Canonical Data Model Consultant

Themesoft Inc; Stati Uniti; Remoto; USD 120.000 - 180.000; Tempo pieno

Descrizione del lavoro

The Oracle Retail Canonical Data Model Architect role at Themesoft Inc is remote and focused on leading end-to-end canonical data modeling for Oracle Retail entities. You will collaborate with Catalyst architects and business stakeholders to define attributes, hierarchies, and rules, translating requirements into normalized, versioned schemas.

You will establish crosswalks, manage schema lifecycles, enforce backward compatibility in the schema registry, drive reviews with Catalyst leadership,

Competenze

• Experience designing canonical data models for enterprise systems.
• Proven ability to manage schema versions and backward compatibility.
• Experience with data governance frameworks and docs.
• Hands-on with ingestion pipelines and Kafka schema registry.
• Ability to collaborate with architects and stakeholders.

Mansioni

• 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.

Conoscenze

Data modeling

Schema management

Data governance

Data integration

Stakeholder collaboration

Descrizione del lavoro

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 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
• Catalyst leadership and governance stakeholders

Work Authorization

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

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.