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.

Responsibilities

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.
  

Requirements

Required Qualifications

·         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.

Preferred Qualifications

·         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.

Technical Skills

Candidates should demonstrate advanced knowledge of T-SQL,
including:

• 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
  

Benefits