Data Warehouse Business Analyst

ABeam Consulting

• $100K — $120K *
Finance & Insurance
5 - 7 years of experience
Job Overview by Ladders

Qualifications

  • 7+ years in Financial Services tech with focus on Data Warehouse and Integration
  • Experience in documenting business and system requirements
  • Strong knowledge of data flows between Market Systems and applications
  • Ability to coordinate stakeholders across business and technology
  • Excellent communication and documentation skills
  • Effective in global teams, particularly with U.S. and Asia
  • Proficiency in Microsoft Office, especially Excel
  • Bachelor's degree or equivalent experience; business-level proficiency in Japanese preferred.

Responsibilities

  • Support impact assessment and data analysis for Capital Markets transformation
  • Conduct data mapping and design integration between market systems and platforms
  • Collaborate with international business and technology stakeholders
  • Assist in the discovery and implementation phases of projects
  • Document business and system process requirements
  • Coordinate with various project stakeholders to ensure alignment
  • Analyze data flows and provide actionable insights across functions.

Benefits

  • Medical, Dental, and Vision coverage
  • Disability and Life Insurance
  • Flexible spending accounts
  • Flextime off policy
  • 401(k) plan with employer match
Full Job Description
Data Warehouse Business Analyst

Position Overview

Candidate will support a Capital Markets transformation program at a leading commercial bank as a Data Warehouse (DWH) Business Analyst. The role will focus on impact assessment, data analysis, data mapping, and integration design between market systems and downstream platforms. The candidate will work closely with business and technology stakeholders across international, U.S. Branch, and Capital Markets functions to support the discovery and implementation phases of the program.

Minimum Qualifications
  • 7+ years of experience in Financial Services technology projects with a strong focus on Data Warehouse, Data Platform, and Data Integration business analysis
  • Experience gathering and documenting business and system requirements
  • Strong understanding of data flows between Market Systems and downstream applications
  • Experience coordinating business, technology, and data stakeholders
  • Excellent communication and documentation skills
  • Ability to work effectively in a global environment with teams in Asia and the U.S.
  • Proficiency in Microsoft Office tools, especially Excel (data entry, formatting, and basic functions)
  • Bachelor's degree or above, OR equivalent practical experience
  • Ability to travel as needed
  • Business-level proficiency in Japanese and English is preferred
  • Eligible to work in the U.S.

Desired Qualifications
  • Experience supporting Capital Markets, Treasury, Rates, or FX projects
  • Experience with data mapping, data lineage, and impact assessment
  • Experience with Databricks, Kafka, Event Hub, or similar data integration technologies
  • Strong SQL and data analysis skills
  • Knowledge of event-driven architecture and real-time data integration
  • Knowledge of Regulatroy Reporting
  • Experience working on cross-border projects involving Japan and overseas offices

ABeam offers a comprehensive benefits package to our full-time employees
• Medical
• Dental
• Vision
• Disability & Life Insurance
• Flexible spending accounts
• Flextime off
• 401(k) with employer match

Similar Jobs

More Jobs at ABeam Consulting

More Finance & Insurance Jobs

Find similar Data Warehouse Business Analyst jobs: