Sr ERWIN Data Modeler

USC or GC Onsite in NYC need Local Duration: 3 months to start, room for extension MUST HAVE • ERWIN Modeling • Snowflake Experience • Banking experience What You’ll Get To Do Perform hands-on Data Modelling, adoption of modern software engineering & delivery practices Will work on building Logical and Conceptual Data Model Will work on Ontological Modelling Will Have To Gather And Publish Data Dictionaries Will maintain data models in data modelling environments. Will capture data models from existing databases, and record descriptive information into them 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 Data Review Board (DRB) for review and approval, and ensure all DRB artifacts are created with clients Generate DDL and validate that the DDL is implemented properly Identify opportunities to reuse data and reduce redundancy in data across the enterprise What You’ll Bring With You 8+ Years of experience building Semantic layer, Logical and Conceptual Data Model and currently working on this Knowledge of modeling on Snowflake Banking products experience is a must (Deposits, Loans, Core banking applications) Understanding of architecture and design across all systems Understanding of software skills such as business analysis, development, maintenance, and software improvement Working proficiency in developmental toolsets Knowledge of industry wide technology trends and best practices Ability to work in large, collaborative teams to achieve organizational goals, and passionate about building an innovative culture