Finance Data Mart - Domain Data Architect

JPMorgan Chase JPMorgan Chase · Banking · Wilmington, DE +1 · Consumer & Community Banking

JPMorgan Chase is seeking a Domain Data Architect Lead for their Finance Data Mart team. This role involves modernizing the data environment using Databricks and ThoughtSpot to enable the Finance function to access and analyze essential data across various business areas. Responsibilities include implementing and optimizing the data mart, designing schemas, developing ETL processes, and collaborating with stakeholders to design reporting and analytics solutions. Requires a minimum of seven years of experience in data architecture, data warehousing, and data integration in financial services, with expertise in SQL, Data Modeling, and ERWIN.

What you'd actually do

  1. Implement and optimize the Finance Data Mart using Databricks and ThoughtSpot for analytics and reporting
  2. Design efficient data mart schemas consolidating key data categories from multiple source systems
  3. Collaborate with data engineers, analysts, and technical specialists to gather and analyze business requirements
  4. Develop and optimize ETL processes and data pipelines using Databricks
  5. Partner with Area Product teams and stakeholders to design reporting and analytics solutions and support the Finance function across diverse business areas

Skills

Required

  • data architecture
  • data warehousing
  • data integration
  • financial services
  • Databricks
  • ThoughtSpot
  • SQL
  • Data Modeling
  • ERWIN
  • star schema
  • snowflake schema
  • data management
  • data lineage
  • data dictionaries

Nice to have

  • Amazon Web Services
  • AWS Certifications
  • Snowflake
  • cloud data warehouses
  • data catalog systems
  • Sigma
  • Tableau
  • Alteryx
  • Essbase

What the JD emphasized

  • Minimum seven years of experience in data architecture, data warehousing, and data integration in financial services
  • Bachelor’s degree in Computer Science, Information Systems, or related discipline
  • Expertise in designing scalable data mart architectures, including star and snowflake schemas
  • Strong knowledge of data management, data lineage, and data dictionaries
  • Proven track record in managing and delivering complex data projects