Yo IT Consulting
SQL QA Lead
Posted
3 weeks ago
Experience
3+ Years
Salary
$65 - $80 /hour
Deadline
Closed
Job Summary
The SQL Quality Assurance Lead owns data verification, query accuracy grading, documentation updates, and contributor engagement across all database-centric AI projects. Core responsibilities include spot-checking multi-dialect queries, managing expert teams via Discord, authoring style guides, designing benchmark verification tasks, and flagging query performance or security violations.
Qualification
Educational Background & Core Foundations
- Required Baseline: A formal Bachelor’s or Master’s degree in Computer Science, Data Science, Information Systems, Software Engineering, Statistics, Business Analytics, or a clearly equivalent track of professional engineering experience.
Experience
Candidates must demonstrate deep relational database mastery, exceptional technical auditing skills, and remote coordination capabilities:
SQL & Database Infrastructure Expertise
- Professional Tenure: Minimum of 3+ years of direct professional experience utilizing SQL heavily within data analytics, backend software development, database engineering, business intelligence (BI), data warehousing, automated QA testing, or technical education.
- Command of Fundamentals: Flawless mastery of core SQL mechanics, including complex SELECT structures, JOIN mapping, GROUP BY and HAVING sorting, subqueries, Common Table Expressions (CTEs), window functions, indexing strategies, constraints, transaction safety, and relational normalization.
- Defect Identification: Proven ability to critique database code against tight guidelines to identify syntax errors, improper join behavior, duplicate counting, inefficient query plans, security threats (SQL injection), and dialect mismatches.
- Ecosystem Familiarity: Prior operational exposure to popular relational engines, data warehouses, and modeling architectures—such as PostgreSQL, MySQL, SQL Server, SQLite, BigQuery, Snowflake, Redshift, ER modeling, or query plan interpreters—is highly preferred.
Remote Team Operations & Quality Management
- Team Leadership: Prior experience guiding, mentoring, or checking the work of remote teams of data analysts, developers, reviewers, or technical annotators is strongly preferred.
- Digital Toolkit Agility: Fluid comfort working in fast-paced remote workspaces using Discord, GitHub, Google Workspace (Docs, Sheets, Trackers), and agile project dashboards.
- Documentation Rigor: Outstanding organizational capability with experience maintaining structural assets such as style guides, localized technical FAQs, and alignment documentation.
- AI Data Background: Past experience working within AI training models, prompt data annotation, LLM code review, or rubric-based technical testing is considered a strong operational advantage.
Key Responsibilities
1. Code Review & Data Integrity (40%)
- Audit AI Queries: Evaluate AI-generated SQL syntax, database explanations, schema configurations, and analytical workflows for logical correctness and execution readiness.
- Identify Code Vulnerabilities: Actively spot and flag non-executable queries, inefficient join logic, incorrect aggregations, dialect mismatches, and security issues like SQL injection.
- Deliver Precise Technical Feedback: Provide clear, structured written feedback through direct communication channels to correct contributor errors and align output with project guidelines.
- Perform Quality Control: Conduct regular spot-checks across code datasets to catch recurring mistakes, document code defects, and escalate critical data issues.
2. Expert Team Management & Community Alignment (30%)
- Lead Communication Channels: Manage project communication spaces on Discord, keeping trainers and QA specialists informed about updated guidelines, client requests, and quality trends.
- Resolve Technical Queries: Serve as the primary point of contact for complex technical questions regarding database normalization, window functions, schema logic, and rubric interpretation.
- Drive Contributor Engagement: Track contractor activity metrics, reaching out directly to inactive or inconsistent contributors to ensure steady data production.
- Run Training Webinars: Schedule and lead interactive onboarding calls to walk incoming SQL developers through project rules, grading systems, and code standards.
3. Documentation Engineering & Benchmarking (30%)
- Author Style Guides: Write and continuously update core project documentation, technical style guides, localized FAQs, and code examples.
- Build Calibration Modules: Design targeted testing tasks and intentional hidden code challenges ("honeypots") to assess and align reviewer accuracy.
- Standardize Quality Rubrics: Ensure guidelines are applied uniformly across different query dialects and reviewer teams as project demands grow.
- Optimize QA Workflows: Identify recurring quality gaps in production datasets and propose scalable process improvements to streamline technical data review.
Expected Outputs & Deliverables
- Legally and technically accurate project style guides, dialect-specific rule sheets, and reference query logs.
- Custom SQL benchmarking models, training assets, and evaluation challenges for the contributor network.
- Detailed code audit summaries, dataset defect logs, and query optimization recommendations.
- Weekly network activity matrices tracking contributor accuracy, response times, and production outputs.
Skills Required:
- Computer / Software / It / Data
Quick Actions
Share Vacancy