Data Architect III

DescriptionWe 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 experienceStrong 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 skillsExperience with data architecture in a fintech environment.Experience in cloud solutions, ideally AWSBasic data engineering expertiseFamiliarity with data meshFamiliarity analytics and dashboarding #ICBCareer