Teradata Data Modeling Lead Job Listing at Chase in NJ, New Jersey

Finance

Chase is a leader in the financial services industry, providing banking, mortgages, credit cards, loans, payment processing and investment services to 50 million customers - 1 out of every 6 Americans. As a division of JPMorgan Chase Co. (NYSE:JPM), we: serve 21 million households with consumer banking relationships lent $17 billion to small businesses in 2011 are one of the nation's largest credit card issuers, with more than 64 million credit cards in circulation service 8 million mortgage and home equity loans While we operate across a broad range of businesses, our mission at Chase is quite simple: to be the industry leader in customer service. Our employees put the firm's resources to work every day for our customers. Chase offers a dynamic environment and the training and support to meet your full potential. Our company is widely recognized as a great place to work, to grow and to invest for the future. Join our team. Chase continues to innovate despite a very difficult business environment, launching new products and services, such as Blueprint, Chase Sapphire and Ink from Chase, and earning a market leadership position in building loyalty and reward programs. Chase also offers credit card programs with many of the world's best brands. Through its merchant acquiring business, Chase Paymentech Solutions, Chase is one of the leading processors of credit card payments. The Chase Auto Finance (CAF) Data Management Program is a multi-year technology initiative to support CAF and enterprise data management processes addressing operational, financial, regulatory and analytical reporting requirements. The program includes the long term development of a strategic platform for CAF with data sourcing, data enrichment, analytical, monitoring and reporting capabilities. This platform will also integrate with cross-LOB efforts to create a single consolidated customer view. The CAF Data Management team is looking for a highly motivated and experienced physical data modeler with experience executing projects in data modeling and data architecture, to lead the definition of the physical data model needed to support the reporting and analytics requirements. This individual must have the skills to understand the logical data model as well as the business requirements. To ensure alignment with cross-LOB efforts, the logical model aligns with IBM's Banking Data Warehouse (BDW) model and so, familiarity with this model is essential. It is expected that this model will be extended to accommodate LOB-specific data requirements. The role is heavily collaborative, working closely with several internal business units as well as a firm-wide organization driving standards and best practices and the candidate will have several years experience working in client-focused roles. Deployment will be on a Teradata platform so experience with this technology is essential. Knowledgeability of financial products, particularly those in the retail segment, is highly desirable. As a Data Modeling Lead, you must be familiar with core data modeling concepts including 3 rd normal form, dimensional models, star and snowflake schemas, etc. and will have considerable experience successfully applying these concepts in the construction of data modeling solutions. Primary Responsibilities

• Create of the physical data model with a data modeling tool like ERwin.
• Modify the physical data model for efficient data access paths.
• Generate and execute DDL to create databases, tables, and views.
• Identify and create primary indexes, partitioned primary indexes, secondary indexes, join indexes, and all other needed indexes.
• Identify and create associative tables, data constraints, and compression mechanisms where necessary.
• Recommend and establish standards, guidelines, and procedures for design and maintenance.
• Participate in data model review board discussions.
• Participate in and support design reviews and code walkthroughs to ensure high quality deliverables.
• Lead data architecture reviews, strategic technology direction, and best practice development efforts.
• Cooperate closely with the project teams to produce realistic effort estimates, ensuring task completion within estimates, identifying and communicating variances as early as possible.