Data Modeler

Posted Yesterday
Be an Early Applicant
West Chester, PA, USA
In-Office
Senior level
Cloud • Information Technology • Consulting • Cybersecurity
The Role
Create and modify logical and physical data models for product-domain systems, primarily using OLTP relational databases. Responsibilities include normalization, constraints, naming standards, data types, DDL generation, source-to-target mapping, and translating business requirements into data models. The role collaborates with business analysts, developers, and management, documents design concepts, and requires retail experience. This is a six-month contract for local candidates.
Summary Generated by Built In
Company Description

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 Description

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

6 month contract position - local candidates only

Qualifications

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)

Additional Information

6 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
Am I A Good Fit?
beta
Get Personalized Job Insights.
Our AI-powered fit analysis compares your resume with a job listing so you know if your skills & experience align.

The Company
4 Employees
Year Founded: 2006

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.

Similar Jobs

Cognizant Microsoft Business Group Logo Cognizant Microsoft Business Group

Data Modeler

Cloud • Information Technology
In-Office
Philadelphia, PA, USA
580 Employees

Atria Group LLC Logo Atria Group LLC

Sr. Data Modeler

Information Technology • Professional Services • Software • Consulting
In-Office
Philadelphia, PA, USA
125 Employees

Atria Group LLC Logo Atria Group LLC

Data Architect

Information Technology • Professional Services • Software • Consulting
In-Office
Pittsburgh, PA, USA
125 Employees

Lowe’s Logo Lowe’s

Full Time - Sales Associate - Inside Lawn & Garden - Opening

Consumer Web • eCommerce • Information Technology • Retail • Software • Analytics • App development
Hybrid
Warrington, PA, USA
300000 Employees

Similar Companies Hiring

NODA AI Thumbnail
Artificial Intelligence • Information Technology • Software • Cybersecurity • Defense • Defense Technology
Austin, TX
54 Employees
Golden Pet Brands Thumbnail
Digital Media • eCommerce • Information Technology • Marketing Tech • Pet • Retail • Social Media
El Segundo, California
567 Employees
RapidScale Thumbnail
Cloud • Information Technology • Consulting
Raleigh, NC
600 Employees

Sign up now Access later

Create Free Account

Please log in or sign up to report this job.

Create Free Account