East West Bank

Senior Business Data Analyst

East West Bank Pasadena, CA

East West Bank

Senior Business Data Analyst

East West Bank Pasadena, CA
No longer accepting applications

Introduction

Since 1973, East West Bank has served as a pathway to success. With over 120 locations across the U.S. and Asia, we are the premier financial bridge between the East and West. Our teams of experienced, multi-cultural professionals help guide businesses and community members on both sides of the Pacific looking to explore new markets and create new opportunities, and our sustained growth and expertise in industries like real estate, entertainment and media, private equity and venture capital, and high-tech help build sustainable businesses and expand our associates’ potential for career advancement.

Headquartered in California, East West Bank (Nasdaq: EWBC) is a top performing commercial bank with an exclusive focus on the U.S. and Greater China markets. With a strong foundation, and enterprising spirit and a commitment to absolute integrity, East West Bank gives people the confidence to reach further.

Overview

The Financial Planning & Analysis (FP&A) department drives the company’s annual planning and budgeting cycle and is central to the Bank’s executive management reporting, financial forecasts, profitability assessment, and incentive plan performance reporting activities.

The Senior Business Data Analyst will support FP&A’s reporting, dashboarding, and automation development efforts. We’re looking for someone who is comfortable wrangling and reconciling data with exceptional SQL and Excel skills. If you’re someone with a technical and curious mindset who enjoys working with data, we’d love to hear from you!

Responsibilities

  • Act as a thought leader on data projects, conceptualizing and implementing models/solutions
  • Develop, maintain, and optimize SQL scripts, ETL pipelines, dashboards
  • Perform ad-hoc and repeatable analysis to measure and interpret business trends
  • Troubleshoot and root cause data anomalies
  • Support reconciliation and validation processes between multiple system sources
  • Drive efficiency by streamlining and automating recurring procedures
  • Perform system administrator-level tasks for various applications
  • Effectively communicate and document (technical and non-technical) requirements/analysis

Qualifications

  • 3-6 years of professional experience in a financial, business, or data analytical role
  • Advanced Microsoft SQL skills (aggregate & window functions, nested joins, query optimization)
  • Advanced Excel skills (lookups, nested functions, pivots, VBA exp a plus)
  • Basic Python skills (operators, loops, lists)
  • Data visualization experience (Power BI, Tableau, pivot chart, etc.)
  • Strong problem-solving, attention to detail, communication, and organization skills
  • Able to handle ambiguity, tight deadlines, and competing objectives

Compensation

The base pay range for this position is USD $68,000.00/Yr. - USD $110,000.00/Yr. Exact offers will be determined based on job-related knowledge, skills, experience, and location.
  • Seniority level

    Mid-Senior level
  • Employment type

    Full-time
  • Job function

    Information Technology
  • Industries

    Banking

Referrals increase your chances of interviewing at East West Bank by 2x

See who you know

Get notified about new Data Analyst jobs in Pasadena, CA.

Sign in to create job alert

Similar jobs

People also viewed

Looking for a job?

Visit the Career Advice Hub to see tips on interviewing and resume writing.

View Career Advice Hub