This position helps implementing East West Bank enterprise-wide data and information architecture to support business intelligence and data warehouse efforts. Responsibilities will include implementation of physical database, data & user security; SSRS reporting, and building visual dashboard using Power. BI. 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 mana... more details
Business Intelligence Developer II
LocationUS-CA-El Monte
Job ID
2024-11109
Category
Information Technology
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
This position helps implementing East West Bank enterprise-wide data and information architecture to support business intelligence and data warehouse efforts. Responsibilities will include implementation of physical database, data & user security; SSRS reporting, and building visual dashboard using PowerBI. 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
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 design and delivery of dashboards and various self-service business intelligence solutions.
Enforces established documentation guidelines and best practices.
Maintains a high degree of business functional knowledge and current automated technologies and tools.
Adheres to all policies and procedures concerning all confidential information including but not limited to internal use and restricted information
Qualifications
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
Desired
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
Compensation
The base pay range for this position is USD $105,000.00/Yr. - USD $130,000.00/Yr. Exact offers will be determined based on job-related knowledge, skills, experience, and location.
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.
Job Abstracts is an independent Job Search Engine. Job Abstracts is not an agent or representative and is not endorsed, sponsored or affiliated with any employer. Job Abstracts uses proprietary technology to keep the availability and accuracy of its job listings and their details. All trademarks, service marks, logos, domain names, and job descriptions are the property of their respective holder. Job Abstracts does not have its members apply for a job on the jobabstracts.com website. Additionally, Job Abstracts may provide a list of third-party job listings that may not be affiliated with any employer. Please make sure you understand and agree to the website's Terms & Conditions and Privacy Policies you are applying on as they may differ from ours and are not in our control.
Welcome to Job Abstracts
We would like to take a second to Welcome You to Job Abstracts, the nation’s largest Pure Job Board. With over 3.1 million job listings from 15,000+ Companies & Organizations, we help job searchers find careers that match their interests. As an anonymous user, you have probably discovered how easy our system is to use. However, you have just scratched the surface of what we can offer.
We encourage you to Register so you can use our most powerful features: searching with multiple terms, setting up multiple locations, establishing favorite companies, and accessing your search history. If you find a job you like, you can apply directly for it, and then, keep notes on it. We will also keep a lookout for jobs that match your search terms and email you when we find something you may like.
You can register for free and the system is free to use. If you like our system so far, click on Register and unlock the power required by serious job searchers.
Any time you conduct a search, the system shows you job matches, ranked by their Relevance Score (RS).
The score is calculated by a proprietary algorithm that uses Intelligent Machine Learning.
The Relevance Score tells you how well the job opportunity matches your search term or terms.
When not logged in, the system is limited to one search term. Scores for single term matches are usually lower.
When you register, log in, and set up multiple terms prioritized by importance, the jobs found for you will receive a much higher Relevance Score.
