Description

You will design, model, and optimize Oracle BI Enterprise Edition (OBIEE) solutions, owning the architecture from data modeling to dashboard delivery.

This role is on-site.

Responsibilities

• Design OBIEE RPD models, converting snowflake schemas to star schemas and configuring dimensional hierarchies.
• Define and manage OBIEE architecture components including the Analytic Server, Web Server, Web Catalog, Security, and Scheduler.
• Write and profile complex PL/SQL and SQL queries against SQL Server to efficiently extract data from large datasets.
• Configure OBIEE features such as caching, usage tracking, variables, initialization blocks, and performance tuning.
• Collaborate with teams to grasp business requirements and deliver accurate reports, dashboards, and iBots.

Required Skills

• 6-10 years of experience with OBIEE RPD modeling and architecture.
• Deep understanding of OBIEE components: Analytic Server, Web Server, RPD, Web Catalog, Security, and Scheduler.
• Proficiency in writing complex PL/SQL queries and SQL Server performance tuning.
• Experience with physical and logical data modeling, including snowflake to star schema conversion.
• Knowledge of ETL tools, preferably SSIS.
• Proficiency with Oracle Database tools like TOAD and SQL Plus.
• Bachelor’s degree in Computer Science, Information Systems, or related field.

Preferred Skills

• Experience in Supply Chain or Warehouse Management domains.
• Strong interpersonal and communication skills for independent or team-based work.

Key Skills

Education

Any Graduate