We know that people want great value combined with an excellent experience from a bank they can trust, so we launched our digital bank, Chase UK, to revolutionize mobile banking with seamless journeys that our customers love. We're already trusted by millions in the US and we're quickly catching up in the UK - but how we do things here is a little different. We're building the bank of the future from scratch, channeling our start-up mentality every step of the way - meaning you'll have the opportunity to make a real impact.
As a Data Architect III at JPMorgan Chase within the International Consumer Bank, you will be part of a flat-structure organization. Your role involves designing, building, and optimizing data models, writing SQL with DBT, and ensuring data accuracy through quality tests. You will consult with business analysts to optimize data models and be involved in data solution architecture with a focus on data warehousing. Collaboration with teammates is key, as our Business Analytics team aims to deliver innovative ideas to our customers. Our teams work in tribes and squads, allowing movement based on strengths and interests.
Job responsibilities:
- Designing and optimizing data models to support business needs.
- Writing advanced SQL queries, with a strong focus on DBT, leveraging incremental materialisation and macros.
- Consulting with business analysts to ensure data models are optimal and well-designed.
- Collaborating with stakeholders to understand data requirements and provide solutions.
- Identifying opportunities to improve data architecture and processes, with a focus on data warehousing.
- Presenting data architecture solutions in a clear, logical, and persuasive manner.
Required qualifications, capabilities and skills:
- Formal training or certification on SQL concepts and 3+ years applied experience
- Strong SQL skills, experience in DBT is a plus.
- Experience in designing and optimizing data models and data warehousing solutions.
- Ability to consult and collaborate with business analysts and stakeholders.
- Demonstrated ability to think beyond raw data and understand the underlying business context.
- Ability to work in a dynamic, agile environment within a geographically distributed team.
- Strong problem-solving capabilities, ability to think creatively and impeccable business judgment.
- Excellent written and verbal communication skills in English.
Preferred qualifications, capabilities and skills
- Experience with data architecture in a fintech environment.
- Experience in cloud solutions, ideally AWS
- Basic data engineering expertise
- Familiarity with data mesh
- Familiarity analytics and dashboarding
#ICBCareer
Top Skills
What We Do
JPMorgan Chase & Co. (NYSE: JPM) is a leading global financial services firm with assets of $3.7 trillion and operations worldwide. The firm is a leader in investment banking, financial services for consumers and small businesses, 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.
Technology fuels every aspect of our company and is at the heart of everything we do. With over 50,000 technologists globally and an annual tech spend of $12 billion, we are dedicated to improving the design, analytics, development, coding, testing and application programming that goes into creating high quality software and new products.
Learn more about technology at our firm, explore resources from our Distinguished Engineers, AI & ML researchers, and other experts; access the latest episode of our TechTrends podcast, and more at www.jpmorgan.com/technology. Information about JPMorgan Chase & Co. is available at www.jpmorganchase.com.
©2023 JPMorgan Chase & Co. All rights reserved. JPMorgan Chase is an Equal Opportunity Employer, including Disability/Veterans.
Why Work With Us
Our technologists work on a diverse range of solutions that include strategic technology initiatives, big data, mobile, electronic payments, machine learning, cybersecurity, enterprise cloud development, and other state-of-the-art technologies.
Gallery
JPMorganChase Teams
JPMorganChase Offices
Hybrid Workspace
Employees engage in a combination of remote and on-site work.











