Data Modeler with Banking Domain Knowledge

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