Employer Active
Job Alert
You will be updated with latest job alerts via emailJob Alert
You will be updated with latest job alerts via emailNot Disclosed
Salary Not Disclosed
1 Vacancy
Location: Washington DC - Hybrid (50% onsite)
Duration: 12 Months
Description -
Job Description:
This position is for a Business Analyst/Tester role that requires meticulous data validation experience and skills to join our 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.
Key Responsibilities:
Collaborate with the 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 for the 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 support.
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.
Qualifications:
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.
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 clients 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 projects 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) are 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.
Preferred Requirements:
Masters degree in computer science or a related field.
Full-time