FTP Data testing

Position: FTP Data testing role
Request
-1
Job Title: FTP Data testing role
Location:
New York, NY, 10036
Duration: 6 months (Extendable)
Pay Range: $/Hour on W2/C2C (All Inclusive)

Need to be in office 3 Days a week, Need New York Local Profiles

Role Description s:
FTP Data, Allocation, and Outcome Tester

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, Client, 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

Company Benefits & Culture:
Competitive salary and benefits package.
Opportunities for professional growth and advancement.
Dynamic and collaborative work environment.

Appreciate your quick response and please feel free to reach me out for any query you may have.