Contemporary Staffing Solutions is seeking a Snowflake QA Test Analyst to join our client to support the integrity, accuracy, and reliability of enterprise data systems and reporting. This role plays a critical part in validating data pipelines, ensuring that warehouse and reporting layers reflect trusted, high-quality information. The ideal candidate will collaborate closely with data engineering and analytics teams to identify issues, enhance testing processes, and support successful data delivery. This is a SOW project opportunity located in Wilmington, DE or Philadelphia, PA, with a hybrid schedule requiring onsite presence at least three days per week.
Compensation:
$50–60/hr
Work Schedule:
Monday–Friday, 9:00 AM – 5:00 PM; onsite minimum 3 days per week in Philadelphia, PA or Wilmington, DE
Key Responsibilities of the Snowflake QA Test Analyst:
Oversee end-to-end validation of data pipelines, ensuring accuracy and consistency from source systems through ETL/ELT processes into data warehouses and reporting layers
Design and execute comprehensive testing strategies for data transformations, aggregations, and historical datasets to confirm alignment with business rules
Perform detailed data reconciliation and validation using advanced SQL techniques to compare source and target datasets and identify discrepancies
Track, document, and help resolve data defects by partnering with cross-functional teams to ensure timely issue resolution and improved data quality
Validate reporting outputs, dashboards, and BI tools against underlying data sources to confirm reliability for business use
Support user acceptance testing (UAT) and release readiness efforts, contributing to final validation and deployment decisions
Qualifications and Skills for the Snowflake QA Test Analyst:
Hands-on experience testing data warehouses, with strong familiarity across modern platforms such as Snowflake, Redshift, BigQuery, or similar technologies
Advanced SQL capabilities, including complex joins, subqueries, CTEs, and analytical functions for deep data validation
Solid understanding of data warehousing structures and concepts, including dimensional modeling and ETL/ELT workflows
Experience working with data integration or orchestration tools (e.g., Informatica, Talend, Databricks, SSIS, Airflow)
Exposure to automated data testing approaches or scripting languages (such as Python or dbt) is a plus
Strong analytical mindset with a high level of attention to detail and a commitment to ensuring data accuracy
Ability to work both independently and collaboratively while communicating effectively with technical and non-technical stakeholders
Why Join Us?
This opportunity offers the chance to work on complex, high-impact data initiatives that directly influence business decision-making. You’ll gain exposure to modern data platforms and collaborate with forward-thinking teams in a dynamic environment. It’s an excellent role for professionals who enjoy solving data challenges and driving quality across enterprise systems.
About Us:
Contemporary Staffing Solutions (CSS) is a trusted leader in providing contract, temporary, temp-to-hire, and direct hire staffing solutions. With decades of experience, we’ve grown from a staffing agency to a nationwide provider of workforce management solutions. Our niche recruitment expertise spans Accounting & Finance, Call Center & Office Support, Human Resources, Sales & Marketing, and Information Technology. Explore more about CSS and how we connect great talent with exceptional opportunities by visiting www.ContemporaryStaffing.com.
Seniority level
Entry level
Employment type
Full-time
Job function
Quality Assurance
Industries
Staffing and Recruiting
Referrals increase your chances of interviewing at CSS Tec by 2x