Data Modeler

Purpose:

Model, design and implement advanced Data Warehouse database schema designs, such as star and snowflake schemas, and constellations to support project requirements.

Job Function:

Review data architectures and designs of source application systems and the target Data Warehouse /Marts Manage and maintain a data warehouse environment, including delta load processing and designing Metadata constructs. Advocate data quality and the necessity of clean and accurate data to ensure Business Metric integrity. Participate in the development and documentation of standards within the department, especially technical standards, and be able to clearly communicate those standards. Assist in determining and identifying risks in existing and/or proposed reporting database and data warehouse/mart designs. Actively work with customer representatives to determine analytical reporting needs, perform data analysis tasks and troubleshoot complex problems and propose optimal resolutions. Responsible for recommending optimal data warehouse / mart schema designs.

Basic Qualification:

Experience with dimensional data modeling at an enterprise level. Expert level experience in ERWin 4.x data modeling Expert knowledge of Kimball and Inmon methodologies Experience and/or working knowledge of SAP, Oracle, SQL Server, DB2 and UDB 9.x. Familiarity with, DB2 Connect & UNIX AIX Scripting preferred Familiarity with Informatica and cognos

Additional Information:

At least four (5) years experience in data warehouse data modeling on an enterprise scale is required. The candidate must be a self-starter with excellent decision-making, problem solving, and technical writing skills, and be able to work independently while maintaining good communication with co-workers for team oriented approaches.

Expert level experience in ERWin 4.x data modeling

Long term contract.