Salary Range: $103,000- $135,000
The AFC Systems Unit (SU) is a sub-unit team within Apple Bank for Savings’ (the Bank) AFC Department. The SU is a second line function that acts as a primary subject matter expert (SME) concerning all AFC dedicated systems used to support BSA/AML and Sanctions compliance across the Bank. The AFC Systems Data Analyst is a member of the SU and is responsible for the daily operations within the AFC sub-unit.
Specifically, the AFC Systems Data Analyst will analyze the AFC Systems Data and data feeds, review AFC systems performance through the development of standard and ad-hoc reports, identify data quality issues and impacts, data trends, data sampling, data-driven models development, and support optimizations and model validations of the AML and Sanctions systems. The individual will also collaborate with internal Information Technology (IT) partners and external vendors.
- Act as the data SME for all BSA/AML and Sanctions Systems Data and data feeds.
- Support the calibration, tuning, optimization and performance evaluation of transaction monitoring systems.
- Assist in management of data processes, including the development of business requirement documentation, data mapping and validation exercises.
- Develop standard and ad-hoc reports based on AFC users and leadership needs.
- Document data feeds, end-to-end data flows and mapping from source to target.
- Identify data issues and track them to resolution.
- Design custom Structured Query Language (SQL) queries to ensure proper feed validation, including the identification of invalid values, referential integrity of key attributes and other specific logical requirements.
- Assist with risk assessments and model validations of AFC systems from a data perspective.
- Assist with the coordination of responses to internal auditors and external regulators as part of coordinated examinations.
- Assist in the preparation and maintenance of remediation action plans for all AFC systems to continually track resolution status of open actions.
- Assist in the oversight of AFC systems and other related functions to include system upgrades and patches, validation/testing of customer and transaction data feeds into the appropriate AFC systems, and testing of systemic transaction monitoring rule parameters and risk models, at the direction of the Head of AFC Systems.
- Participate in process standardization and improvement discussions with the BSA Officer and process partners.
- Exhibit advanced data analysis and manipulation skills.
- Apply independent judgment in the identification and escalation of key BSA/AML/Sanctions risks.
- Display a high level of professional aptitude and standards.
- Recommend improvements to process in areas of efficiency, control, and work product.
- Participate in committee meetings, as necessary.
- Perform ad-hoc and project support, as required.
- An undergraduate degree, preferably in Computer Science, Information Technology or a related field with experience in systems administration, analysis, report building and management, databases or other directly related experience.
- Minimum 1 year of experience in data analysis and reporting.
- Minimum 1 year of experience with leading database solutions such as Oracle or MS SQL Server.
- Minimum 1 year of experience in the use of SQL queries.
- Excellent verbal, written, and interpersonal communication skills.
- Excellent time management skills with strong focus on attention to detail.
- The ability to work effectively in a team-fostered, multi-tasking environment.
- Minimum 1 year of experience in banking compliance, with a strong emphasis on BSA/AML regulations and requirements.
- Minimum 1 year of experience with a data visualization tool (e.g., Tableau, Spotfire, Power BI, etc.)
- Familiarity with financial data.
- A professional certification (i.e. CAMS).