Senior OBIEE/OAS Consultant

About the role

We are looking for a Senior OBIEE/OAS Consultant to design, develop and maintain business intelligence solutions using Oracle Business Intelligence Enterprise Edition (OBIEE) and Oracle Analytics Server (OAS). The role involves translating business needs into high‑performing dashboards, reports and data models.

Key responsibilities

• Design, develop and maintain BI dashboards, reports and ad‑hoc queries with OBIEE/OAS.
• Create publisher reports using templates and ensure they meet business requirements.
• Optimize performance of BI reports by tuning the RPD, SQL queries and dashboards.
• Develop data models and subject areas in the OBIEE/OAS repository (physical, business model and presentation layers).
• Manage metadata models to guarantee accurate data representation.
• Monitor, troubleshoot and improve system performance and availability.
• Optimize database queries to reduce response times.

Required profile

• Bachelor's degree in Computer Science or a related field.
• 3+ years of experience as a BI Developer or similar role with OBIEE/OAS.
• Strong expertise in OBIEE/OAS RPD (physical, business model, presentation layers).
• Proficient SQL skills for query writing and performance tuning.
• Familiarity with data integration (ETL) processes and tools.
• Hands‑on experience in data modeling and metadata management.
• Ability to gather business requirements and translate them into technical designs.
• Good knowledge of statistical analysis, data mining and data visualization techniques.
• Excellent English speaking and business writing skills.

Required skills

• OBIEE
• Oracle Analytics Server (OAS)
• RPD (physical, business model, presentation layers)
• SQL
• ETL processes
• Data modeling
• Metadata management
• Statistical analysis
• Data mining
• Data visualization

What we offer

• Fully covered Social & Family Health insurance.
• Great workplace located in Sheraton Heliopolis, Cairo.
• Supportive, collaborative and professional team environment.