What are the responsibilities and job description for the FTP Data, Allocation, and Outcome Tester-New York , NY (Need to be in office 3 Days a week) position at Acess Global?
Role : FTP Data, Allocation, and Outcome Tester
Location : New York , NY (Need to be in office 3 Days a week)
Job Type : Long term Contract
Job Summary
This resource should focus primarily on:
- Source-to-FTP data lineage
- Product and legal-entity mapping
- Allocation accuracy
- Independent recalculation
- Business P&L impact
- Trend and variance analysis
- Contingent-liquidity allocation
- Manual adjustments and exception testing
Required Qualifications
- Five or more years of experience in Internal Audit, Treasury, ALM, Finance, liquidity risk, balance sheet management, or product control.
- Understanding of banking products, funding, liquidity, and business profitability.
- Experience auditing complex financial methodologies or allocation frameworks.
- Strong ability to review and challenge complex spreadsheets.
- Experience with substantive testing and independent reperformance.
- Advanced Excel skills, including complex formulas, large datasets, variance analysis, and model review.
- Strong documentation, analytical, and stakeholder-management capabilities.
Preferred Qualifications
- Direct experience with Funds Transfer Pricing.
- Experience with liquidity risk, interest rate risk in the banking book, non-maturity deposits, or balance sheet management.
- Understanding of funding curves, matched-maturity FTP, liquidity premiums, and behavioral assumptions.
- Experience in a large bank, broker-dealer, or financial services Treasury function.
- Exposure to QRM, Fiserv, Oracle, SAP, OFSAA, SAS, or another Treasury/FTP platform.
- CPA, CIA, CFA, FRM, CA, or comparable certification.
- SQL, Power Query, Alteryx, Tableau, or Power BI experience.
Expected Deliverables
- FTP governance and methodology assessment
- Source-to-report data lineage testing
- Sample-based FTP recalculations
- Product, legal-entity, and business allocation testing
- Liquidity premium and assumption testing
- Trend and outcome analysis
- Change-management testing
- Control findings and financial impact assessment