IT Professional / DATA WAREHOUSING SPECIALIST / Business Intelligence/Data Warehouse/Modeling/SAS (092612-RA RA-IO32-E)

 

Location: NEW YORK

Contract

 

As a Data Warehouse Modeler, the candidate will be part of a team responsible for the detailed design of a financial data warehouse supporting corporate consolidation, regulatory filing, tax compliance and financial planning and analysis. The output will be a logical model and the entities and attributes required to implement the data warehouse. " Model the reference data and meta data supporting the warehouse. " Attribute the dimensions defined by the requirements phase. " Model the staging layer receiving data from at least three major subsidiaries. " Model the aggregation layer supporting reporting requirements and the major applications. " Model the application specific star schemas as subject areas within the data warehouse. Technical requirements " Strong E/Rwin modeling skills. Workgroup release 8 is preferred. " Experience using subject areas, dimension analysis and naming standards to organize models and keep them understandable is crucial. " Experience in data exchange with E/Rwin through the Bulk Editor is required. Import and export from the IBM Information Workbench is preferred. " Experience in using the team functions such as merging models and resolving relationship conflicts is required. " Familiarity with SAP BI terms such as DSO, Information Source, Characteristic and their definition of Meta Data is desirable.

 

You do not have to have experience in building a SAP BI warehouse, but you have to be able to talk to SAP BI developers. " Familiarity with the IBM Business Glossary is desirable. General requirements " The ability to work with business analysts and more technical business users to discover the full attribute set for entities and dimensions is required. " The ability to work with business analysts and report developers to find the right data in the model is required. " The ability to document decisions made in meetings and alternative solutions discussed is required.

--------------------------------------------------------------------------------------------------------------------------------------------------

Jeeva, Desk: 703-880-9800, iOrmyx Inc, Mailto: jeevav@iormyx.com, Website: http://www.iormyx.com