Data Architect - II

Job ID: 24-05024
Qualifications:
o 8+ years of hands-on data modeling experience with ER Studio.
o 8+ years of hands-on strong Data modeling (Conceptual, Logical, Physical, 3nF, Dimensional) at both enterprise and data product level.
o 8+ years of experience in establishing enterprise data standards.
o 8+ years of experience in designing enterprise data model framework.
o Work with business architects, Solution architects, and data stewards to capture business requirements in a Conceptual and Logical Data Model.
o General working knowledge of traditional DBMS platforms like Oracle and Cloud DBMS like Aurora, Dynamo DB, Redshift and Databricks.
o Analyze and translate business requirements into conceptual and fully detailed logical data models.
o Create logical data models based on existing applications and databases.
o Contribute to ongoing updates to data modeling standards and guidelines.
o Strong verbal, presentation, and written communication skills
o Evaluate physical data models to ensure they align with the corresponding logical data models.
o Understanding of principles and standard methodologies around Data Architecture.
o Ability to write SQL to query data (ideally ANSI SQL).

Responsibilities:
o Establish enterprise standards
o Design data models using ER Studio to support business processes
o Document and provide best practices for managing data models in ER Studio
o Manage the enterprise data model repository
o Provide data model documentation and artifacts generated from data ERD, data dictionary, data definitions, etc.
o Compliant with Bank's data modeling standards
o Apply industry standards and best practices where applicable
o Perform end-to-end data management from data analysis, conceptual/logical modeling to database deployment
o Create structures that implement and enforce unified set of models
o Prepare presentations for business users and management
o Support enterprise data catalog setup and enrichment