We are seeking a detail-oriented Financial Testing & Reconciliation Analyst in financial systems validation, billing reconciliation, and production verification.
The ideal candidate will possess strong expertise in financial test case design, data profiling, automated back-testing, and reconciliation of large-scale billing and accounting data.
The role requires close collaboration with finance, business, and technology teams to ensure the accuracy and integrity of financial processing and reporting systems.
Key Responsibilities:
Formulate and execute comprehensive financial test cases to validate billing, accounting, and financial processing systems.
Perform data profiling and analysis to identify data quality issues, anomalies, and reconciliation gaps.
Prepare and maintain target journal baseline sheets for financial validation and audit purposes.
Conduct automated back-testing of multi-gigabyte billing files to verify calculation accuracy and data consistency.
Execute and monitor testing scripts, analyze execution performance, and identify optimization opportunities.
Perform parallel file reconciliation between system-generated outputs and manually prepared baseline sheets.
Identify, analyze, and report discrepancy margins across financial datasets and billing outputs.
Map, document, and validate edge-case scenarios to ensure complete test coverage.
Manage and coordinate the end-to-end test execution grid, including test planning, execution tracking, defect management, and reporting.
Conduct smoke testing and validation of initial live production monthly closing runs to ensure successful deployment and business continuity.
Collaborate with business stakeholders, finance teams, and technical teams to resolve defects and improve testing processes.
Prepare test reports, reconciliation summaries, and validation sign-offs for project stakeholders.
Mandatory Skills:
Expertise in formulating financial test cases for complex financial and billing processes.
Hands-on experience in data profiling and financial data validation.
Experience in preparing target journal baseline sheets for reconciliation and accounting verification.
Proven experience in automated back-testing of multi-gigabyte billing files.
Strong knowledge of script execution profiling and test execution monitoring.
Experience in parallel file reconciliation against manual sheets and baseline data.
Ability to flag discrepancy margins, investigate variances, and perform root cause analysis.
Experience in mapping edge-case failures and validating exception scenarios.
Strong capability in managing the core test execution grid, including planning, tracking, execution, and reporting.
Experience in smoke testing and verifying the initial live production monthly closing run.
Strong analytical, reconciliation, and financial validation skills.
Proficiency in SQL and data analysis tools for financial data verification and reconciliation.