Data Architect Iii

Job Category Architecture 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 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 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