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
This is a temporary contract position and does not include employee benefits such as health insurance, paid time off, retirement plans, or other employer-provided benefits.
