Oracle data warehouse Architect

  • Posted 2 days ago | Updated 2 days ago

Overview

Remote
Depends on Experience
Contract - Independent
Contract - 3 Month(s)

Skills

Oracle Application Express
Oracle Data Integrator
Data Warehouse
Data Warehouse Architecture
SOAP
SQL
Data Modeling
API
Data Architecture

Job Details

We are seeking a highly skilled Data Integration & Governance Architect to lead the design and implementation of robust data pipelines, reconciliation processes, and governance frameworks within our Oracle-based data ecosystem. This role requires deep experience in API integrations, data warehouse architecture, and the development of tools that empower business users with self-service capabilities.

Key Responsibilities:

  • Design and implement API integrations to connect enterprise systems and external data sources.

  • Lead the end-to-end setup of an Oracle data warehouse, including schema design, data modeling, and performance optimization.

  • Build ETL/ELT data pipelines to ingest, transform, and reconcile data across systems with auditability and traceability.

  • Develop and operationalize a data quality and governance layer for automated validation and exception handling.

  • Create and manage editable reference data tables with user-friendly interfaces for business and operations teams.

  • Collaborate with data analysts, engineers, and business stakeholders to ensure data solutions align with organizational goals.

  • Document data architecture, data flows, and system interfaces to ensure transparency and maintainability.

Qualifications:

  • 7+ years of experience in data architecture, integration, or engineering roles.

  • Expertise with Oracle Database, Oracle Data Integrator (ODI) or Oracle Warehouse Builder, and data modeling.

  • Proficiency in building REST/SOAP APIs and integrating with enterprise systems.

  • Strong knowledge of ETL tools, SQL, and Python or Shell scripting for automation.

  • Experience implementing data quality, governance frameworks, and metadata management.

  • Familiarity with data stewardship, user access management, and UI-based editing tools like Oracle APEX or low-code platforms.

  • Strong communication skills with the ability to translate technical requirements into business solutions.

Employers have access to artificial intelligence language tools (“AI”) that help generate and enhance job descriptions and AI may have been used to create this description. The position description has been reviewed for accuracy and Dice believes it to correctly reflect the job opportunity.