Oracle OLAP Consultant

Oracle OLAP Consultant
12 month Contract (extendable), Outside IR35, Fully remote role (UK)

My client is seeking an experienced L1/L2 Support & Development Analyst with strong expertise in Oracle OLAP Option/Oracle Analytical Workspace (AW). The role focuses on supporting and enhancing business-critical analytical and planning platforms used by Finance and Commercial stakeholders. This is a hands-on role combining application support, OLAP development, and stakeholder collaboration.

Key Responsibilities

• Provide L1/L2 application support for Oracle-based analytical and OLAP systems
• Troubleshoot issues related to OLAP cubes, data loads, calculations, and hierarchies
• Develop, enhance, and maintain OLAP DML scripts
• Support and improve multidimensional data models and analytical reports
• Investigate and resolve performance and data quality issues
• Work closely with Finance and Commercial teams to understand business requirements
• Assist with ongoing enhancements and minor development initiatives
• Support BAU operations of enterprise reporting and planning solutions

Essential Skills & Experience

• Proven experience supporting an OLAP-based reporting or planning system, such as: Oracle OLAP/Analytical Workspace, Essbase, TM1, Board, MS SSAS, Tableau, SAP BW/BW/4HANA
• Strong understanding of multidimensional concepts, including: Hierarchies and dimensional modelling. Time-series data. Aggregation paths and calculation logic. FP&A or planning workflows
• Background in application or production support, strong analytical and problem-solving capability and the ability to communicate clearly with both technical and non-technical stakeholders

Desirable/Nice to Have

• Oracle Express/Oracle OLAP Option
• OLAP DML development experience
• Exposure to OFA/OSA (Oracle Financial Analyzer/Oracle Sales Analyzer)
• VBA for Excel
• Oracle SQL/PL/SQL
• Understanding of Finance or Sales data domains
• Experience with Oracle Analytical Views