Consumer & Community Banking - Data Architect Senior Associate

JPMorgan Chase & Co.; United States; On-site; USD 150,000 - 210,000; Full time

Job summary

JPMorgan Chase & Co. in the United States seeks a Data Domain Architect Lead for Core Treasury Analytics to design and develop the Treasury DataMart, enabling streamlined and intelligence-driven insights for senior management.

You will collaborate across Treasury, Technology and Finance, tackle ambiguous problems, and help automate analytics processes, with exposure to high-profile decision making on a trillion-dollar retail deposit portfolio.

Qualifications

• 4+ years of full-time work experience in data architecture, financial reporting system or data analytics.
• Advanced experience with BI analytics and data wrangling tools (Python, SAS, SQL, Alteryx).
• Experience with relational databases including optimizing data pipelines to load, process, transformer and stage data for intelligence generation ensuring data quality through profiling, cleansing and validation
• Practical knowledge in financial analysis, competitive analytics and data management
• Bachelor's degree in MIS, Computer Science, Finance, Accounting, Mathematics, Engineering, Statistics or other quantitative, analytical or financial subject areas
• Advanced Excel use including structured process to prototype and solution analysis which is easy to follow, helping to answer complex and/or ambiguous questions
• Working knowledge of retail banking and products
• Excellent communication skills both written (Presentation/PowerPoint, Memo/Word) and verbal with experience in debating complex concepts with senior leaders

Responsibilities

• Play a pivotal role in transaction-level data enrichment and transformation. You will use analytics to derive key insights on money movement and consumer health, making a tangible impact throughout the organization.
• Dive deep into our financial reporting platforms and develop a key repository for treasury analytics. You'll promote key analysis and provide a strategic repository for model assumption inputs, becoming a go-to expert in the field.
• Hone your skills in delivering high-impact, well-structured analytical solutions. Support the team's analytical perspectives with finance and non-finance audiences alike, sharing compelling messages with our senior leaders.
• Leverage existing tools and techniques to create repeatable processes for intelligence creation. Integrate the newest technology advancements to further reduce errors and maximize the speed to insights, promoting innovation at every turn.
• Work closely with our Technology Team to design and deliver cutting-edge data domains into the Finance Data Mart. Your efforts will bring together essential data categories, integrally supporting the Treasury function's analytical and reporting needs with precision and efficiency.
• Gain unparalleled exposure to core finance and banking skills, including interest rate risk, capital, liquidity, transfer pricing, valuation, and strategic analytics, exploring a wide range of elements of our fortress balance sheet.

Skills

BI analytics tools

Relational databases & pipelines

Financial analysis

Advanced Excel

Retail banking knowledge

Presentation skills

Education

Bachelor's degree in quantitative field

Tools

AWS

Databricks

Snowflake

Hyperion Essbase

Dodeca

Tableau

PitchPro

Job description

Are you ready to make a significant impact across the Consumer & Community Banking finance organization? Join our Core Treasury Analytics team and play a pivotal role in designing and developing the Treasury DataMart.This is your chance to empower streamlined and intelligence-driven perspectives to senior management, contributing to high-profile decision making on both core and topical challenges.

As a Data Domain Architect Lead in Core Treasury, you will have the unique opportunity to work across the organization, collaborating with key stakeholders in Treasury, Technology and Finance. You will gain direct exposure to senior business leaders and help to streamline and automate our analytical and intelligence processes. You will provide a consultative perspective to drive improvements in our data framework that support key analytics and models, focusing on our $1+ Trillion retail deposit portfolio.You will tackle ambiguous problem statements, working independently and forging deep connections across the firm creating a lasting impact for the team and entire organization!

Job Responsibilities:

• Play a pivotal role in transaction-level data enrichment and transformation. You will use analytics to derive key insights on money movement and consumer health, making a tangible impact throughout the organization.
• Dive deep into our financial reporting platforms and develop a key repository for treasury analytics. You'll promote key analysis and provide a strategic repository for model assumption inputs, becoming a go-to expert in the field.
• Hone your skills in delivering high-impact, well-structured analytical solutions. Support the team's analytical perspectives with finance and non-finance audiences alike, sharing compelling messages with our senior leaders.
• Leverage existing tools and techniques to create repeatable processes for intelligence creation. Integrate the newest technology advancements to further reduce errors and maximize the speed to insights, promoting innovation at every turn.
• Work closely with our Technology Team to design and deliver cutting-edge data domains into the Finance Data Mart. Your efforts will bring together essential data categories, integrally supporting the Treasury function's analytical and reporting needs with precision and efficiency.
• Gain unparalleled exposure to core finance and banking skills, including interest rate risk, capital, liquidity, transfer pricing, valuation, and strategic analytics, exploring a wide range of elements of our fortress balance sheet.

Required qualifications, skills, and capabilities:

• 4+ years of full-time work experience in data architecture, financial reporting system or data analytics
• Advanced experience with business intelligence analytic and data wrangling tools such a Python, SAS, SQL, and Alteryx
• Experience with relational databases including optimizing data pipelines to load, process, transformer and stage data for intelligence generation ensuring data quality through profiling, cleansing and validation
• Practical knowledge in financial analysis, competitive analytics and data management
• Bachelor's degree in MIS, Computer Science, Finance, Accounting, Mathematics, Engineering, Statistics or other quantitative, analytical or financial subject areas
• Advanced Excel use including structured process to prototype and solution analysis which is easy to follow, helping to answer complex and/or ambiguous questions
• Working knowledge of retail banking and products
• Excellent communication skills both written (Presentation/PowerPoint, Memo/Word) and verbal with experience in debating complex concepts with senior leaders

Preferred qualifications, skills, and capabilities:

• Experience developing in AWS, Databricks and Snowflake
• The ideal candidate will be highly self-motivated, thrive in a dynamic environment with shifting priorities, and have passion and intellectual curiosity to find and capture business value
• Familiarity with Hyperion Essbase, Dodeca, PitchPro, Tableau and relational data structures
• Desire and/or progress towards MBA, CFA charter, CPA, CTP or other financial certifications

To be eligible for this role, you must be authorized to work in the United States. We do not offer any type of employment-based immigration sponsorship for this role. Likewise, JPMorgan Chase & Co. will not provide any assistance or sign any documentation in support of any other form of immigration sponsorship or benefit, including optional practical training (OPT) or curricular practical training (CPT).