AFC Systems Data Analyst at Apple Bank in New York City, NY

AFC Systems Data Analyst Location: New York, NY New York, NY (Hybrid) Salary Range: $100,000 - $120,000 The AFC Systems Unit (SU) is a subunit team within Apple Bank’s (the Bank) Anti-Financial Crime (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/ABC 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 subunit. 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 model 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. ESSENTIAL DUTIES & RESPONSIBILITIES The AFC Systems Data Analyst will: 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. ADDITIONAL DUTIES & RESPONSIBILITIES The AFC Systems Data Analyst will also: 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, EDUCATION, & EXPERIENCE The AFC Systems Data Analyst should have: 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. ADDITIONAL SKILLS & EXPERIENCE The AFC Systems Data Analyst may have: 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). Visa sponsorship not available. We are an equal opportunity employer and do not discriminate on the basis of race, color, religion, sex, sexual orientation, gender identity, national origin, disability, military and/or veteran status, or any other Federal or State legally-protected classes.