Business Analyst/Tester (ERP/ HCM)
ShiftCode Analytics, Washington, District of Columbia, us, 20022
Interview: Virtual
Visa: USC and GC
Rate: DOE
Hybrid: Washington DC
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 client's 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) 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: • Master's degree in computer science or a related field. • PeopleSoft certified
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 client's 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) 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: • Master's degree in computer science or a related field. • PeopleSoft certified