Data Warehouse Consultant

This resource will be responsible for developing the Gas Distribution Work Productivity and Work Completion Crystal Reports from specifications developed by the Project Team.

 

Scope of Work: 

*  Create detailed design from business requirements, logical data model, and data mapping. 

*  Build Supply Chain Data Warehouse (tables and Data Mart) using ETL tool.

 

Position Requirements: 

*  Experience in Data Warehousing, data modeling (logical and physical), and use of an ETL tool such as DataStage. 

*  Requires strong experience in both Crystal Report writing and Oracle PL/SQL programming - 6+ years. 

*  Skills necessary to program table views / dimension tables as required by the reports.

*  The ability to write complex Crystal Reports from medium level specs (defined data source, defined tables, report prototypes, ability to work with business users). 

*  Previous work in a data warehouse is a plus.