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.