Previous Job
Data Modeler
Ref No.: 18-06769
Location: Dallas, Texas
Position Type:Contract
Start Date / End Date: 08/20/2018 to 12/31/2018
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.