Senior Data Modeler

Job Description

<ul><li>Translate business requirements into working logical and physical Service Layer Data models.</li><li>Create and maintain Logical Data Model (LDM) and Physical Data Model (PDM) for the project.</li><li>Create and maintain the Source to Target Data Mapping document for this project. Includes documentation of all entities, attributes, data relationships, primary and foreign key structures, allowed values, codes, business rules, glossary terms, etc.</li><li>Gather and Publish Data Dictionaries: Maintain data models and capture data models from existing databases and record descriptive information.</li><li>Identify business needs, organize and define data, create and maintain Conceptual, Logical and Physical data models; Maintain appropriate Version Control on data models.</li><li>Participate in the de-normalization of the data model, ensuring that business rules which are impacted during de-normalization are implemented via an alternate mechanism (i.e. trigger, application code).</li><li>Closely work with the App Dev team and DBA to create an appropriate Conceptual, Logical and Physical Data Model.</li><li>Present data designs and project approaches to the DRB for review and approval and ensure all DRB artifacts are created.</li><li>Generate DDL and validate that the DDL is implemented properly.</li><li>Identify opportunities to reuse data and reduce redundancy in data across the enterprise.</li></ul><p><br></p><strong>Requirements</strong><p><br></p><ul><li>6+ years experience in data modelling or engineering or analysis</li><li>Excellent SQL and Python </li><li>problem solving skills</li></ul>