Quality Assurance Data Analyst

Paradigm is seeking an experienced Quality Assurance Data Analyst to support complex data processing, validation, and quality assurance initiatives for a leading provider of technology-enabled legal and business services.

In this role, you will help ensure the accuracy, completeness, and integrity of large datasets used in business-critical applications. You will work closely with data engineers, business analysts, project managers, and QA professionals to validate data imports, transformations, extracts, and database processes.

The ideal candidate combines strong analytical and problem-solving skills with advanced SQL expertise and hands-on experience in database testing. This position is particularly well suited to someone who enjoys investigating complex data issues, developing effective testing strategies, and ensuring that data meets rigorous quality standards.

* Assignment lengths are estimated based on the expected workload and scope of work. The assignment may be extended or conclude earlier than anticipated based on business needs.

Data Validation and Quality Assurance

• Validate the accuracy and integrity of data imports, updates, transformations, and extracts involving datasets ranging from hundreds to millions of records.
  
• Develop, execute, and maintain SQL-based test queries to verify data accuracy, completeness, and consistency.
  
• Analyze complex SQL queries, stored procedures, triggers, and functions to confirm that database operations meet business and technical requirements.
  
• Identify data discrepancies, investigate root causes, document defects, and verify corrective actions.
  
• Test both standard and exceptional data scenarios, including edge cases and anomalies.
  

Test Planning and Requirements Analysis

• Review business and technical requirements to identify gaps, inconsistencies, and potential data quality risks.
  
• Collaborate with business analysts and other stakeholders to translate requirements into comprehensive test plans and test cases.
  
• Develop and execute testing strategies for database processes, data migrations, and ETL operations.
  
• Conduct peer reviews to ensure adherence to established quality standards.
  

Collaboration and Project Support

• Work closely with data engineers, QA team members, and project managers to troubleshoot issues and resolve defects.
  
• Communicate testing results, project status, risks, and outstanding issues clearly and promptly.
  
• Maintain accurate documentation, project records, and time reporting.
  
• Manage competing priorities and meet demanding project deadlines while maintaining accuracy and attention to detail.
  
• Follow established development, testing, and Data Services procedures and quality standards.
  

• Bachelor's degree in Computer Science, Information Systems, Business Analytics, or a related field, or equivalent professional experience.
  
• Minimum 2 years of hands-on database testing experience, including developing and executing complex SQL queries and validating database processes.
  
• Experience with Microsoft SQL Server and strong proficiency in T-SQL.
  
• Experience analyzing and testing stored procedures, functions, triggers, and complex database queries.
  
• Understanding of relational databases, data modeling, and database structures.
  
• Working knowledge of ETL concepts, processes, and data validation techniques.
  
• Proficiency with Microsoft Excel for data analysis, reconciliation, and reporting.
  
• Experience interpreting business requirements and translating them into test cases.
  
• Strong analytical, troubleshooting, and deductive reasoning skills.
  
• Excellent written and verbal communication skills.
  
• Ability to work independently, collaborate across teams, and manage multiple assignments with changing priorities.
  

• Experience validating large-scale data migrations, imports, or conversions.
  
• Background in data-intensive business applications or environments involving high-volume transactional records.
  
• Prior experience as a QA Data Analyst, Database QA Analyst, SQL Data Analyst, or similar technical role.
  

• Complex joins, subqueries, correlated subqueries, IN, and EXISTS
  
• Common table expressions (CTEs), temporary tables, and views
  
• NULL handling and data type considerations
  
• Primary keys, foreign keys, constraints, and defaults
  
• Transactions and error handling
  
• Indexing and query performance considerations
  
• Stored procedures, user-defined functions, and triggers
  
• Bulk data operations, including BCP and BULK INSERT
  
• Database testing, reconciliation, and data integrity validation