Data Modeler

Techiva Inc; West Chester (Chester County); On-site; USD 80,000 - 100,000; Part time

Job summary

Techiva Inc is seeking a skilled data modeler for a 6-month contract position in West Chester, Chester County, United States. The ideal candidate will have 5 – 7 years of data modeling experience, focusing on both logical and physical models, particularly in OLTP systems.

Responsibilities include creating and modifying data models, documenting data mapping, and collaborating with business analysts. Candidates should possess strong communication skills and retail experience is a plus.

Qualifications

• 5 – 7 years in data modeling experience at the logical and physical level.
• Strong focus on OLTP and experience in dimensional modeling is a plus.
• Ability to transform logical data models to physical data models.

Responsibilities

• Create or modify data models within the Product Domain.
• Document data mapping from source to target.
• Work closely with business analysts to translate business requirements.

Skills

Data modeling experience

Good communication skills

Retail experience

Tools

MS SQL Server

Erwin 9.5

Data modeling tools

SQL

Job description

Job Description

Position Summary: The successful candidate will create or modify data models within the Product Domain.

6 month contract position - local candidates only.

Qualifications

• 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; ensuring 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 from source to target.
• Work closely with business analysts 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).

Additional Information

6 month contract position - local candidates only.

All your information will be kept confidential according to EEO guidelines.