Data Analyst

Overview

On Site
USD 71,000.00 - 85,000.00 per year
Full Time

Skills

Finance
Media
Private Equity
Venture Capital
Business Intelligence
Internal Auditing
Microsoft Power BI
Dashboard
Usability
Data Analysis
Auditing
Data Collection
Internal Control
SAP BASIS
Business Operations
Testing
Data Extraction
Storage
Reporting
Banking
Information Systems
Statistics
Business Analytics
Mathematics
Economics
Computer Engineering
Science
Data Science
Python
R
SQL
Microsoft Excel
Technical Writing
Analytical Skill
Conflict Resolution
Problem Solving
Management
Organized
Attention To Detail
Work Ethic
Legal
Authorization

Job Details

Introduction

Since 1973, East West Bank has served as a pathway to success. With over 110 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 a strong foundation, an enterprising spirit and a commitment to absolute integrity. East West Bank gives people the confidence to reach further.

Overview

The Data Analyst will develop data analytics and business intelligence to improve the quality of control testing and increase the risk, control, and regulatory coverage across the enterprise to support internal audit activities in accordance with the Standards for the Professional Practice of Internal Auditing. Responsibilities will include gathering, manipulating, and synthesizing data and other relevant information to draw conclusions and make recommendations.

Responsibilities

  • Build and execute data analytics to support audit objectives, using tool such as Excel, SQL, Power BI, Python and others.
  • Query and analyze small and large data sets to discover and analyze patterns, identify anomalies, profile and reveal relationships from banking data.
  • Assist with the day-to-day management, maintenance, and enhancement of existing Power BI dashboards, ensuring accuracy, usability, and timely updates for audit and business stakeholders.
  • Assist with data analytics projects and gather and analyze complex and large amounts of data for supporting ongoing audit projects, investigations, management requests, and special projects
  • Extract and collect large data sets from various sources and formats.
  • Interpret and analyze results from data extractions to identifying patterns and trends.
  • Evaluate internal controls and identify deficiencies through the testing of data source, systems, and processes.
  • Define new data collection and analysis processes.
  • Test and validate that key assumptions, data sources, and procedures utilized in measuring and monitoring risk and internal controls can be relied upon on an ongoing basis; and, in the case of transaction testing, to assess that controls are working as intended.
  • Test adherence with Bank's policies and controls, as well as regulatory requirements.
  • Maintain an understanding of business operations, operational risks and regulatory requirements.
  • Anticipate changes in the internal and external environment and adapt the testing program accordingly.
  • Validate the integrity of data, including data extraction, storage, manipulation, processing and analysis.
  • Provides recommendations to streamline tasks and create a more efficient working environment.
  • Report results back to management and relevant team members.
  • Product knowledge in
    • Loans
    • Deposits
    • Banking operations
  • May perform other duties as assigned

Qualifications

  • Bachelor's degree in information systems, statistics, business analytics, math, economics, computer engineering, decision sciences or data sciences or related field with relevant coursework.
  • Strong computing skills with at least one of the following: Python, R, SQL with a strong interest to learn.
  • Proficiency with Excel.
  • Quantitative, analytical, process oriented and troubleshooting skills.
  • Excellent analytical and problem solving skills.
  • Expert technical documentation skills.
  • Analytical and problem solving skills including troubleshooting.
  • Able to work under pressure while managing competing demands and tight deadlines.
  • Well organized with meticulous attention to detail.
  • Can-do attitude, self-motivated and strong work ethic.
  • Self-driven to identify areas of improvement.
  • Must be team-oriented with experience working on interdepartmental team projects.

Applicants must have legal authorization to work in the United States. We do not offer visa sponsorship at this time.

Compensation

The base pay range for this position is USD $71,000.00/Yr. - USD $85,000.00/Yr. Exact offers will be determined based on job-related knowledge, skills, experience, and location.
Employers have access to artificial intelligence language tools (“AI”) that help generate and enhance job descriptions and AI may have been used to create this description. The position description has been reviewed for accuracy and Dice believes it to correctly reflect the job opportunity.