Oracle Retail Insights Analytics Engineer

Overview

Remote
Up to $80,000
Full Time

Skills

Oracle AND Retail AND "BI" AND Warehouse AND (RICS OR "Oracle Retail Insights Cloud Service" OR RDW OR "Oracle Retail Data Warehouse") AND Oracle AND ("PL/SQL" OR "PLSQL" OR "PL-SQL" OR "PL SQL") AND Security AND (OCI OR ODI OR OAC OR "Oracle Analytics Cloud")

Job Details

Role: Oracle Retail Insights Analytics Engineer

Location: Remote

Contract

Oracle Retail Insights Analytics Engineer

Role Summary

We are seeking a highly experienced and hands-on Analytics Engineer to lead the design, implementation, and optimization of our reporting and business intelligence solutions using Oracle Retail Insights Cloud Service (RICS). The ideal candidate will bridge the gap between business needs (Merchandising, Inventory, Finance) and technical execution, translating complex retail data requirements into scalable and high-performance analytical solutions within the Oracle Cloud Infrastructure (OCI) ecosystem. This role is central to driving data-driven decision-making across our retail enterprise.

Key Responsibilities

  • Lead the implementation and configuration of Oracle Retail Insights Cloud Service solutions.
  • Work closely with business stakeholders to gather requirements and translate them into scalable analytics solutions.Design, develop, and optimize dashboards, reports, and KPIs to support decision-making across retail operations.Ensure integration between ORICS and other Oracle Retail applications (e.g., RMS, ReIM, Allocations, Merchandising).
  • Provide technical leadership in data modeling, ETL processes, and performance tuning for retail insights.Collaborate with cross-functional teams including business analysts, developers, and data engineers. Support production deployment, troubleshooting, and performance optimization.

Required Skills & Qualifications

  • 5+ years of hands-on experience in Oracle Retail Insights or related Oracle Retail Analytics platforms.Strong knowledge of Oracle Retail suite (Merchandising, Pricing, ReIM, Allocation).
  • Hands-on expertise with Oracle Analytics Cloud (OAC) or OBIEE for reporting and visualization.
  • Proficiency in SQL, PL/SQL, and data modeling.Experience with cloud-based data integration and ETL pipelines.Strong problem-solving and analytical skills with ability to translate business requirements into technical solutions.Excellent communication and collaboration skills.

Required Technical Skills

  • 15+ years of experience in Business Intelligence, Data Warehousing, or Analytics Engineering, with a focus on the retail industry.
  • 5+ years of hands-on, end-to-end implementation experience with Oracle Retail Insights Cloud Service (RICS) or previous versions of Oracle Retail Data Warehouse (RDW)/Retail Insights.
  • Expert-level proficiency in Oracle SQL and PL/SQL for data analysis, complex query writing, and procedural development.
  • In-depth experience with the Oracle Analytics Cloud (OAC) platform, specifically RPD modeling, creating Data Visualizations (DV), and managing the Presentation layer.
  • Proven experience with data integration tools used in the Oracle Retail ecosystem (e.g., Oracle Data Integrator/ODI, OCI Data Integration).
  • Solid understanding of the data model and business process flows for core Oracle Retail applications (e.g., RMFCS/RMS, RPAS, Allocation).
  • Experience implementing security and data governance standards, including role-based access control and Row-Level Security (RLS) within OAC/RICS.

Preferred Qualifications

  • Bachelor s or Master s degree in Computer Science, Information Systems, or a related technical field.
  • Experience with Oracle AI Foundation Cloud Service and leveraging embedded AI/ML models for retail use cases (e.g., demand forecasting).
  • Familiarity with OCI services related to analytics (e.g., Autonomous Data Warehouse, OCI Object Storage).
  • Experience with other retail BI tools (e.g., Power BI, Tableau) for supplemental visualization needs.

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.