Oracle ADW Developer

Discipline: Data Platforms, Data Management, Data & Analytics
Job type: Contract
Job ref: 32533
Published: about 2 months ago

Contract: 6 months (extendable)

Start: ASAP

Location: Remote

Job Title:  Senior Oracle Analytics Consultant (ADW, OAC, FAW)
  • Job Description: We are seeking a highly skilled and experienced Senior Oracle Analytics Consultant with extensive experience in ADW, OAC, and FAW.
  • The candidate will be responsible for designing, developing, and implementing data solutions that provide actionable insights and support decision-making across the organization.

Key Responsibilities:  -

  • Lead the design and implementation of data warehouse solutions on Oracle Autonomous Data Warehouse to ensure optimized storage, high performance, and scalability.
  • Architect comprehensive business intelligence and analytics solutions using OAC and Fusion Analytics Warehouse (FAW).
  • Collaborate with business stakeholders to gather requirements and design data models that support reporting and analytics.
  • Data Integration & ETL: - Develop and manage ETL processes using Oracle Data Integrator (ODI) or other relevant tools to ingest data from multiple sources into ADW.
  • Ensure data pipelines are optimized, secure, and performant for large-scale data handling.
  • Build, design, and manage interactive reports and dashboards in OAC, ensuring alignment with business requirements.
  • Implement ad-hoc reporting capabilities and self-service analytics to empower business users.
  • Utilize FAW to provide insights into Oracle Fusion ERP and other operational data, enabling data-driven decision-making.
  • Perform performance tuning for database queries, ETL processes, and analytics dashboards for optimal responsiveness. - Ensure high availability, disaster recovery, and security compliance in ADW and OAC environments.
  • Act as a liaison between technical teams, business stakeholders, and senior management to ensure effective communication of project goals and requirements.
  • Implement and enforce data governance policies to ensure data integrity, security, and quality.
  • Ensure compliance with organizational standards and industry regulations when handling sensitive data.

Required Skills and Qualifications: -

  • 9+ years of experience in data warehousing, business intelligence, and analytics. Hands-on experience with Oracle Autonomous Data Warehouse (ADW).
  • Strong expertise in Oracle Analytics Cloud (OAC) for data visualization, reporting, and analytics.
  • Extensive knowledge of Fusion Analytics Warehouse (FAW), especially in working with Oracle Fusion ERP data.
  • Proficiency in SQL, PL/SQL, and data modeling.
  • Experience with ETL tools like Oracle Data Integrator (ODI) or other data integration platforms.
  • Strong knowledge of data governance, security standards, and compliance.
  • Experience in performance tuning and optimization of large datasets and analytics solutions.
  • Familiarity with cloud technologies and infrastructure, preferably Oracle Cloud Infrastructure (OCI).
  • Excellent communication and leadership skills, with the ability to lead cross-functional teams.
  • Proven ability to collaborate with business users to define and understand reporting requirements and deliver solutions that meet those needs.