Teradata Data Modeler

Job Description

The Data Modeler is responsible for transforming business information into logical data models and managing the enterprise data model.

The Data Modeler is proficient in industry standard techniques for process modeling and data modeling. The Data modeler designs, implements, and documents data architecture and data modeling solutions, which include the use of relational, dimensional, and NoSQL databases. Within data modeling, the Data Modeler must be proficient in 3rd normal form relational modeling as well as dimensional modeling. Experience with alternate modeling techniques such as Data Vault, and key modeling as it relates to Big Data would be a strong added value.

A Data Modeler understands semantic modeling requirements and concepts, and when working with associated Teradata Consultants, can design and document semantic models that are required for specific applications. The Data Modeler is also familiar with new and emerging data which contributes to behavioral or interaction data. This may include modeling for documents, XML, JSON, meta tags (audio, video, pictures) and others.

Key Areas of Responsibility

• Analyze and translate business needs into long term solution data models.
• Design and normalize the logical data model to third normal form.
• Facilitate the discovery of entities, attributes, relationships, and business rules from the functional experts and the user community.
• Prepare fully refined data models in accordance with the guidelines/conventions of Integration Definition (IDEF) or equivalent methodology.
• Work with all related consultants to design and document semantic models.
• Work closely with Data Architects to translate LDMs and Semantic Models into their physical representations.
• Work with ETL consultants to map source system data to Teradata physical models.
• Maintain and publish project business rules and the associated enterprise data dictionary.
• Evaluate access paths for data which spans multiple deployed technologies; provide recommendations for optimizations in accessing these heterogeneous relationships.
• Work within Teradata Solutions and Applications.