Senior AFC Systems Data Analyst

Hybrid/ New York, NY Salary Range: $125,000 - $150,000 The AFC Systems Unit (SU) is a subunit team within Apple Bank’s (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/ABC and Sanctions compliance across the Bank. The Senior AFC Systems Data Analyst is a member of the SU and is responsible for the daily operations within the AFC subunit. Specifically, the Senior 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. ESSENTIAL DUTIES & RESPONSIBILITIES The Senior AFC Systems Data Analyst will: Act as the data SME for all BSA/AML/ABC and Sanctions systems data and data feeds. Lead 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 complex 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. Lead the 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. Lead 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. Display a high level of independence and autonomy in self-managing multiple concurrent delivery of work products. ADDITIONAL DUTIES & RESPONSIBILITIES The Senior AFC Systems Data Analyst will also: Exhibit advanced data analysis and manipulation skills. Apply independent judgment in the identification and escalation of key BSA/AML/ABC/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. 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 3 years of experience in data analysis and reporting. Minimum 3 years of experience with leading database solutions such as Oracle or MS SQL Server. Minimum 3 years of experience in the use of SQL queries. Minimum 3 years of experience in banking compliance, with a strong emphasis on BSA/AML regulations and requirements. Minimum 3 years of experience with a data visualization tool (e.g., Tableau, Spotfire, Power BI, etc.). Minimum 3 years of experience with financial data. 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, multitasking environment. ADDITIONAL SKILLS & EXPERIENCE The AFC Systems Data Analyst may have: Experience with a development language (e.g., Python, Java, .Net, etc.) Experience with PL/SQL, Stored Procedures or SSIS packages. 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. Since 1863, Apple Bank has been a stable banking presence in New York City and its surrounding communities. We seek to put the best interests of our customers first and to manage our company prudently and responsibly. When you join the Apple Bank team, you’ll be working with a group of dedicated and talented professionals focused on delivery of an outstanding customer experience. For more than 160 years, Apple Bank has been invested in our customers and communities, striving always to put their best interests first. Along the way, our employees have been the key to our success. Whether you’re just beginning, continuing or changing your career, Apple Bank offers a range of career opportunities. We’ll support you in developing your potential to the fullest, while you contribute to our growth and success. Apple Bank's employment policy is to provide equal opportunity to all persons. The Bank prides itself in having a diverse and inclusive workforce. No employee or applicant for employment will be discriminated against because of race, color, citizenship status, religion, sex, sexual orientation, creed, national origin, age, physical or mental disability, veteran status, political affiliation, domestic violence victim status, predisposing genetic characteristic, or any other Federal or State legally-protected classes. Apple Bank will make reasonable accommodations for known physical or mental limitations of otherwise qualified employees and applicants with disabilities unless the accommodation would impose an undue hardship on the operation of our business. If you are interested in applying for an employment opportunity and feel you need a reasonable accommodation pursuant to the ADA, please contact us at [email protected]. Know Your Rights: https://www.eeoc.gov/sites/default/files/2023-06/22-088_EEOC_KnowYourRights6.12ScreenRdr.pdf The Pay Transparency Notice: https://dol.ny.gov/system/files/documents/2024/04/p688-pay-transparency-law-for-employee.pdf Apply tot his job Apply To this Job