Senior Data QA (Full-stack QA: Manual + Automation + AI)

Velvetech LLC is an American global software development company headquartered in Miami, FL, and with an office in Chicago, IL. Velvetech has its developers strategically distributed in 10+ global technical job markets to deliver the best in class software engineering and exceptional client services. We have 20+ years of experience in software and hardware development for clients all around the world, especially for US clients. As an official Microsoft Gold Partner, our company is listed in the top 5 software development companies in Illinois, USA.

About the Role:

In this position, you’ll be the vigilant guardian of data integrity, crafting rigorous tests, surfacing hidden anomalies, and telling compelling stories with clean, trusted datasets. Your SQL prowess will probe the depths of our warehouse, while Python scripts orchestrate automated quality checks and deeper analytical insight. Together, they ensure every data‑driven decision rings true.

Key Responsibilities:

• Design & Execute Data Tests

  • Write SQL queries to validate source‑to‑target mappings, row counts, referential integrity, and business rules.

  • Build reusable Python test suites (PyTest, Great Expectations, or similar) to automate regression and smoke tests across pipelines.

• Monitor & Troubleshoot Pipelines

  • Track daily ETL/ELT jobs, investigate failures, and triage data incidents to root cause with log analysis and ad‑hoc SQL.

  • Partner with Data, AI, and BI Engineering to quickly resolve issues and prevent recurrence through robust test coverage.

• Analyze & Communicate Findings

  • Quantify data quality metrics (completeness, freshness, accuracy) and surface them through dashboards or narrated notebooks.

  • Present trends and anomalies to stakeholders, translating complex queries into clear, actionable insights.

• Continuously Improve Process

  • Champion best‑practice coding standards (version control, CI/CD, code reviews).

  • Identify opportunities for new data validation checkpoints and performance optimizations.

Required Skills & Qualifications:

• SQL – window functions, CTEs, query optimization, profiling large datasets.

• Python (Proficient) – Pandas, PyTest/Great Expectations, data‑centric OOP, basic CLI scripting.

• Data Warehousing Concepts – star/snowflake schemas, partitioning, indexing; experience with Snowflake, Redshift, BigQuery, etc.

• ETL/ELT Debugging – Airflow, dbt, or similar orchestration tools.

• Analytics Mindset – descriptive statistics, anomaly detection, storytelling.

Nice‑to‑Have:

• Experience with cloud platforms (AWS, GCP, or Azure) and IaC (Terraform, CloudFormation).

• Familiarity with data observability platforms (Monte Carlo, Metaplane, Databand).

• Data‑viz chops (Looker, Tableau, or Plotly) for crafting QA dashboards.

• Knowledge of CI/CD (GitHub Actions, Jenkins) and containerization (Docker, Kubernetes).

Soft Skills

• Relentless curiosity and a forensic eye for detail.

• Clear communicator—both in dashboards and in person.

• Collaborative spirit able to partner across Product, Engineering, and BI teams.
  
  Our team:
  We are a friendly team of 170+ professionals where everyone is able to achieve high results and grows professionally not only due to their own knowledge and skills but also with the support of colleagues. Values that we highly appreciate are high performance, responsibility, respect, and loyalty. In order to have a highly motivated team, Velvetech invests in their people, additional education, certification, and others.
  
  You have a chance to become a part of a friendly and professional team that creates robust software solutions to deliver maximum value to our international clients. Start your journey today!