Apply on Employer Site

ShiftCode Analytics, Inc. · 4 months ago

Business Analyst/Tester (ERP/ HCM)

Washington, DC

Full-time

Onsite

Mid Level

ShiftCode Analytics, Inc. is seeking a Business Analyst/Tester to join their project team, focusing on the testing of a new payroll system. The role involves meticulous data validation, collaboration with stakeholders, and supporting the development of training materials and user documentation.

AnalyticsConsultingInformation Technology

No H1B

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

Qualification

Data AnalysisSQLOracle FusionPayroll SystemsData ValidationTest Case DocumentationJIRAAgile MethodologiesProcess AnalysisCommunication SkillsCollaboration

Required

Conduct in-depth analysis of legacy payroll data to understand structures, transformations, and potential discrepancies for migration to the Oracle Fusion Cloud

Develop and execute complex SQL queries against source and target databases (Oracle Fusion and legacy systems) to extract, compare, and validate payroll data

Perform comprehensive reconciliation of payroll data elements, including employee demographics, pay rates, deductions, benefits, taxes, gross-to-net calculations, and accruals

Identify and document data anomalies, inconsistencies, and errors, flagging them for investigation and resolution by development and data migration teams

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

Maintain the integrity and confidentiality of sensitive payroll test data

Independently validate complex payroll calculations (gross pay, tax withholding, deductions, net pay) within the new Oracle Fusion system against expected results

Develop validation rules and metrics to verify the accuracy of automated payroll processes

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)

Document detailed data validation plans, methodologies, and findings

Generate clear and concise reports on data quality issues, reconciliation results, and validation progress

Track and manage data-related defects within the project's defect tracking system (e.g., JIRA, Azure DevOps)

Provide regular updates to the MetroSync Project Manager and testing lead on data validation status and critical findings

Collaborate closely with data migration teams to ensure data transformation rules are correctly applied and validated

Partner with functional testers and business analysts to align data validation efforts with overall testing strategies

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

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