ERP Data Validation Expert - Hybrid

Period of Performance: Two year base period
Place of Performance: Remote but will be required to work on-site at various locations, specifically: 4100 Garden City Dr, Hyattsville, MD 20785 300 7th St SW, Washington, DC 20024 2401 Mill Road, Alexandria, VA 22314. Please note: The manager will work with the Contractor to determine the date/time and place for on- site work. Work is generally hybrid. Specific information about work location as well as whether it is hybrid/remote can be addressed at interview.
Due: Monday, August 11, 2025 by 5pm.
Details for Position 8: Senior Business Analyst/Tester (Agile)
Role: Treasury Data Validator 1 Lead: Validates financial and payroll data for MetroSync for data migration as well as for ensuring MetroSync works as expected from data perspective.

This position is for a Business Analyst/Tester role that requires meticulous and data validation experience and skills to join our MetroSync project team, with a specific focus on supporting the rigorous testing of our new payroll system. This is a unique opportunity to play a crucial role in safeguarding payroll data and ensuring a seamless transition.

The Data Validation Specialist will be a dedicated resource within the MetroSync testing team, primarily responsible for the accurate and comprehensive validation of payroll data throughout various testing phases, including data migration, system integration testing (SIT), and user acceptance testing (UAT). This role requires deep expertise in data analysis, strong SQL skills, and a fundamental understanding of payroll processes and calculations. The Specialist will work closely with Business Analysts, Testers, Developers, and payroll subject matter experts to ensure data integrity and reconciliation between legacy and new systems.
Collaborate with the MetroSync Project Manager and business stakeholders to understand payroll
system requirements and design testing strategies for the new release.
Conduct data validation to ensure accuracy and integrity of payroll data throughout the system.
Provide regular status updates and progress reports on testing activities to the MetroSync Project Manager and relevant stakeholders.
Support the development of training materials and user documentation related to the new payroll system functionalities.
Participate in post-implementation review and provide recommendations for continuous improvement
Understand and analyze business processes and requirements related to financial management, accounting, procurement, and other finance-related functions.
Understand PeopleSoft and oracle Fusion Financials modules to align with business requirements, such as payroll operations, general ledger, accounts payable, accounts receivable, asset
management, cash management, and other finance-related configurations.
Analyze processes and workflows to identify opportunities for improvement through software

Document requirements in user stories/use cases and epics;
Document test requirements in test cases;
Analyze and document system interfaces, database structures, and data flows;
Coordinate and lead analytic activities with stakeholders;
Use software tools as required to document requirements, analyze needs, identify risk,
propose designs, and write documentation
Conduct peer reviews.

Selection Criteria
Education Bachelor's degree in computer science, information systems, or a related field Must have minimum experience (ex:5 years)
Five (5) or more years of relevant experience

Data Analysis & Reconciliation: o Conduct in-depth analysis of legacy payroll data to understand structures, transformations, and potential discrepancies for migration to the Oracle Fusion Cloud.
o Develop and execute complex SQL queries against source and target databases (Oracle Fusion and legacy systems) to extract, compare, and validate payroll data.
o Perform comprehensive reconciliation of payroll data elements, including employee demographics, pay rates, deductions, benefits, taxes, gross-to-net calculations, and accruals.
o Identify and document data anomalies, inconsistencies, and errors, flagging them for investigation and resolution by development and data migration teams.
Test Data Management: o Assist in the creation and preparation of accurate and representative test data sets for various payroll testing scenarios. o Ensure test data adequately covers edge cases, complex scenarios (e.g., retro-pay, multiple garnishments, union rules), and high-volume transactions. o Maintain the integrity and confidentiality of sensitive payroll test data.
Validation of Payroll Calculations:
o Independently validate complex payroll calculations (gross pay, tax withholding, deductions, net pay) within the new Oracle Fusion system against expected results.
o Develop validation rules and metrics to verify the accuracy of automated payroll processes.
o Work with payroll subject matter experts to understand and validate specific business rules related to unique payroll requirements (e.g., specific union contracts, shift differentials).
Reporting & Documentation:
o Document detailed data validation plans, methodologies, and findings.
o Generate clear and concise reports on data quality issues, reconciliation results, and validation progress.
o Track and manage data-related defects within the project's defect tracking system (e.g., JIRA, Azure DevOps).
o Provide regular updates to the MetroSync Project Manager and testing lead on data validation status and critical findings.
Collaboration:
o Collaborate closely with data migration teams to ensure data transformation rules are correctly applied and validated.
o Partner with functional testers and business analysts to align data validation efforts with overall testing strategies.
o Communicate effectively with payroll business users to clarify data requirements and validate specific scenarios.
Demonstrable experience with Enterprise Resource Planning (ERP) systems, particularly Oracle Fusion Cloud applications (HCM, Financials, Procurement) is required, given MetroSync is
powered by Oracle Fusion.
Experience in IT project management and business analysis roles, with a strong emphasis on system implementation and testing.
Extensive experience with payroll systems and operations is a mandatory requirement. Candidates must understand payroll processes, tax implications, union rules, timekeeping, and associated integrations. Experience with specific payroll context (e.g., PeopleSoft, Kronos history) is a significant plus.
Strong background in data validation;
Experience in the public sector or large government organizations is highly desirable,
demonstrating an understanding of complex stakeholder environments and regulatory requirements.
Skill in process analysis methods and techniques;
Experience in analyzing processes and identifying opportunities for improvements through software support;
Experience establishing successful relationships with business stakeholders;
Experience in analyzing data structures and data flows;
Experience documenting test cases;
Experience as a Scrum Master/Product Owner in an Agile software development environment;
Excellent communication skills, both oral and written; and
Proficiency with JIRA, Confluence, MS Excel, Word, Visio, or a similar tool, and PowerPoint.
Experience in working with third-party systems.
Experience in cloud-based PeopleSoft deployments.