This job is responsible for performing complex analysis and modeling to minimize loss exposure and negative impacts to the customer experience. Key responsibilities include utilizing a variety of systems such as Excel, SAS, SQL, Tableau, and other relational data bases to provide analytical support on strategies and ensure goals are met. Job expectations include evaluating data to assess potential fraud risk and create mitigation strategies.
Line of Business Job Description:
Analyst role supporting Anti-Money Laundering Operations, which is a highly regulated business function within the bank. Responsible for performing management and regulatory reporting. Utilizes a variety of systems including, but not limited to Excel, Access, Visual Basic, SAS at an intermediary level. Provides analytical support on various strategies to ensure company goals are met. Coordinates the production of performance reports and updates for senior management. May utilize established databases to gather data and will need be very effective creating executive summaries. Duties include the regular use of discretion and independent judgment. 5 years’ experience preferred.
Responsibilities:
- Analyzes and interprets large sets of raw data to recommend ways to help the business achieve desired outcomes and make informed business decisions
- Defines, gathers, analyzes, and interprets data using applications and technologies to forecast future trends and communicates to leaders and partners the statistical analysis results and predictions
- Coordinates the production of product performance reports and updates for senior management
Required Qualifications:
- Strong understanding of SQL, rational databases, and normalization.
- Proficient with querying languages with extensive data sets, such as ANSI-SQL, T-SQL, etc.
- Ability to analyze large data sets, develop reports and troubleshoot data issues from single or multiple systems
- Ability to perform and document data analysis, data validation, and data mapping/design
- Excellent analytical / problem solving / process design skills
- Strong analytical skills that demonstrate ability to learn how to navigate systems, access data, reconcile numbers from different sources, identify discrepancies and understand drivers of change within data
- Strong knowledge in Excel (macros, vba, pivot tables, etc.)
- Experience with business intelligence tools for report development, analytics, and/or visualizations (i.e. Tableau, MicroStrategy, SSRS, etc. )
- Work independently as well as in a team environment
- Own tasks from start through completion
Desired Qualifications:
- 5+ years of business intelligence experience (i.e. Tableau, MicroStrategy, SSRS, etc.)
- Proficient with querying languages, such as ANSI-SQL, T-SQL, etc.
- Ability to detect anomalies contained within data sets
- Ability to communicate effectively both horizontally and vertically
- Self-motivated, operates with a sense of urgency and strong attention to detail
Skills:
- Business Intelligence
- Data and Trend Analysis
- Fraud Management
- Monitoring, Surveillance, and Testing
- Research
- Business Analytics
- Data Quality Management
- Data Visualization
- Problem Solving
- Written Communications
- Analytical Thinking
- Collaboration
- Critical Thinking
- Innovative Thinking
- Oral Communications
1st shift (United States of America)