OBIEE Technical Lead or Architect

Shrive Technologies LLC • Miami, FL

17d • $60 - $60 • Onsite

About The Position

We are seeking an experienced OBIEE Technical Lead or Architect with specialization in Supply Chain, Warehouse Management, and Distribution domains. The role requires a deep understanding of Oracle BI (OBIEE) architecture and its components, along with strong database and PL/SQL skills. The ideal candidate will be responsible for designing and implementing OBIEE solutions, optimizing performance, and ensuring efficient data retrieval. This is an onsite position in Miami, FL.

Requirements

• Bachelor’s Degree or equivalent in Computer Science, Information Systems, or related field.
• 6-10 years of relevant experience.
• Specialization in Supply Chain, Warehouse Management, and Distribution domains.
• Expertise in Oracle BI - OBIEE.
• Proficiency with Oracle Database tools like TOAD, SQL Plus, and Oracle Tools.
• Experience in OBIEE RPD modeling and designing start/snowflake schemas.
• Thorough understanding of OBIEE architecture and components (Analytic Server, Web Server, RPD, Web Catalog, Security, Dashboards, Reports, iBots, Scheduler).
• Experience in writing and profiling complex PL/SQL queries and fetching data efficiently from huge datasets (SQL Server).
• Experience with OBIEE Features (Cache, Usage tracking, Dimensional hierarchy, Variables/Initialization Blocks configuration etc.).
• Experience converting Snow-Flake Schema to Star Schema, Dim Hierarchies, Dim Extensions, and Physical & Logical Data Modeling.
• Knowledge and experience in Performance tuning.
• Good communication and interpersonal skills.
• Ability to quickly grasp new technical and business concepts.
• Flexibility to work independently or in a team environment.

Nice To Haves

• Basic knowledge in ETL tools (Preferably SSIS).

Responsibilities

• Design and develop OBIEE solutions, including RPD modeling and dashboard creation.
• Understand and utilize various OBIEE components such as Analytic Server, Web Server, RPD, Web Catalog, Security, Dashboards, Reports, iBots, and Scheduler.
• Write and profile complex PL/SQL queries for efficient data retrieval from large datasets.
• Configure OBIEE features including Cache, Usage tracking, Dimensional hierarchy, and Variables/Initialization Blocks.
• Convert Snow-Flake Schemas to Star Schemas, manage Dim Hierarchies, Dim Extensions, and perform Physical & Logical Data Modeling.
• Perform performance tuning for OBIEE and database queries.
• Collaborate with technical and business teams, and work effectively independently or in a team environment.

What This Job Offers

• Job Type: Full-time
• Career Level: Senior