Quality Assurance Data Analyst

Paradigm is seeking an experienced Quality AssuranceData Analyst to support complex data processing, validation, and qualityassurance initiatives for a leading provider of technology-enabled legal andbusiness services.

In this role, you will help ensure the accuracy,completeness, and integrity of large datasets used in business-criticalapplications. 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 andproblem-solving skills with advanced SQL expertise and hands-on experience indatabase testing. This position is particularly well suited to someone whoenjoys investigating complex data issues, developing effective testingstrategies, and ensuring that data meets rigorous quality standards.

* Assignment lengths are estimated based on the expectedworkload and scope of work. The assignment may be extended or conclude earlierthan anticipated based on business needs.

Responsibilities

DataValidation 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 maintainSQL-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 Planningand 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.

Collaborationand 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 equivalentprofessional experience.

·Minimum 2 years of hands-on database testingexperience, including developing and executing complex SQL queries andvalidating database processes.

·Experience with Microsoft SQL Server and strongproficiency in T-SQL.

·Experience analyzing and testing storedprocedures, functions, triggers, and complex database queries.

·Understanding of relational databases, datamodeling, and database structures.

·Working knowledge of ETL concepts, processes,and data validation techniques.

·Proficiency with Microsoft Excel for dataanalysis, reconciliation, and reporting.

·Experience interpreting business requirementsand translating them into test cases.

·Strong analytical, troubleshooting, anddeductive reasoning skills.

·Excellent written and verbal communicationskills.

·Ability to work independently, collaborateacross teams, and manage multiple assignments with changing priorities.

Preferred Qualifications

·Experience validating large-scale datamigrations, imports, or conversions.

·Background in data-intensive businessapplications or environments involving high-volume transactional records.

·Prior experience as a QA Data Analyst, DatabaseQA 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