AFC Systems Data Analyst
Apple Bank is a financial institution seeking an AFC Systems Data Analyst to join their Anti-Financial Crime Department. The role involves analyzing data from AFC systems, developing reports, identifying data quality issues, and collaborating with IT partners and external vendors to support compliance efforts.
Responsibilities
- 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 AFC 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
Skills
- A bachelor's degree, preferably in computer science, information technology or a related field with experience in systems administration, analysis, report building and management, databases or other 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 developing scripts in Python
- 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 AFC regulations and requirements
- Minimum 1 year of experience with a data visualization tool (e.g., Tableau, Spotfire, Power BI, etc.)
- Experience with leveraging AI to automate manual processes and increase operational efficiency
- Familiarity with financial data
- A professional certification (i.e. CAMS)
Company Overview