OBIEE Developer

The Dotcom Team; Miami (FL); On-site; USD 110,000 - 160,000; Full time

Job summary

The Dotcom Team in Miami seeks an experienced OBIEE specialist to design and optimize BI solutions. You will model star and snowflake schemas, implement OLAP reporting, and ensure efficient data extraction from large Oracle datasets.

Applicants should have deep knowledge of OBIEE components, PL/SQL profiling, and data warehousing best practices. Strong communication and teamwork skills are essential for collaborating with business stakeholders.

Qualifications

• OBIEE architecture understanding and component roles (Analytic Server, Web Server, RPD, Web Catalog).
• Ability to write and profile complex PL/SQL queries for large data sets.
• Experience converting Snow-Flake schema to Star schema and performing dimensional modeling.

Skills

OBIEE expertise

PL/SQL proficiency

Data modeling

SQL performance tuning

Communication skills

Tools

TOAD

SQL Plus

Oracle tools

Job description

Job Requirements

• Experience in OBIEE RPD modeling, designing start/snowflake schemas
• OBIEE Expert with a thorough understanding of OBIEE architecture and the role of different OBIEE components like Analytic Server, Web Server, RPD, Web Catalog, Security, Dashboards, Reports, iBots and Scheduler
• Experience in writing and profiling complex PL/SQL queries and fetch appropriate data from huge data sets efficiently (Oracle)
• Experience in OBIEE Features (i.e. Cache, Usage tracking, Dimensional hierarchy, Variables/Initialization Blocks configuration etc.), converting Snow-Flake Schema to Star Schema, Dim Hierarchies, Dim Extensions, and Physical & Logical Data Modeling.
• Possess good communication, interpersonal skills, an ability to quickly grasp new concepts- both technical and business related. Flexible and experienced to work independently or in a team environment.
• Specialization Domains: Supply Chain, Warehouse Management Distribution
• Technologies: Oracle BI - OBIEE, Oracle Database tools like TOAD, SQL Plus and Oracle tools , Exposure to S4HANA