Oracle ADW Architect/Lead

Discipline: Data Platforms, Data Management, Data & Analytics
Job type: Contract
Job ref: 32532
Published: 17 days ago

Contract: 6 months (extendable)

Start: ASAP

Location: Remote

Job Title: Oracle Data Architect (ADW, OAC, FAW with Oracle Fusion ERP Experience)

Job Description:

  • We are seeking a highly skilled Oracle Data Architect with comprehensive experience in Oracle Autonomous Data Warehouse (ADW),  Oracle Analytics Cloud (OAC) ,  Fusion Analytics Warehouse (FAW) , and  Oracle Fusion ERP .
  • The candidate will play a critical role in designing and implementing scalable, high-performance data architecture that supports advanced analytics and reporting solutions for the organization.

 Key Responsibilities:  

  • Lead the end-to-end design of data warehouse solutions on Oracle Autonomous Data Warehouse (ADW) to ensure optimal storage, performance, and scalability for enterprise-level analytics.
  • Architect comprehensive business intelligence solutions using Oracle Analytics Cloud (OAC) and Fusion Analytics Warehouse (FAW) to enable advanced data visualization, reporting, and self-service analytics.
  • Collaborate with key stakeholders to integrate Oracle Fusion ERP data into FAW and OAC for deeper insights and data-driven decision-making.
  • Design and implement logical and physical data models that support enterprise reporting needs, ensuring efficient querying, and reporting in ADW.
  • Lead the development of data pipelines and ETL processes, leveraging Oracle Data Integrator (ODI) and other tools to ingest and transform data from multiple sources into ADW.
  • Optimize database queries, ETL processes, and analytics dashboards to ensure fast, responsive data access and reporting.
  • Implement and enforce data governance policies to ensure data integrity, quality, and security across ADW, OAC, and FAW environments, ensuring compliance with industry standards.
  • Work closely with cross-functional teams, including business stakeholders, technical teams, and senior leadership, to gather requirements and translate them into scalable data architecture solutions.
  • Ensure high availability, disaster recovery, and security compliance within Oracle Cloud Infrastructure (OCI) for all deployed solutions.
  • Develop self-service analytics capabilities and empower business users to perform ad-hoc reporting and analytics through OAC. 

Required Skills and Qualifications:  

  • 12+ years of experience in data architecture, data warehousing, business intelligence, and analytics.
  • Hands-on experience with  Oracle Autonomous Data Warehouse (ADW) ,  Oracle Analytics Cloud (OAC) , and  Fusion Analytics Warehouse (FAW) .
  • Strong knowledge of Oracle Fusion ERP and experience integrating Fusion ERP data with ADW and FAW.
  • Expertise in SQL, PL/SQL, and advanced data modeling techniques. - Experience with ETL tools like Oracle Data Integrator (ODI) or similar platforms for data integration.
  • Solid understanding of data governance, security standards, and compliance protocols.  Proven track record of performance tuning and optimization of large-scale data solutions. 
  • Familiarity with Oracle Cloud Infrastructure (OCI), including high availability and disaster recovery best practices.
  • Strong communication, leadership, and collaboration skills with the ability to manage cross-functional teams and engage with business stakeholders.
  • Proven ability to design and deliver scalable analytics solutions that meet complex business requirements.