Responsibilities:
- Mandatory - Focuses on bank-wide data modeling and database design with emphasis on Conceptual, Logical modeling using traditional and advance data approach.
- Defines data/information architecture standards, structure, attributes and nomenclature of data elements, and applies accepted data content
- standards to technology projects.
- Advises on consistent business analysis, data acquisition, and access analysis and design, Data Management Systems optimization, load strategy design
- and implementation, as well as data-related security and change management
- Collaborates with Engineering and ETL teams on data model, its maintenance and optimization as well as end-to-end data driven integration strategy.
- Develops a metadata management and repository strategy to manage all enterprise information architecture project artifacts.
- Collaborates with Product and Enterprise Data Teams
- Ensure the to-be model is inclusive of integration of data across systems, collection, storage, processing, management, governance and analysis of data
Basic Qualifications:
- 7-20+ years of experience as conceptual data architect or other senior data management role. Experience using architecture repository tools.
- Mandatory - Knowledge of conceptual data design patterns, UML, data modeling, service-oriented integration, business intelligence domains.
- Data Warehouse design concepts, data warehouse and large-scale reference data models, OCI, ETL tools.
- SME with Domain knowledge on most of the following major financial products' areas such as Deposit, Lending, Cards, Investment.
- SME with Domain knowledge on bank's Reporting, Capital Adequacy, GL Posting, Liq Monitoring & Reporting, Stress Testing/Business Planning, FRY-9C,
- FRY-14 A/Q/M, FR 2052a, Ledger Rep(10Q/10K) and/or RWA Aggregation.
- Experience with banking system and applications transactional and warehouse system.
- Hands-on experience with conceptual data architecture, taxonomy and MDM tools master data management solutions with 1 or more of the following
- e.g. Informatica, Teradata, DataStage, Microstrategy, Cognos, etc
- Experience with Data Governance, Data Quality, Data Management Tools
- Relational and Non-relational Data Warehouses (SQL, Oracle, NoSQL, MongoDB, Cassandra) and Big Data Technologies. Distributed technologies and Internal cloud technologies like Open shift, PCF, Big Data platforms like Hadoop,
- demonstrated understanding of Data Analytics.
- Familiar with one of the following modeling tools (e.g. Magicdraw, ER/Win, Power Designer, ERStudio),
- Other Professional Skill Requirements:
- BA/BS Degree in science major such as Computer Science with MBA or FE/Quant is a big plus
- Previous Big 4 Consulting experience &/or hedge funds &/or Investment Banking
- Python, VBA, SQL experience for GRC tool and reporting
Other regulatory requirement BASEL accord (BCBS 239, CCAR, DFS504, DFS500, GDPR...)