Tester

PlanIT Group, LLC; Richmond (VA); On-site; USD 65,000 - 95,000; Full time

Job summary

PlanIT Group, LLC in Richmond, VA is seeking a Data QA Analyst to ensure data accuracy across systems, design and execute test plans, validate transformations, and identify discrepancies.

Collaborate with SMEs, data engineers, and developers to troubleshoot issues, document results, and recommend corrective actions.

Proficiency in SQL, Power BI, SSRS/SSMS and Azure DevOps is required; mortgage data knowledge is preferred.

Qualifications

• 3–5 years of testing experience in Data and Analytics projects.
• 5+ years of SQL experience.
• 2+ years in MS Azure environments and Azure DevOps.
• Proficiency with SQL Server tools: SSMS, SSRS and Power BI read-only access.
• Strong communication with SMEs and stakeholders.
• Mortgage industry knowledge preferred.
• Advanced MS Office skills.
• Knowledgeable in data validation and test scripting.

Skills

Effective communication

Stakeholder collaboration

Time management

Analytical thinking

Test planning

Defect tracking

Issue troubleshooting

Documentation

Mortgage industry knowledge

Tools

SQL

Azure DevOps

SSMS

SSRS

Power BI

Excel

SQL Server

Job description

Description

Ensures the accuracy, integrity, and reliability of data across systems and processes. This role involves designing and executing test plans, validating data transformations, and identifying discrepancies between source and target datasets.

Business Skills

• " Communicates effectively through various channels
  
  "
• " Works effectively with business SMEs and facilitates conversations efficiently
  
  "
• " Manages their time effectively with the ability to proactively seek prioritization
  
  "
• " Strong analytical skills, attention to detail, and proficiency in SQL and data validation tools
  
  "
• " Solid foundation of application and data testing strategies, concepts, and documentation
  
  "
• " Hands on experience with test planning, progress tracking, defect tracking, expected results
  
  "
• " Ability to collaborate with analysts, data engineers, developers, and business stakeholders to troubleshoot issues, document findings, and recommend corrective actions.
  
  "
• " Knowledge of Mortgage Industry, Single Family and Multi-Family preferred
  
  "
• " Intermediate/Advanced Microsoft Office Suite of Tools
  
  "
• " Intermediate Azure DevOps defect management
  
  "
• " SQL Intermediate to advanced knowledge
  
  "
• " SQL Server Data Management Studios (navigation, read/write/execute queries)
  
  "
• " SQL Server Reporting Services (navigate reports as read-only)
  
  "
• " Microsoft PowerBI (navigate and filter reports as read only)
  
  "
• " Intermediate testing data validation, test execution, regression testing
  
  "
• " Significant experience in test script construction and execution including script structure and components, expected results, defect tracking, approval processes
  
  "
• " Test tracking and reporting
  
  "
• " Minimum 3-5 years of testing experience working in Data and Analytics projects
  
  "
• " Minimum 5 years working experience with SQL
  
  "
• " Minimum 2 years working in MS Azure environments and defects management using Azure DevOps and SQL database"