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
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.Compensation
The base pay range for this position is USD $69,000.00 / Yr. - USD $100,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.