Our client, a top-tier management consulting firm, has partnered with a leading U.S. bank in NYC to hire a hands-on ERWIN Data Modeler. You’ll own conceptual, logical, and physical models (Snowflake-centric), stand up a reusable semantic layer, and drive data governance and reuse across core banking domains (deposits, loans, core platforms) using erwin Data Modeler.
Responsibilities and Qualifications:
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
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
