Find a job 
Featured Companies 
Featured Universities 
For Companies At a Glance
- Tasks: Support and enhance Oracle OLAP systems while collaborating with Finance and Commercial teams.
- Company: Join a forward-thinking company offering fully remote work in the UK.
- Benefits: 12-month contract, outside IR35, flexible working hours, and opportunities for skill development.
- Why this job: Make a real impact by improving critical analytical platforms and solving complex challenges.
- Qualifications: Experience with OLAP systems and strong analytical skills are essential.
- Other info: Dynamic role with potential for contract extension and career growth.
The predicted salary is between 36000 - 60000 £ per year.
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
Oracle OLAP Consultant employer: Technet IT Recruitment Limited
Contact Detail:
Technet IT Recruitment Limited Recruiting Team
StudySmarter Expert Advice 🤫
We think this is how you could land Oracle OLAP Consultant
✨Tip Number 1
Network like a pro! Reach out to your connections in the finance and analytics sectors. Let them know you're on the lookout for opportunities, especially roles like Oracle OLAP Consultant. You never know who might have a lead or can put in a good word for you.
✨Tip Number 2
Show off your skills! Create a portfolio showcasing your experience with OLAP systems and analytical tools. Include examples of how you've tackled issues with OLAP cubes or improved data models. This will give potential employers a taste of what you can bring to the table.
✨Tip Number 3
Prepare for interviews by brushing up on your technical knowledge. Be ready to discuss your experience with Oracle OLAP and how you've collaborated with finance teams. Practise explaining complex concepts in simple terms, as you'll need to communicate effectively with both technical and non-technical stakeholders.
✨Tip Number 4
Don't forget to apply through our website! We have loads of opportunities that match your skills. Plus, applying directly can sometimes give you an edge over other candidates. So, get your application in and let’s land that job together!
We think you need these skills to ace Oracle OLAP Consultant
Some tips for your application 🫡
Tailor Your CV: Make sure your CV highlights your experience with Oracle OLAP and any relevant analytical tools. We want to see how your skills match the job description, so don’t be shy about showcasing your L1/L2 support experience!
Craft a Compelling Cover Letter: Your cover letter is your chance to shine! Use it to explain why you’re the perfect fit for the role. Mention specific projects or experiences that relate to OLAP development and stakeholder collaboration, as these are key for us.
Showcase Problem-Solving Skills: In your application, highlight examples where you've tackled complex issues in OLAP systems. We love seeing how you approach challenges, especially when it comes to troubleshooting data loads or performance issues.
Apply Through Our Website: Don’t forget to apply through our website! It’s the best way for us to receive your application and ensures you’re considered for the role. Plus, it makes the whole process smoother for everyone involved.
How to prepare for a job interview at Technet IT Recruitment Limited
✨Know Your OLAP Inside Out
Make sure you brush up on your knowledge of Oracle OLAP and Analytical Workspace. Be ready to discuss your experience with OLAP cubes, data loads, and multidimensional data models. The more specific examples you can provide about your past work, the better!
✨Showcase Your Problem-Solving Skills
Prepare to share instances where you've troubleshot issues related to OLAP systems. Think of a couple of challenging scenarios you've faced and how you resolved them. This will demonstrate your analytical capabilities and your ability to communicate effectively with both technical and non-technical stakeholders.
✨Understand the Business Context
Since this role involves working closely with Finance and Commercial teams, it’s crucial to understand their needs. Familiarise yourself with common financial planning workflows and be ready to discuss how your technical skills can support these business objectives.
✨Ask Insightful Questions
Interviews are a two-way street! Prepare some thoughtful questions about the company’s current OLAP systems, ongoing projects, or team dynamics. This shows your genuine interest in the role and helps you gauge if it's the right fit for you.
