Responsibilities:
• Develop conceptual, logical models and metadata solutions
• Performing Data Analysis on various data sets
• Design and maintain blueprint of the information architecture, data integrations and controls aligned to the renewed business strategy
• Unify data concepts across disparate front office, credit risk, servicing and reporting functions of ICG
• Determine database structural requirements by analyzing client operations, applications and data from existing systems
• Participate in requirement engineering and working groups and collaborate with business leads, operations, SMEs, technologists and governance teams
• Define, model and rationalize target state solution, socialize with key stakeholders and conduct walkthrough
• Incorporate data standards and implement governance model
• Develop data flows, ownership matrixes, mapping and data lineage
• Assist in the implementation of physical data model, contribute to the system and operational design, carry out optimization for usability and performance
Qualifications:
• 8-10 years hand-on experience in Data Modeling and implementation using RDBMS - Oracle preferred
• Hands-on modeling expertise using Magic Draw, Erwin or Enterprise Architect and metadata management tools
• Financial industry knowledge in wholesale lending, risk management, servicing and risk/regulatory reporting
• SQL query knowledge and performing data analysis
• Product knowledge in commercial banking, capital and investment banking and markets
• Experience in UML/relational/hierarchical/Big Data concepts is a plus
• Prefer data modelling experience using Magic Draw and Cameo. Utilize Code Engineering Sets to generate executable code or a database script. Write custom macros to efficiently validate and manage data models
• Knowledge of Data Management methodologies involving architecture, modeling, storage, security
• Prior experience in data integration, interoperability and data quality solutions.
• Analytical and problem solver, excellent verbal, written and presentation skills
Education:
• Bachelor’s degree/University degree or equivalent experience
• Certification in Data Architecture / Modeling is a plus
This job description provides a high-level review of the types of work performed. Other job-related duties may be assigned as required.
