Job Title: AML / OFSAA Data & Business Analyst
Location: New York City, NY or Fort Mill, SC
Employment Type: 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.
