Retail Data Architect
About the company
Capital Empresarial Horizonte, a Mexican company specializing in Human Resources and Information Technology, requests:
Your tasks
Retail Data Architect To work in Mexico City (CDMX) - Hybrid Scheme: 3 days on-site and 2 days Home Office. Job Objective: Define the target state data architecture, canonical models, integration flows, and governance principles for business transformation projects with Oracle Retail. The role leads the design of data migration, conversion, reconciliation, cleansing, and archiving to ensure high-volume processing in key Retail domains.
Main Responsibilities
- Define the target state data architecture, canonical data models, data flows, and corporate integration principles.
- Lead source-to-target mapping, migration design, debugging, transformation, reconciliation strategy, and cutover planning.
- Establish and operationalize data quality, governance, security, retention, and audit controls.
- Collaborate directly with functional, technical, integration, reporting teams, and business leaders to resolve key data design decisions.
Requirements
Requirements and Key Information Professional Experience: 10 to 16 years of solid experience in data architecture, modeling, and solution implementation in the Retail industry.
Language: Fluent/advanced conversational English mandatory.
Indispensable Technical Requirements Retail Architecture & Modeling: Solid experience in data architecture and modeling in Retail domains such as: merchandise, inventory, pricing, invoice reconciliation, and sales.
Migration, Conversion & Strategy: Experience in the design of data migration, conversion, reconciliation, cleansing, transformation, and archiving solutions for Oracle Retail implementations.
Technical Core & Mass Processing: Advanced mastery of Oracle Database, SQL, and PL/SQL, data quality controls, and processing of large data volumes.
Oracle Retail Interfaces & Integrations: Deep understanding of Oracle Retail interfaces, RICS / RIB (Retail Integration Cloud Service / Retail Integration Bus), batch processing, and upstream/downstream data flows.
Desirable Knowledge
- Hands-on experience with Oracle Retail SaaS Cloud and Oracle Cloud Infrastructure (OCI) infrastructure.
- Knowledge of Oracle Integration Cloud (OIC), RESTful APIs, data integration platforms, and reporting solutions.
- Formal experience in Data Governance, metadata, data lineage, information security, and Master Data Management (MDM).
- Handling of reconciliation frameworks and performance optimization/tuning.
Requirements Minimum education: Higher education - Bachelor's Degree
10 years of experience Languages: English
Knowledge: Oracle, Human resources
What we offer
Competitive salary: Open to negotiation according to the experience and technical level provided.
100% Payroll scheme.
Statutory benefits.
Benefits above the law (Family Major Medical Expenses Insurance, Life Insurance for $1,000,000 MXN, Grocery Vouchers, 30 days of Aguinaldo, PTU).
Other
Office Hours Monday to Friday.
Hybrid Modality (3 days in office and 2 days of Home Office).