Senior Business Analyst, Tester

About DMI

DMI is a leading provider of digital services and technology solutions, headquartered in Tysons Corner, VA. With a focus on end-to-end managed IT services, including managed mobility, cloud, cybersecurity, network operations, and application development, DMI supports public sector agencies and commercial enterprises around the globe. Recognized as a Top Workplace, DMI is committed to delivering secure, efficient, and cost-effective solutions that drive measurable results. Learn more at www.dminc.com

About the Opportunity

DMI, LLC is seeking a Senior Business Analyst,Tester (Agile) to join us. 

 

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.

 

Duties and Responsibilities:

• 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 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

Education and Years of Experience:

• Bachelor's degree in computer science, information systems, or a related field
• Five (5) or more years of relevant experience

 Minimum Requirements:

• • Data Analysis & Reconciliation: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.
• Test Data Management:
  • 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.
• Validation of Payroll Calculations:
  • 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 WMATA's unique payroll requirements (e.g., specific union contracts, shift differentials).