Ccbta Data Architect Senior Associate

JPMorgan Chase JPMorgan Chase · Banking · Columbus, OH +1 · Consumer & Community Banking

This role is for a Senior Associate Data Architect on the Core Treasury Analytics team at JPMorgan Chase. The primary focus is on designing and developing the Treasury DataMart, involving transaction-level data enrichment, transformation, and creating a repository for treasury analytics. The role requires experience in data architecture, financial reporting, and data analytics, with proficiency in tools like Python, SAS, SQL, and Alteryx. It involves working with relational databases, optimizing data pipelines, and collaborating with the Technology Team to deliver data domains into the Finance Data Mart. The role also involves supporting senior management with business reviews, OKRs, and ad-hoc deliverables, requiring strong communication and analytical skills.

What you'd actually do

  1. 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.
  2. 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.
  3. 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.
  4. 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.
  5. 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.

Skills

Required

  • 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

Nice to have

  • 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