Apply Now    

Senior Data Modeler / Database Management Lead - Global Supplier Services Technology

Job Description

JPMorgan Chase & Co. (NYSE: JPM) is a leading global financial services firm with assets of $2.6 trillion and operations worldwide. The firm is a leader in investment banking, financial services for consumers and small business, commercial banking, financial transaction processing, and asset management. A component of the Dow Jones Industrial Average, JPMorgan Chase & Co. serves millions of consumers in the United States and many of the world's most prominent corporate, institutional and government clients under its J.P. Morgan and Chase brands. Information about JPMorgan Chase & Co. is available at www.jpmorganchase.com.

 

 

Risk & Finance Technology (RFT) builds and supports the firm's financial
infrastructure to ensure Finance professionals have access to the tools and information necessary to drive success. In partnership with Global Finance Operations (GFO), Global Technology Infrastructure (GTI) and others, we deliver solutions that meet the requirements of our key clients - the JPMorgan Chase CFO and Corporate Finance Organizations, as well as all line of business CFO teams.

 

 

The Senior Data Modeler will lead the effort in developing a consistent use of data and logical and physical data architecture across the Control System Technology portfolio including data/database standards/guidance, business glossaries, data dictionaries, conceptual, logical and physical data models, mapping between models/ systems, and creation of data definition language (ddl) in a framework of OLTP, OLAP, and Data Warehouse design methodologies. The Senior Data Modeler will work closely with the Database Engineer to instantiate DDL into the Test and Production environments. The Senior Data Modeler will conduct model reviews and tests, and work closely with development teams to ensure consistency during application builds and upgrades.  This person will ensure Firmwide standards and guiding design principles are adhered to when mapping and auditing data/information assets as they flow from upstream and are delivered to downstream systems and/or display sub-systems. 

 

Additional responsibilities:

  • Translate Business Requirements to Conceptual and Logical Data Models (ERDs – Entity relationship Diagrams).
  • Create Physical Data Models (ERDs), of different types, from Logical Data Models.
  • Recognize the need for a specific relational design – OLTP, OLAP, Data Warehouse – from a set of project requirements, and/or from a Logical Data Model.
  • Mapping of Logical to Physical Data Models and vice versa
  • Create DDL from Physical Data Models.
  • Work closely with Database Engineering to move DDL to Test and Production environments.
  • Evaluate other Modeler’s logical and/or physical data models for (a) adherence to LDM modeling principles, such as 3NF (b) adherence to CST Standards and Guidelines and (c) a match between business requirements and model content.
  • Participate in model design reviews and testing.
  • Explain/ teach classical Conceptual, Logical and Physical Data Modeling
  • Manage multiple assignments simultaneously, while working independently, and with other engineers and SMEs.
  • Identifying, recommending and implementing emerging Modeling and IT trends, developments, tools and improvements/solutions.
  • Excellent problem solving skills and technical reasoning.
  • 10+ years of experience with Data Strategy and Modeling.
  • Expert in both OLTP  3NF modeling and Kimball-style dimensional modeling; OLAP is a plus.
  • Familiarity with SDLC.
  • A track record of using Erwin, versions 7 – 9;  experience with other data modeling tools will be considered.
  • Experience with data design and strategy for enterprise level technology systems.
  • Excellent problem solving skills and technical reasoning.
  • Awareness of other modeling techniques, UML experience is a plus.
  • Familiarity with reference data at the global and local level is required.
  • Familiarity with a standard Financial Industry Data Models (examples: IBM, Teradata, etc.) is a plus, but not required.
Req #: 160025215
Location: Jersey City, NJ US
Job Category: Technology
Employment Type: Full Time
Potential Referral Amount: 0 US Dollar (USD)

Apply Now    

Join our Talent Community

Not ready to apply? Leave your information with us and we will keep you up to date with new career opportunities.

Join Now

Privacy Statement

Any information you provide is confidential and will only be viewed by our recruiters in an effort to fill open positions. In addition, the information you provide is subject to our privacy policy practices.

Please note that J.P. Morgan will not accept unsolicited approaches or speculative CVs, nor will J.P. Morgan be responsible for any related fees, from Third Party Firms who are not preferred suppliers.

The firm invites all interested and qualified candidates to apply for employment opportunities.

Need disability related assistance?

If you are a US or Canadian applicant with a disability who is unable to use our online tools to search and apply for jobs, please contact us by calling (US and Canada Only) 1-866-777-4690. Please indicate the specifics of the assistance needed.


Keep in touch

Not ready to apply? Leave your information with us and we will keep you up to date with new career opportunities.