Business System Analyst

Job Title: Business System Analyst

Location: New York City, NY or Fort Mill, SC

Duration: Full-time

Key Responsibilities

AML & Regulatory Domain

• Apply strong AML domain knowledge to support transaction monitoring, customer risk, and regulatory reporting initiatives.
• Collaborate with Compliance and Financial Crimes teams to translate regulatory requirements into data and system specifications.

OFSAA Data Model & Mapping

• Develop and maintain a deep understanding of the OFSAA data model, including staging, processing, and reporting layers.
• Perform source-to-target data mapping between upstream source systems and OFSAA tables.
• Document transformation logic, data rules, and business assumptions.

Data Lineage & Documentation

• Create and maintain end-to-end data lineage documentation across source systems, OFSAA, and downstream reports.
• Ensure documentation meets internal audit, regulatory, and governance standards.

Customization & Upgrade Support

• Build and maintain a customization inventory for OFSAA implementations.
• Perform regression impact analysis for OFSAA upgrades, patches, and configuration changes.
• Identify impacted objects, reports, mappings, and downstream dependencies.

UAT Planning & Execution

• Lead and support UAT planning, including test strategy, test scenarios, and test case creation.
• Coordinate UAT execution with business, compliance, and QA teams.
• Track defects, manage triage, and support issue resolution.

Reporting Validation

• Perform pre- and post-upgrade reporting validation to ensure data accuracy, completeness, and consistency.
• Validate AML reports, metrics, and regulatory outputs against expected results.
• Support audit and compliance inquiries related to reporting accuracy.

Required Qualifications

• Bachelor’s degree in Finance, Information Systems, Computer Science, or a related field.
• Strong AML domain knowledge within financial services (broker-dealer or banking experience preferred).
• Hands-on experience with Oracle OFSAA, including data models and configurations.
• Proven experience in source-to-target mapping, data analysis, and data validation.
• Experience creating data lineage and functional documentation.
• Hands-on involvement in UAT planning, execution, and defect management.
• Experience performing regression and impact analysis during system upgrades.
• Strong SQL skills for data analysis and validation.
• Excellent communication and stakeholder management skills.

Preferred Qualifications

• Experience in a broker-dealer or wealth management environment.
• Prior experience supporting AML system upgrades or migrations.
• Familiarity with regulatory expectations from FINRA, SEC, or similar bodies.
• Experience working in Agile or hybrid delivery models.