Be aware of scams on social media involving phony job postings. Learn more


Data Modeler

Location: Taipei, Taiwan

Notice

This position is no longer open.

Requisition Number: 208141

External Description:

DATA MODELER

Job Summary:

The Physical Data Modeler is responsible for the design and instantiation of the physical data model based on the logical data model. This includes creating the base tables, associative tables, views, the semantic layer, and choosing and creating all indexes. The Physical Data Modeler uses input from the Business Information Modeler, the Application Consultant, the Business Intelligence Consultant, the Database Administrator, and the ETL Consultant. This Physical Data Modeler must have the skills to understand the logical data model as well as the business requirements. The Physical Data Modeler may be the Project Tech Lead on a project.

 

Key Areas of Responsibility:

  • Create the physical data model with a data modeling tool like ERwin, PowerDesigner, etc.
  • Modify the physical data model for efficient data access paths.
  • Generate and execute DDL to create databases, tables, views, and the semantic layer.
  • Identify and create primary indexes, partitioned primary indexes, secondary indexes, join indexes, and all other needed indexes.
  • Identify statistics columns, and create and execute collect statistics statements.
  • Identify, define, and create necessary associative tables, data constraints, and compression mechanisms.
  • Recommend and establish standards, guidelines, and procedures for design and maintenance.

 

Required Skills:

  • Bachelor’s Science Degree or equivalent
  • At least 10 years relevant experience
  • Experience in ERwin data modeling tool
  • Experience in enterprise data warehouse (EDW)
  • Experience in Banking or Manufacturing or Retail industry
  • Experience in working on large projects ( at least 20 people)
  • Good communication skills in Mandarin and English

CountryEEOText_Description: Why We Think You’ll Love Teradata We prioritize a people-first culture because we know our people are at the very heart of our success. We embrace a flexible work model because we trust our people to make decisions about how, when, and where they work. We focus on well-being because we care about our people and their ability to thrive both personally and professionally. We are an anti-racist company because our dedication to Diversity, Equity, and Inclusion is more than a statement. It is a deep commitment to doing the work to foster an equitable environment that celebrates people for all of who they are.

City: Taipei

State: Taipei

Community / Marketing Title: Data Modeler

Job Category: Consulting

Company Profile:

Our Company

At Teradata, we believe that people thrive when empowered with better information. That’s why we built the most complete cloud analytics and data platform for AI. By delivering harmonized data, trusted AI, and faster innovation, we uplift and empower our customers—and our customers’ customers—to make better, more confident decisions. The world’s top companies across every major industry trust Teradata to improve business performance, enrich customer experiences, and fully integrate data across the enterprise.

LinkedIn Remote:

Location_formattedLocationLong: Taipei, Taipei TW

.