Data Modeler

Techiva is a leading information technology consulting firm helping clients realize the real benefits of technology. We deliver business-driven technology solutions that enable our clients to gain competitive advantage and reduce information technology costs. Visit us  at www.techiva.com to learn more about our capabilities. Position Summary: The successful candidate will create or modify data models within the Product Domain. 6 month contract position - local candidates only Required Skills and Experience: •5 – 7 years in data modeling experience - at the logical and physical level, with a strong focus on OLTP. Dimensional modeling experience is a plus. •Understanding of normalization of entities and tables; ensure use of proper constraints, naming standards, data types & lengths. •Transform logical data model to physical data model. •Generate DDL from physical data model for database implementation. •Document data mapping - source to target. •Work closely with business analyst(s) and IT resources to decipher business requirements and translate them to a logical data model.  •Good communication skills - able to explain and walk through design concepts to various resources (business, application development, management) •Retail experience Required Technologies: OLTP RDBMs (MS SQL Server), Data modeling tools (Erwin 9.5 and Model Mart), Experience with GS1, Proficient with writing SQL Optional Technologies: OLTP RDBMs (DB2, Oracle v10g), OLAP (Teradata, Netezza), Data warehouse schemas (Star, Snowflake), dimensional data modeling, SQL Tools (AQT, SQL Navigator) 6 month contract position - local candidates only All your information will be kept confidential according to EEO guidelines.