Data Modeler - Magic Draw/Erwin/Cameo

Currently, we are looking for talented resources for one of our listed clients. If interested please reply to me with your updated resume or feel free to reach out to me for more details at

Title: Data Modeler - Magic Draw/Erwin/Cameo

Location: Irving, TX

Duration: 12 Months

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:

• Client develops innovative solutions and provides exceptional service to our clients in full partnership with our product teams.
• Institutional operations group is responsible for the management and execution of transactions for Markets, Credit Risk, Security Services, Information Services, Private Banks, 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 the wholesale lending business of ICG
• Develop conceptual, logical models and metadata solutions
• Performing Data Analysis on various data sets
• Design and maintain a 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 a walkthrough
• Incorporate data standards and implement a governance model
• Develop data flows, ownership matrixes, mapping, and data lineage
• Assist in the implementation of the physical data model, contribute to the system and operational design, carry out optimization for usability and performance

Qualifications:

• 8-10 years of hands-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 modeling 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

About us:

At our organization, we take our mission and values to heart! We are on a mission to offer more and better jobs all over the world! Our goal is to care for you while you care for our clients and get you paid the highest pay possible. All our associates working with us are expected to embrace our RACE values: R- Results Matter, A- Approachable, C - Care, and E - Emergency i.e. work with a sense of urgency.

For more relevant job opportunities please visit our website: