Business Intelligence Analyst East West Bank
El Monte, CA

Job Description

Introduction

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 $41 billion, we've ranked among the 30 largest banks in the United States. And since 2010, we have been recognized by Forbes as one of the top 15 best banks in America. With a strong foundation, and enterprising spirit and a commitment to absolute integrity, East West Bank gives people the confidence to reach further.

Overview

This position helps implementing East West Bank enterprise-wide data and information architecture to support business intelligence and data warehouse efforts. Responsibilities will include SSRS reporting and building visual dashboard using Tableau. Help the Bank adopt and organize data. He or she will improve existing systems to make it easier to manage and deliver information. Combining their knowledge of technology and business management to deliver state-of-the-art business intelligence solutions, improve efficiency. Produce financial and market intelligence by querying data repositories and generating periodic reports. Devise methods for identifying data patterns and trends in available information sources.

Responsibilities

* 3+ years of hands on experience working with large scale databases
* Design, develop and maintain reports, ad hoc queries and analytical tools.
* Produce metrics and other report objects and components.
* Analyze competitive market strategies through analysis of related product, market, or share trends.
* Synthesize current business intelligence or trend data to support recommendations for action.
* Collect business intelligence data from available industry reports, public information, field reports, or purchased sources
* Perform ongoing monitoring, automation and refinement of reports and BI solutions.
* Perform daily monitoring of data loads, automated production reports and automated report distributions through email.
* Work with BI Management to identify and resolve data related issues.
* Work with business departmental teams to help them define and document business requirements for new metrics and reports.
* Participate in process reviews and enhancements.
* Provide analysis and issue resolution on business reported concerns.
* Participate in design and delivery of dashboards and various self-service business intelligence solutions. conclusions or approaches to problems.
* Adheres to all policies and procedures concerning all confidential information including but not limited to internal use and restricted information

Qualifications

* Understanding of relational databases and SQL.
* Good business understanding and ability to convert complex business needs into efficient and accurate queries
* Ability to use logic and reasoning to identify the strengths and weaknesses of alternative solutions, conclusions or approaches to problems.
* Job requires analyzing information and using logic to address work-related issues and problems.
* Excellent communication, interpersonal and organizational skills
* Must enjoy working in a fast-paced teamwork environment and dealing with a variety of people

Desired

* Banking systems experience.
* Team Foundation Server or a similar source control software experience.
* Business Intelligence (BI) tools (i.e. SAS, Tableau, Business Objects, PowerView)
* Technical skills:
* C#, VB.NET
* R Integration with Tableau
* 2 years of SQL Server BI development (SSRS/SSIS) experience
* T-SQL knowledge SQL query development using MS SQL 2008, 2012 and 2016