Welcome page

Senior Business Data Analyst

Location US-CA-Pasadena
Job ID
2024-11030
Category
Accounting/Finance
Position Type
Full-Time

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.

Options

<p style="margin: 0px;"><span style="color: #54585a;">Sorry the Share function is not working properly at this moment. Please refresh the page and try again later.</span></p>
Share on your newsfeed


East West Bank is an Equal Opportunity Employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, disability, veteran status, or any other legally protected status. Reasonable accommodations for disability are provided to applicants and employees in accordance with applicable law.