Data Warehouse Business Analyst

ABeam Consulting; Irving (TX); On-site; USD 90,000 - 120,000; Full time

Job summary

ABeam Consulting is seeking a Data Warehouse Business Analyst to support a Capital Markets transformation program at a leading commercial bank. You will focus on impact assessment, data analysis, data mapping, and integration design between market systems and downstream platforms.

You will collaborate with business and technology stakeholders across international, U.S. branches, and Capital Markets functions to support discovery and implementation phases of the program.

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 travel as needed.
• Business-level proficiency in Japanese and English is preferred.
• Eligible to work in the U.S.

Responsibilities

• Support a Capital Markets transformation program with data analysis, data mapping, and impact assessment.
• Define integration design between market systems and downstream platforms.
• Collaborate with business and technology stakeholders across international, U.S. Branch, and Capital Markets functions.
• Support discovery and implementation phases of the program.

Skills

Data Warehouse

Data Integration

SQL

Data analysis

Communication

Education

Bachelor’s degree or above, OR equivalent practical experience

Tools

Databricks

Kafka

Event Hub

Job description

Data Warehouse Business Analyst

At ABeam Consulting, you will be a part of the next digital revolution. ABeam's success is created from the contributions of each of our valued employees. At ABeam, you are not just a number! Our employees work together with all tiers of the organization. Through our collective efforts, we provide optimal opportunities for growth and development. Each day, you will be presented with a series of challenges that will position you for your personal growth and your professional advancement.

At ABeam Consulting, you will work with a successful client base across a broad spectrum of industries and applications.

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

ABeam Consulting provides all qualified applicants consideration for employment without regard to race, color, religion, sex, sexual orientation, national origin, disability, protected veteran status, or any other legally protected class, in accordance with applicable law.

ABeam Consulting participates in E-Verify.