Description
DATA MODELER
50-60/HR W2
Houston, TX
3-6 month contract
GC
No third party resumes
Major fortune 500 company is seeking a highly skilled and motivated Data Modeler analyst with logical and physical modelling skills in Datawarehouse.
Responsibilities:
Develop the logical and physical design of an emerging Datawarehouse environment using dimensional modelling best practices.
Performing complex data analysis in support of the ad-hoc customer requests and analysing, reporting, and developing recommendations on data.
Requirements:
10+yrs of experience as a Data Modeler with involvement in multiple data warehousing and or Business Intelligence reporting services.
Experience with analysing large volumes of data using a structure methodology.
Proven expertise completing deliverables such as data models, data flow diagrams, data value maps with minimal supervision.
Strong analytical and communication skills.
Experience working with a range of DBMS and data rehousing tools in different operating environments (oracle, SQL Server, etc.)
Strong hands on ERWIN or ER/Studio experience and a good understanding of Informatica ETL, Essbase, Microstrategy, and the related reporting technologies.
Assist with ETL source target mappings, data consolidation and ensure the data architecture is applied properly.
Experience integrating disparate systems into conformed dimensions.
Extensive experience designing relational and dimensional data models deploying and supporting large, complex Datawarehouse/data marts.
Expert level SQL skills