Apply Now    

Software Engineering

Req #: 170109193
Location: Hyderabad, AP, IN
Job Category: Technology
Job Description:
Description
Corporate Technology & Risk (CTR) delivers streamlined and consistent solutions supporting JPMorgan Chase’s Controls, Compliance, Legal, HR and IT Risk agendas, with a focus on stability, delivery, efficiencies and people. The goal of CTR’s drive to standardization, consistency and simplicity is a JPMorgan Chase architecture that fosters long-term productivity, quality and innovation across the entire enterprise. The disciplines within this organization are Compliance Technology, Oversight & Controls Technology, Legal & e-Discovery, Identity & Access Management, IT Risk & Controls, HR Real Estate & Global Services Technology, and Third Party Risk Management. 
 
Control System Technology provides strategic application development and production support to 5 firm-wide organizations whose focus is strongly aligned to the firm’s enterprise wide control agendas: Oversight and Control, IT Risk Management, Sourcing & Procurement, Global Security & Investigations, and Global Business Resiliency.
Role
The Data Modeler position is part of a central team that is responsible for designing, developing, and maintaining application data models. The role requires someone with good analytical and communication skills. The candidate should have a good technology background with some working knowledge of relational database theory or big data. The application data models are a critical component of the technology organization as they provide the basis for database design, data service generation, data quality assessment, and data documentation.
The role will involve working with senior data modelers to develop high level and detailed logical data models with an associated controlled vocabulary, both of which will need to be versioned controlled and managed in the CT Metadata platform.  Additionally, the data modeler will identify Critical Data Elements, determine required data quality controls, and create a physical data model on varying database platforms (e.g. Oracle, SQL Server, Maria DB, Hbase).
The data modeler will need to work in a collaborative manner with business sponsors, application developers, and data product owners to maintain the canonical/logical, physical and XML data models.  Instruction will be given on specific tools and technologies; however a good grasp of Erwin and MS Office tools is expected.
Job functions
  • Working in isolation or with senior data modelers to capture business data requirements as a logical data model. Ensuring these models are consistent and that the Business Glossary is linked and maintained in a manner that allows impact assessment and lineage of metadata.
     
  • Metadata support. Providing access to metadata information though the generation of pre-prepared or dynamic queries.
     
  • Data quality analysis. Maintaining data validation rules, testing those rules and running data quality reports or generating data quality dashboards
     
  • Current state documentation and data lineage capture. In many cases existing database will need to be reverse engineered to assist in bringing all our data dictionaries up to date. At the same time, we need to capture and document data lineage. This part of the job will require the candidate to become familiar with a range of different technologies to perform these functions.
     
  • Data modeling tool customization. In many cases model and DDL generation is controlled by scripts in the data modeling tool. These scripts control the generation of many aspects of the data model including how data auditing is carried out and how DDL is generated from the physical model. Maintaining these scripts and version upgrades to the data modeling tool is a key activity.
 
  • Documentation. Keeping applicable information up to date and relevant is an important task.
     
    Background
    Computer Science Graduate preferred unless has previous data modelling experience
    Desirable skills
  • Good communicator, good listener and comfortable in a confrontational situation
  • Relationship building, team player
  • Quick learner, concepts and skills
  • Proficient with MS Excel, Word and Powerpoint
  • UML modelling
  • Proficiency in Erwin Data Modeler Tool and Data Modeling experience
  • Excellent problem solving skills and technical reasoning

Description
Corporate Technology & Risk (CTR) delivers streamlined and consistent solutions supporting JPMorgan Chase’s Controls, Compliance, Legal, HR and IT Risk agendas, with a focus on stability, delivery, efficiencies and people. The goal of CTR’s drive to standardization, consistency and simplicity is a JPMorgan Chase architecture that fosters long-term productivity, quality and innovation across the entire enterprise. The disciplines within this organization are Compliance Technology, Oversight & Controls Technology, Legal & e-Discovery, Identity & Access Management, IT Risk & Controls, HR Real Estate & Global Services Technology, and Third Party Risk Management. 
 
Control System Technology provides strategic application development and production support to 5 firm-wide organizations whose focus is strongly aligned to the firm’s enterprise wide control agendas: Oversight and Control, IT Risk Management, Sourcing & Procurement, Global Security & Investigations, and Global Business Resiliency.
Role
The Data Modeler position is part of a central team that is responsible for designing, developing, and maintaining application data models. The role requires someone with good analytical and communication skills. The candidate should have a good technology background with some working knowledge of relational database theory or big data. The application data models are a critical component of the technology organization as they provide the basis for database design, data service generation, data quality assessment, and data documentation.
The role will involve working with senior data modelers to develop high level and detailed logical data models with an associated controlled vocabulary, both of which will need to be versioned controlled and managed in the CT Metadata platform.  Additionally, the data modeler will identify Critical Data Elements, determine required data quality controls, and create a physical data model on varying database platforms (e.g. Oracle, SQL Server, Maria DB, Hbase).
The data modeler will need to work in a collaborative manner with business sponsors, application developers, and data product owners to maintain the canonical/logical, physical and XML data models.  Instruction will be given on specific tools and technologies; however a good grasp of Erwin and MS Office tools is expected.
Job functions
  • Working in isolation or with senior data modelers to capture business data requirements as a logical data model. Ensuring these models are consistent and that the Business Glossary is linked and maintained in a manner that allows impact assessment and lineage of metadata.
 
  • Metadata support. Providing access to metadata information though the generation of pre-prepared or dynamic queries.
 
  • Data quality analysis. Maintaining data validation rules, testing those rules and running data quality reports or generating data quality dashboards
 
  • Current state documentation and data lineage capture. In many cases existing database will need to be reverse engineered to assist in bringing all our data dictionaries up to date. At the same time, we need to capture and document data lineage. This part of the job will require the candidate to become familiar with a range of different technologies to perform these functions.
 
  • Data modeling tool customization. In many cases model and DDL generation is controlled by scripts in the data modeling tool. These scripts control the generation of many aspects of the data model including how data auditing is carried out and how DDL is generated from the physical model. Maintaining these scripts and version upgrades to the data modeling tool is a key activity.
 
  • Documentation. Keeping applicable information up to date and relevant is an important task.
 
Background
Computer Science Graduate preferred unless has previous data modelling experience
Desirable skills
  • Good communicator, good listener and comfortable in a confrontational situation
  • Relationship building, team player
  • Quick learner, concepts and skills
  • Proficient with MS Excel, Word and Powerpoint
  • UML modelling
  • Proficiency in Erwin Data Modeler Tool and Data Modeling experience
  • Excellent problem solving skills and technical reasoning
Qualifications
 
  • 10+ years of employment history in the Financial Services industry
  • Expert in both OLTP modeling and Kimball-style dimensional modeling; OLAP is a plus
  • Expert level knowledge of HA technologies especially for Oracle and MS SQL Server
  • Any certification is a plus (Oracle, SQL Server)
  • Expert knowledge of Oracle and MS SQL Server database internals
  • Experience in making good decisions with limited information
  • Must be able to interface effectively with all levels of the organization.
  • Must have excellent interpersonal skills and be strong and effective communicator
  • Familiarity with a standard Financial Industry Data Models (examples: IBM, Teradata, etc.) is a plus, but not required

 
 
  • Strong communication skills 

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.

Other Information

Apply Using LinkedIn

You can also apply using your LinkedIn® profile. It may save you some time because your information will be automatically transferred into our system. Just click on the LinkedIn logo when you get to the application screen and follow the directions.

Submit an Updated Résumé

During the application process, be sure you have an up-to-date copy of your Résumé, your cover letter and any other documentation you would like to submit.