Note: The job is a remote job and is open to candidates in USA. Talent Groups is seeking a Quality Assurance Data Analyst to validate data, test SQL logic, identify defects, and ensure data accuracy across large-scale updates and extracts. The role involves database testing, data analysis, test case development, defect resolution, regression testing, and communication with technical and business stakeholders.
Responsibilities
- Validate data updates, extracts, imports, and transformations involving large datasets
- Write and execute SQL queries to validate business requirements, data integrity, and application logic
- Test complex SQL queries, stored procedures, triggers, functions, views, temporary tables, and common table expressions
- Identify data quality issues, defects, inconsistencies, and anomalies
- Work with Data Engineers, Business Analysts, QA Engineers, Project Managers, and other stakeholders to troubleshoot and resolve defects
- Verify fixes and perform regression testing
- Review requirements and identify gaps, inconsistencies, and data quality concerns
- Develop and execute test cases covering normal, exceptional, and edge case scenarios
- Use Excel, SQL Server, and other tools to analyze data and verify requirements
- Maintain testing documentation, status updates, and project artifacts
- Clearly communicate testing results, issues, and project status
- Manage multiple priorities and deliver high quality work within tight deadlines
Skills
- • 2+ years of database testing experience
- • Strong ability to write, understand, and execute complex SQL queries
- • Strong knowledge of Microsoft SQL Server and T SQL
- • Experience testing stored procedures and database logic
- • Experience with relational databases and data analysis
- • Understanding of ETL concepts, tools, and practices
- • Experience validating large datasets, data imports, transformations, and extracts
- • Strong attention to detail and data accuracy
- • Excellent analytical, organizational, and problem solving skills
- • Strong written and verbal communication skills
- • Ability to work independently and collaboratively in a fast paced environment
- • Proficiency with Microsoft Office, particularly Excel
- • Four year degree or equivalent industry experience
- Strong T SQL experience, including:
- • NULL handling
- • Subqueries, including IN, EXISTS, inline views, and correlated subqueries
- • Primary keys, foreign keys, constraints, and defaults
- • Error handling and error trapping
- • Transactions
- • BCP and BULK INSERT
- • Database indexing
- • Advanced stored procedures
- • User defined functions
- • Database triggers
- • Views and temporary tables
- • Common table expressions
- • Data creation, extraction, and updates
Benefits
- Remote work arrangement
- 12+ Month W2 Contract
Company Overview