New York, NY

Responsibilities :

Translate business analyst requirements into analytics metadata

Move data into the data warehouse for report unit testing

Design & Develop BI Physical Data Model

Determine requirements for aggregate tables, hierarchies, level based measures, etc.

Design and development of the Logical Data Model (Business Model), metadata and reports including logical columns, alias, hierarchies, and subject areas

Determine whether calculations and processing should be done in BI application or the ETL process

 

Required Skills :

Working Experience with OBIEE 11g (prefer 11.1.1.7 +)

Understanding of Business Analysis for dimensional data models

Understanding of Oracle E-Business Suite/Hyperion source system data models

Knowledge of Oracle Database Performance Tuning

Knowledge of Oracle Business Intelligence Applications 7.9.6.3+ (Required in Project Accounting, Supply Chain, Financials)

Experience with Data Warehousing Modeling concepts

Experience with pixel perfect reports in OBIEE Business Intelligence Publisher (BIP)

Years of Experience with OBIEE 11g: 5 to 7 years

Years of Experience with business intelligence solutions: 3 years

 

Preferred Skills :

Knowledge of Oracle Business Intelligence Applications 7.9.6.4 a plus

Experience with OBIEE and OBIA upgrades a plus