Data Modeler

Job Opening Details back to list Reference Code: BJ0999 Job Title: Data Modeler Category: Job Description: "JD: Data Modeler with Banking Domain/Banking Client experience is must. High on Priority
Job Description:
The successful candidate will be responsible for the overall design of the Citi's bank-wide data/information architecture which maps to the
future to be data solution. This key position will report to the Data Analytics director and work closely with the Head of Business, Data office,
IT and agile transformation team on both tactical and strategic enterprise-level GCB data design and implementation.
Manage priorities of the impacted data systems and platforms.
Oversee on time, quality delivery of DW/EDW/FDW project; track project progress, issues, risks, and opportunities, communicate effectively with stakeholders.
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.)
" Key Skills: 7_20 Yrs Location: Bangalore Required Experience: Not Specified Positions: 1 Contact Person: Balaji Email ID: balaji@vegaintellisoft.com Qualification