Data Architect - II

Job ID: 24-05024Qualifications: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 skillso 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 standardso Design data models using ER Studio to support business processeso Document and provide best practices for managing data models in ER Studioo Manage the enterprise data model repositoryo Provide data model documentation and artifacts generated from data ERD, data dictionary, data definitions, etc.o Compliant with Bank's data modeling standardso Apply industry standards and best practices where applicableo Perform end-to-end data management from data analysis, conceptual/logical modeling to database deploymento Create structures that implement and enforce unified set of modelso Prepare presentations for business users and managemento Support enterprise data catalog setup and enrichment