DATA ARCHITECT

Data Model Design

- Develop and maintain conceptual, logical and physical data models within the bank’s Enterprise Data Platform using tools like Erwin Data Modeler to support reporting, analytics and operational data extracts

- Design data structures optimized for performance, scalability and maintainability

Data Integration & Mapping

- Define and document data mappings for ETL processes and integration across multiple components of the bank’s Enterprise Data Platform (using Azure - - Data Factory for data movement and Azure Databricks for transformation)

Data Access & Security

- Implement and manage Unity Catalog for metadata management and access control in Azure Databricks

- Ensure compliance to the bank’s internal and external data security and privacy standards

Data Optimization & Performance Tuning

- Design and optimize data models to improve query performance, scalability, and storage efficiency of the bank’s Enterprise Data Platform

- Implement partitioning, indexing and other performance-enhancing techniques

Metadata Management

- Manage and track metadata across data models within the bank’s Enterprise Data Platform

Collaboration & Stakeholder management

- Work closely with data engineers, business analysts, and IT teams to understand business requirements and translate them into technical data design and/or solution

Version Control

- Manage version control for data models and ensure changes are tracked and communicated across teams using data from the bank’s Enterprise Data Platform

- Track/oversee change management processes for data model updates and revisions

Documentation

- Create and maintain data dictionaries, ERDs, and other technical documentation to support ongoing development and upcoming developments that will utilize the bank’s Enterprise Data Platform