200+ applicants

Company

Original Job Post

East West Bank · 6 days ago

Business Intelligence Developer II

El Monte, CA

Full-time

Onsite

Mid, Senior Level

$105K/yr - $130K/yr

5+ years exp

Wonder how qualified you are to the job?

Maximize your interview chances

BankingFinance

H1B Sponsorship

Comp. & Benefits

Insider Connection @East West Bank

Discover valuable connections within the company who might provide insights and potential referrals, giving your job application an inside edge.

Responsibilities

Design, develop bank-wide dashboard using PowerBI

Design, develop and maintain reports, ad hoc queries, and analytical tools

Produce metrics and other report objects and components

Perform ongoing monitoring, automation, and refinement of reports and PowerBI

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 the design and delivery of dashboards and various self-service business intelligence solutions

Enforce established documentation guidelines and best practices

Maintain a high degree of business functional knowledge and current automated technologies and tools

Adhere to all policies and procedures concerning all confidential information including but not limited to internal use and restricted information

Qualification

Find out how your skills align with this job's requirements. If anything seems off, you can easily click on the tags to select or unselect skills to reflect your actual expertise.

Large-scale databasesPowerBISQL Server BI developmentSSRSSSIST-SQLMS SQLRelational databasesKimball MethodologyTeam Foundation ServerSource control softwareQuery developmentDeadline managementCommunicationInterpersonal skillsOrganizational skillsPrioritizeWork well under pressureTeamworkBanking systemsLoan servicingAzureAWSBusiness Intelligence toolsSASTableauBusiness ObjectsPowerViewC#VB.NET

Required

5+ years of hands-on experience working with large-scale databases

3 years hands-on experience using PowerBI

Requires 3 years of SQL Server BI development (SSRS/SSIS) experience

Solid T-SQL knowledge SQL query development using MS SQL

Thorough understanding of relational databases and Kimball Methodology

Team Foundation Server or a similar source control software experience

Good business understanding and ability to convert complex business needs into efficient and accurate queries

Excellent communication, interpersonal, and organizational skills

Ability to prioritize, meet deadlines and to work well under pressure

Must enjoy working in a fast-paced teamwork environment and dealing with a variety of people

Preferred

Banking systems or loan servicing experience

Cloud experience with Azure or AWS

Business Intelligence (BI) tools (i.e. SAS, Tableau, Business Objects, PowerView)

Technical skills: C#, VB.NET, Python, Powershell script, R programming

Company

East West Bank

Glassdoor

4.1

East West Bancorp is a publicly owned company with $22 billion in assets. The Company’s wholly owned subsidiary, East West Bank, is one of

Founded in 1998

Pasadena, California, USA

1,001-5,000 employees

http://eastwestbank.com

H1B Sponsorship

East West Bank has a track record of offering H1B sponsorships. Please note that this does not guarantee sponsorship for this specific role. Below presents additional info for your reference. (Data Powered by US Department of Labor)

Distribution of Different Job Fields Receiving Sponsorship

Trends of Total Sponsorships

2023 (27)

2022 (51)

2021 (54)

2020 (43)