Data Warehouse Architect

Description

Alcoa has a need for an OBIEE and Data Warehouse Architect / Developer. This person will act as the data warehouse and metadata architect / developer in the deployment of a new component of their HR Analytics module within Oracles EBS. This new functionality will be for employee Performance Management. They are looking metrics to track how employees are tracting to their performance plans and their mobility to move into different roles. On a day to day basis the duties will include Design of data model for data warehouse (STAR Schema) to support OBIEE application functionality Creation of functional/technical design documents for OBIEE metadata components of the HR Analytics solution Develop the OBIEE metadata layer and assist with OBIEE report and dashboard development. Enhance design of existing OBIEE application with currency and language OBIEE performance tuning. Mentor other resources on the project in this development effort. Below are specific skills being targeted Experience with 3 or more full life cycle data warehouse implementations of custom Oracle Business Intelligence Enterprise Edition (OBIEE) solutions Expert knowledge in dimensional modeling, design and architecture principles and techniques Strong technical and functional knowledge of data warehouse and OBIEE Handson experience with OBIEE metadata development, dashboards development and implementation. Experience with OBIEE on Linux platform Technical experience with Oracle databases, SQL, PL/SQL Working knowledge of HR concepts, and Oracle HRMS or other Oracle applications Experience in database and OBIEE performance tuning with the ability to analyze complex SQL queries Expertise in requirement gathering, understanding business users requirement and convert them in functional/technical specifications