• Senior Business Analyst

    Location US-CA-Pasadena
    Job ID
    2017-4494
    Category
    Banking Operations/Back Office
    Position Type
    Full-Time
  • Overview

    For more than 40 years, East West Bank has served as a pathway to success. With over 130 locations across the U.S. and Greater China, 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, high-tech and aviation help build sustainable businesses and expand our employees’ 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 assets of $38.1 billion, we’re ranked among the 30 largest banks in the United States and currently top 5 in “America’s 100 Best Banks” by Forbes, a list where we've consistently been in the top 15 since 2010. With a strong foundation, an enterprising spirit and a commitment to absolute integrity, East West Bank gives people the confidence to reach further.


     


     


    Primary Responsibilities:


     



    • 3-5 years of experience in data/business analysis

    • Data Experience

      • Solid understanding of using SQL for database management and analysis

      • Experience documenting technical architecture and requirements

      • Designed database models with Star Schema

      • ETL data including importing and staging data for reporting

      • Experience automating manual Excel processes with SQL Server

      • Experience with automation using PowerShell and Visual Studio

      • Understanding of dimensions and fact tables

      • Data testing and validation experience with front end BI reporting

      • Tableau experience a plus

        • Designing and building executive dashboards

        • Data source management





    • Hyperion experience

      • Experience with Hyperion PBCS and EPM Automate

      • Usage of Data Management with Data Load Rules and Data Mappings in PBCS

      • Writing and modification of Rules with Essbase

      • Security previsioning

      • Maintaining dimensions

      • Report writing/maintenance experience in PBCS

      • Batch report publishing and maintenance of Report Repository

      • Ability to create and maintain forms in PBCS



    • General experience

      • Familiarity of needs of executive reporting and client reporting

      • Experience in communicating with IT/Technical teams with requirements and testing




     

    Qualifications

     

    Options

    Sorry the Share function is not working properly at this moment. Please refresh the page and try again later.
    Share on your newsfeed

    Connect With Us!

    Not ready to apply? Connect with us for general consideration.