Senior Data Modeler at Tiger Analytics | Torre

Senior Data Modeler

Emma highlights
This highlight was written by Emma’s AI. Ask Emma to edit it.
Full-time

Legal agreement: To be defined

Compensation
USD61k - 121k/year
Non-negotiable
location_on
Hybrid (United States)
Posted over 5 years ago

Responsibilities


• Translate business requirements into working logical and physical Service Layer Data models. • Create and maintain Logical Data Model (LDM) and Physical Data Model (PDM) for the project. • 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. • Gather and Publish Data Dictionaries: Maintain data models in ERWin. Capture data models from existing databases and record descriptive information into ERWin. • Identify business needs, organize and define data, create and maintain Conceptual, Logical and Physical data models; Maintain appropriate Version Control on data models. • 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). • Closely work with the App Dev team and DBA to create an appropriate Conceptual, Logical and Physical Data Model. • Present data designs and project approaches to the DRB for review and approval and ensure all DRB artifacts are created. • Generate DDL and validate that the DDL is implemented properly. • Identify opportunities to reuse data and reduce redundancy in data across the enterprise.