AML / OFSAA Data & Business Analyst

Qode•Columbia, SC

About The Position

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

Requirements

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.

Nice To Haves

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.

Responsibilities

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.
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.
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.
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.
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.
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.