Apply Now    

Software Engineer - Core Components and Architecture - Data Modeller

Req #: 180012902
Location: Bangalore East, KA, IN
Job Category: Technology
Job Description:

J.P. Morgan is a leading global financial services firm, established over 200 years ago:


  • We are the leader in investment banking, financial services for consumers and small businesses, commercial banking, financial transaction processing, and asset management.
  • We have assets of $2.6 trillion and operations worldwide
  • We operate in more than 100 markets.
  • We have more than 243,000 employees globally.


Our wholesale businesses include J.P. Morgan’s Asset Management, Commercial Banking and the Corporate & Investment Bank which provide products and services to corporations, governments, municipalities, non-profits, institutions, financial intermediaries and high-net worth individuals and families.


Our corporate functions support the entire organization and include the following functions: Accounting, Audit, Finance, Human Resources, Operations, and Technology.


J.P. Morgan in India provides a comprehensive range of Corporate & Investment Banking, Commercial Banking, Asset & Wealth Management, and Corporate functions services and solutions to our clients, executing some of the most important financial transactions and providing essential strategic advice to our clients such as the government, large domestic and multi-national corporations, non-government organizations and financial institutions and investors. India is a key market for JPMorgan Chase globally and our employees in India are a critical part of how we do business globally and are integrated within our businesses. Our Global Service Centers (GSCs) are strategically positioned in Mumbai, Bangalore and Hyderabad to support the firm’s operations regionally and globally. The centers provide comprehensive strategic support across technology and business operations processing to all lines of business and the corporate functions.


The Technology team at our GSCs service all Lines of Business and Enterprise Technology in helping build and operate innovative industry leading solutions. The breadth of capabilities within the Technology team at the GSC enables it to support the firm in leading edge areas such as Digital, Big data analytics, Robotics & Machine Learning.

JPMorgan Asset Management (JPMAM) continues to drive towards best in class data management capabilities to ensure all areas of the business and operations make decisions or report information based on a clear understanding of the data they are using and its quality. In parallel technology are looking to overhaul the way they deliver and document data. A model driven service architecture coupled with a comprehensive metadata solution underpins the target state data architecture.
To achieve these objectives we are looking to build out a core data architecture team by recruiting a number of experienced and junior data architects and data modelers who will report directly to the JPMAM Chief Data Architect. The core data architecture team will need to work in a collaborative manner with business sponsors and data product owners to maintain the canonical/logical, physical and XML data models.
The Junior Data Architect/Modeller position is part of a central team that is responsible for owning, developing and maintaining the JPMAWM Corporate Data Model. 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. The JPMAWM Corporate data model is a critical component of the technology organisation as it provides the basis for database design, data service generation, data quality assessment and data documentation.
The role will involve working with senior data modellers 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 JPMAM Metadata platform.
Instruction will be given on specific tools and technologies however a good grasp of Excel and other MS Office tools is expected. Career progression will be towards a more senior data modelling position with opportunities to develop into other roles such as data analyst, data scientist, business intelligence solutions or business analysis.
New approaches to data modelling such as RDF and the Semantic Web are now emerging. Working on the assumption that the candidate is a recent graduate there will be some opportunities to explore some R&D activities ideally with academic institutions to see how these new techniques and concepts can assist our business.
Job functions
  • Working in isolation or with senior data modellers 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.
  • Data model integration. The Corporate data model is actually 40+ individual models all linked together to form a single corporate model. All the individual models need to be checked to ensure they cross reference each other accurately.
  • Semantic model mapping from Industry based models to JPMAM specific models to leverage industry standards and to test model completeness.
  • 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 do this we need to capture and document data lineage. This part of the job will require the candidate to become familiar with a a range of different technologies to perform these functions so the ability to learn quickly is important.
  • Data modeling tool customisation. 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 XSD models are generated from the physical model. Maintaining these scripts and version upgrades to the data modeling tool is a key activity.
  • Documentation. A central data portal details all the JPAM data standards. Keeping this information up to date and relevant is an important task.
Computer Science Graduate proffered unless has previous data modelling experience
Some relevant work 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
Visual basic
Competencies to test for:
Judgement and decision making
Being able to sift through a lot of facts to tease out a solution, core issues or objectives.
Communication skills
Handling conflicts of interest. Managing up and down.
Listening skills
Awareness of how technology can assist the business and pitfalls where technology can hamper the business.
Apply Now    
Link for schema

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.