Job Description :
Jr. BI Developer
Portland, OR
5 month contract
Need OPT, GC-EAD, GC & US Citizens
Has to be work our W2
RESPONSIBILITIES:
Responsible for developing new and enhancing existing Reports and Dashboards in OBIEE using presentation features including drill-down / dynamics, cascading style sheets, pivot tables, visualizations and tabular reports with local and global filters.
Responsible for creating, configuring, customizing and maintaining repository design to support custom subject areas and modifications to existing Oracle BI applications.
Responsible for ETL design and development for a consolidated reporting solution that integrates enterprise system data
Responsible for end user support, break/fix and enhancements to existing enterprise data warehouse solutions
Support OBIA/OBIEE and source system data extract technologies including the resolution of performance issues and the development of new dashboards, reports, and metrics
Other BI functional and technical support, as required.
REQUIRED:
Experience implementing enterprise-scale Business Intelligence (BI) systems with an understanding and ability to apply leading practice design principles to BI projects.
Experience in OBIEE, developing Reports and Dashboards with multiple views using presentation features; including drill-down / dynamics, cascading style sheets, pivot tables, visualizations and tabular with local and global filters.
Experience in OBIEE creating, configuring, customizing and maintaining repository design to support custom subject areas and modifications to out of the box Oracle BI applications.
Experience in Extraction, Transformation, Loading (ETL) data from various sources into data warehouses and data marts using Informatica Power Center (Repository Manager, Designer, Workflow Manager, Workflow Monitor, Metadata Manger), Power Exchange and Power Connect.
Experience with the Data Warehouse Administration Console (DAC) to configure, manage and load the Oracle Business Analytics Warehouse.
Custom data warehouse design experience using Star Schema/Snowflake modelling, OLAP/ROLAP tools, Fact and Dimensions tables, Physical and logical data modelling, and Oracle Designer.
Good verbal and written skills with the ability to connect and educate client’s technical team with regard to BI topics and future design vision.
PREFERRED:
Familiarity with PeopleSoft Finance, Supply Chain and HR systems is a plus