Data modeler [h1.location_city]

Data Modeler Description : Data Modeler Irving, TX (3

days onsite - Hybrid) 12 months Web Cam Interview $65 / Hr on W2

Summary : we are seeking a Data Modeler with strong hands-on

experience in developing Conceptual, Logical and Physical Data

Model for Wholesale Lending. Candidate must have experience in

developing large scale data models that fits multiple lines of

business. The work will involve developing strategic

state-of-the-art solutions using agile methodologies, micro

services and integration with many application / services.

Description : Institutional operations group is responsible for the

management and execution of transactions for Markets, Credit Risk,

Security Services, Information Services, Private Bank, Treasury and

Trade Solutions and Operation Controls and reporting. The

technology arm of ICG engaged in the application development and

support for various lines of businesses Responsibilities : Identify

data and information needs for wholesale lending business of ICG

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 ssist 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. nalytical and problem

solver, excellent verbal, written and presentation skills

Education : Bachelors degree / University degree or equivalent

experience Certification in Data Architecture / Modeling is a plus

Remote