Apply Now    

Data Warehouse ETL Architect

Req #: 170114333
Location: Columbus, OH, US
Job Category: Technology
Potential Referral Amount: 3000 US Dollar (USD)
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
Data Architect - Risk & Finance Technology
The Data Architect position is within Risk & Finance Technology (RFT) Data Acquisition & Hosting group.  The program is chartered to re-engineer acquisition and hosting of data to enable a single sourcing strategy and will include strategic data sourcing, data validation, transformation, enrichment, and loading to the hosting database capabilities.
We are seeking a Data Modeler/Data Architect with strong Data Ware house skills and ETL to provide expert guidance on gathering and analyzing of business data requirements and the creation of conceptual, logical, and physical data modeling within our organization. The main focus of the work will be in development and maintenance of a catalog of the information assets - through business representation, physical representation in databases as well as underlined Data Ingestion/ETL process in files used to source data from suppliers of data, and the associated metadata from data sourcing through to persistence.
  • Gather and analyze business data requirements and model these needs. In doing so, work closely with the users of the information; the application developers and architects, to ensure the information models are capable of meeting their needs. 
  • Familiarity with Bi-Temporal modeling techniques, including knowledge of schema evolution and Schema on Demand techniques
  • Deliver the models both formally and informally through presentations to applications development groups and management.
  • Lead and perform database level tuning and optimization in support of application development teams on an ad-hoc basis.
  • Develop test scripts for testing sourced data and their validation and transformation when persisting in data stores that are physical representations of the data models.
  • Analyze information models in real-world systems and make useful and practical recommendations to their improvement. 
  • Provide solutions for complex information modeling and architecture problems.
  •  Minimum of 5+ years of business requirements analysis and information modeling (logical and physical) of key financial products (Bilateral, OTC & exchange traded, centrally cleared) and concepts (e.g. positions, trades, financing transactions, future flows, collateral/margining) in financial industry.
  • 5+ years of strong background in Database tuning and modelling techniques for Exadata as well as Hadoop. 

  • 3+ years Unix shell scripting experience 

  • 3+ background on Complex SQL query tuning. 

  • 3+ Experience with ETL techniques and tools like Ab Initio, Talend Etc.

  • 2+  years of experience with AVRO schemas, Parquet, Hive, HBASE

  • Strong 5+ years of background in Oracle / Exadata including latest evolution in this space. 

  • Minimum of 3+ years in handling Physical modeling (Big Data- EXADATA, HADOOP etc.) 

  • Proficiency in a data modeling tool – preferably Erwin. 

  • Good working experience of Microsoft Office suite 

  • General knowledge of financial industry products, processes and practices. 

  • High degree of Motivation and adaptability. 

  • Excellent written and verbal communication skills. 

  • Exposure to Big data is a must 

  • Bachelor’s Degree in Computer Science or related field

  • Understanding of Web Content Accessibility Guidelines (WCAG 2.0) and assistive technologies (JAWS, NVDA, Zoomtext), and proven track record of incorporating into your day-to-day work, is a plus but not required

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.

Things to note

Sign in to our application system to continue your job search or update your profile.

Current employees sign in here. Contractors sign in here.

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 click here.

Important links

Click here to view the "EEO is the Law" poster.

Click here to view the "EEO is the Law" supplemental poster.

Click here to view our U.S. Pay Transparency Policy.

JPMorgan Chase is an equal opportunity and affirmative action employer Disability/Veteran.