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.
Job DescriptionPosition Summary:
The successful candidate will create or modify data models within the Product Domain.
6 month contract position - local candidates only
QualificationsRequired 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)
Additional Information6 month contract position - local candidates only
All your information will be kept confidential according to EEO guidelines.
Skills Required
- 5–7 years of data modeling experience at the logical and physical levels, with strong OLTP experience
- Understanding of entity and table normalization, constraints, naming standards, data types, and field lengths
- Ability to transform logical data models into physical data models
- Ability to generate DDL from physical data models for database implementation
- Experience documenting source-to-target data mappings
- Ability to work with business analysts and IT resources to translate requirements into logical data models
- Strong communication skills for explaining data design concepts to business, development, and management stakeholders
- Retail experience
- Experience with OLTP RDBMS, specifically MS SQL Server
- Experience with Erwin 9.5 and Model Mart
- Experience with GS1
- Proficiency writing SQL
- Experience with DB2 or Oracle 10g
- Experience with OLAP platforms such as Teradata or Netezza
- Experience with star schemas, Snowflake schemas, or dimensional data modeling
- Experience with AQT or SQL Navigator
What We Do
Techiva Inc. is an information technology consulting firm that helps organizations modernize and use technology to improve business outcomes. Its services include technology strategy and advisory, AI and automation, cloud transformation across AWS, Azure and GCP, and cybersecurity, including zero-trust, compliance and threat response. The company combines technical expertise with business strategy and provides tailored roadmaps, implementation guidance and measurable solutions for clients across fintech, healthcare, retail and enterprise.








