Pinnacle Group
Senior Data Modeler
Pinnacle Group, Irving, Texas, United States, 75084
Only W2 NO C2C
Location: Irving, TX (3 days onsite - Hybrid)Duration: 12 months
Data Modeler
Description:
Institutional Clients Group Operations and Technology (ICG O&T) develops innovative solutions and provide 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 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• 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:• Bachelors degree/University degree or equivalent experience• Certification in Data Architecture / Modeling is a plus
Pay Range: $70 - $75
The specific compensation for this position will be determined by a number of factors, including the scope, complexity and location of the role as well as the cost of labor in the market; the skills, education, training, credentials and experience of the candidate; and other conditions of employment. Our full-time consultants have access to benefits including medical, dental, vision and 401K contributions as well as any other PTO, sick leave, and other benefits mandated by appliable state or localities where you reside or work.
Location: Irving, TX (3 days onsite - Hybrid)Duration: 12 months
Data Modeler
Description:
Institutional Clients Group Operations and Technology (ICG O&T) develops innovative solutions and provide 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 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• 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:• Bachelors degree/University degree or equivalent experience• Certification in Data Architecture / Modeling is a plus
Pay Range: $70 - $75
The specific compensation for this position will be determined by a number of factors, including the scope, complexity and location of the role as well as the cost of labor in the market; the skills, education, training, credentials and experience of the candidate; and other conditions of employment. Our full-time consultants have access to benefits including medical, dental, vision and 401K contributions as well as any other PTO, sick leave, and other benefits mandated by appliable state or localities where you reside or work.