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.