As a Data Architect III, you'll design and optimize data models, write advanced SQL queries, and collaborate with stakeholders to enhance data solutions.
Job Description
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 a part of a flat-structure organization. Your responsibilities are to design, build and optimize data models, write SQL (especially leveraging DBT) with associated data quality tests to ensure accuracy, as well as consult with business analysts to ensure their data models are optimal and well-designed. You are expected to be involved in the architecture and optimization of data solutions, with a strong focus on data warehousing, while also working in a collaborative fashion with team mates.
Our Business Analytics team is at the heart of this venture, focused on getting smart ideas into the hands of our customers. We're looking for people who have a curious mindset, thrive in collaborative squads, and are passionate about new technology. By their nature, our people are also solution-oriented, commercially savvy, and have a head for fintech. We work in tribes and squads that focus on specific products and projects - and depending on your strengths and interests, you'll have the opportunity to move between them.
While we're looking for professional skills, culture is just as important to us. We understand that everyone's unique - and that diversity of thought, experience, and background is what makes a good team great. By bringing people with different points of view together, we can represent everyone and truly reflect the communities we serve. This way, there's scope for you to make a huge difference - on us as a company, and on our clients and business partners around the world.
Job responsibilities:
Required qualifications, capabilities and skills:
Preferred qualifications, capabilities and skills
#ICBCareer
About Us
JPMorganChase, one of the oldest financial institutions, offers innovative financial solutions to millions of consumers, small businesses and many of the world's most prominent corporate, institutional and government clients under the J.P. Morgan and Chase brands. Our history spans over 200 years and today we are a leader in investment banking, consumer and small business banking, commercial banking, financial transaction processing and asset management.
We recognize that our people are our strength and the diverse talents they bring to our global workforce are directly linked to our success. We are an equal opportunity employer and place a high value on diversity and inclusion at our company. We do not discriminate on the basis of any protected attribute, including race, religion, color, national origin, gender, sexual orientation, gender identity, gender expression, age, marital or veteran status, pregnancy or disability, or any other basis protected under applicable law. We also make reasonable accommodations for applicants' and employees' religious practices and beliefs, as well as mental health or physical disability needs. Visit our FAQs for more information about requesting an accommodation.
About the Team
Our professionals in our Corporate Functions cover a diverse range of areas from finance and risk to human resources and marketing. Our corporate teams are an essential part of our company, ensuring that we're setting our businesses, clients, customers and employees up for success.
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 a part of a flat-structure organization. Your responsibilities are to design, build and optimize data models, write SQL (especially leveraging DBT) with associated data quality tests to ensure accuracy, as well as consult with business analysts to ensure their data models are optimal and well-designed. You are expected to be involved in the architecture and optimization of data solutions, with a strong focus on data warehousing, while also working in a collaborative fashion with team mates.
Our Business Analytics team is at the heart of this venture, focused on getting smart ideas into the hands of our customers. We're looking for people who have a curious mindset, thrive in collaborative squads, and are passionate about new technology. By their nature, our people are also solution-oriented, commercially savvy, and have a head for fintech. We work in tribes and squads that focus on specific products and projects - and depending on your strengths and interests, you'll have the opportunity to move between them.
While we're looking for professional skills, culture is just as important to us. We understand that everyone's unique - and that diversity of thought, experience, and background is what makes a good team great. By bringing people with different points of view together, we can represent everyone and truly reflect the communities we serve. This way, there's scope for you to make a huge difference - on us as a company, and on our clients and business partners around the world.
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, especially in DBT.
- 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
About Us
JPMorganChase, one of the oldest financial institutions, offers innovative financial solutions to millions of consumers, small businesses and many of the world's most prominent corporate, institutional and government clients under the J.P. Morgan and Chase brands. Our history spans over 200 years and today we are a leader in investment banking, consumer and small business banking, commercial banking, financial transaction processing and asset management.
We recognize that our people are our strength and the diverse talents they bring to our global workforce are directly linked to our success. We are an equal opportunity employer and place a high value on diversity and inclusion at our company. We do not discriminate on the basis of any protected attribute, including race, religion, color, national origin, gender, sexual orientation, gender identity, gender expression, age, marital or veteran status, pregnancy or disability, or any other basis protected under applicable law. We also make reasonable accommodations for applicants' and employees' religious practices and beliefs, as well as mental health or physical disability needs. Visit our FAQs for more information about requesting an accommodation.
About the Team
Our professionals in our Corporate Functions cover a diverse range of areas from finance and risk to human resources and marketing. Our corporate teams are an essential part of our company, ensuring that we're setting our businesses, clients, customers and employees up for success.
Top Skills
AWS
Dbt
SQL
Similar Jobs at JPMorganChase
Financial Services
As a Data Scientist Senior Associate, you'll develop fraud detection strategies, analyze data for operational efficiency, and collaborate with risk teams to improve fraud processes and compliance.
Top Skills:
Cloud-Native Microservices ArchitectureData ScienceFraud Analytics
Financial Services
As a Team Leader, oversee private equity fund administration, prepare financial statements, support investor relations, and lead team collaborations.
Top Skills:
Accounting SoftwareExcelInvestran
Financial Services
The role involves overseeing fund accounting operations, resolving transaction issues, managing a team, and improving processes for efficiency.
Top Skills:
Fund AccountingSecurities Administration
What you need to know about the Boston Tech Scene
Boston is a powerhouse for technology innovation thanks to world-class research universities like MIT and Harvard and a robust pipeline of venture capital investment. Host to the first telephone call and one of the first general-purpose computers ever put into use, Boston is now a hub for biotechnology, robotics and artificial intelligence — though it’s also home to several B2B software giants. So it’s no surprise that the city consistently ranks among the greatest startup ecosystems in the world.
Key Facts About Boston Tech
- Number of Tech Workers: 269,000; 9.4% of overall workforce (2024 CompTIA survey)
- Major Tech Employers: Thermo Fisher Scientific, Toast, Klaviyo, HubSpot, DraftKings
- Key Industries: Artificial intelligence, biotechnology, robotics, software, aerospace
- Funding Landscape: $15.7 billion in venture capital funding in 2024 (Pitchbook)
- Notable Investors: Summit Partners, Volition Capital, Bain Capital Ventures, MassVentures, Highland Capital Partners
- Research Centers and Universities: MIT, Harvard University, Boston College, Tufts University, Boston University, Northeastern University, Smithsonian Astrophysical Observatory, National Bureau of Economic Research, Broad Institute, Lowell Center for Space Science & Technology, National Emerging Infectious Diseases Laboratories