#4933 Data Modeler in Dallas, TX at MDI Group

Date Posted: 11/12/2018

Job Snapshot

  • Employee Type:
  • Location:
    Dallas, TX
  • Job Type:
  • Experience:
    At least 8 year(s)
  • Date Posted:

Job Description

Data Modeler
Dallas, TX

What You Will Be Doing: 

  • Facilitate and/or participate in agile sessions to assess, capture, and translate complex business issues and requirements into structured data architecture and data modeling use case requirements
  • Hold conceptual and logical data model reviews with product managers/data subject matter experts
  • Must be able to abstract general principles from specifics and conceptualize and design data model
  • Develop, enhance, and manage conceptual data model, enterprise logical data model (LDM), physical data model (PDM) for the data platform
  • Ensure data lineage mapping across implementations for the platform
  • Understand and meet referential data integrity requirements based on business needs
  • Develop and/or assist in generating source to target data mapping
  • Perform data model consolidation and integration to integrate new silos of organizations source data to the data platform
  • Understand and apply logical entity-relational design concepts
  • Develop dimensional models and views needed for data analytics and reporting
  • Develop and maintain fully defined conceptual, logical and physical dimensional data models to ensure the information models are capable of meeting end user and developer needs
  • Develop data models and data migration strategies utilizing best practice concepts of data modeling including star schema, snowflake schema, etc. 
  • Build model aggregation layers and specific star schemas as subject areas within a logical and physical model


  • Qualified candidate will have a Bachelor’s Degree or 8+ years related job experience
  • Candidate must have experience building and managing enterprise grade data models
  • Experience with relational modeling, domain modeling, and dimensional modeling
  • Experience with metadata management and its use for modeling activities
  • 8+ years' experience with creating data model and data structure in Oracle, SQL Server, PostgreSQL, or other using ER/Studio DA or Erwin Modeling
  • 8+ years of experience using the following modeling techniques: 3rd Normal form, ERD, Dimensional modelling, Time series, MDM data block
  • 8+ years of experience with data management standards and data model practices
  • Thorough knowledge of conceptual and logical data modeling and familiarity with physical database design and optimization concepts
  • Experience with common standards and best practices for data elements, data types, and file formats
  • Ability to conceive and describe the big picture
  • Strong quantitative and analytic skills
  • Proven ability to quickly work with multiple key stakeholders
  • Able to steer through a large corporate environment and ensure appropriate organizational data processes are met
  • Data analysis/profiling and reverse engineering of data
  • Strong knowledge of relational and multi-dimensional database architectures


Search IT Jobs