Senior Quality Assurance Analyst

Experis; Philadelphia (Philadelphia County); Remote; USD 80,000 - 120,000; Full time

Job summary

Experis seeks a Data Quality Analyst to support a significant enterprise data warehouse initiative involving Data Vault modeling on Snowflake and integrations with Salesforce CRM. The candidate will be responsible for validating data pipelines, ensuring data accuracy, and collaborating with multiple teams to enhance data integrity.

Qualifications

• 5+ years of experience in Data QA, Data Engineering, or Data Testing roles.
• Strong SQL skills with Snowflake or similar platforms.
• Hands-on experience with Data Vault 2.0.

Responsibilities

• Validate end-to-end ELT pipelines involving Salesforce CRM data.
• Develop and execute data quality test cases for various CRM datasets.
• Document test strategies, scenarios, defects, and QA workflows.

Skills

SQL

Data Quality Principles

Data Vault 2.0 Modeling

Salesforce Data Structures

dbt

Job description

Data QA Analyst – Snowflake / Data Vault / Salesforce CRM

Location : Remote

Type : Contract – Long-Term Project

Engagement : W2

About the Role

We are seeking an experienced Data Quality Analyst (QA) to support a high-visibility enterprise data warehouse initiative using Data Vault 2.0 on Snowflake , with a specific focus on data integrations with Salesforce CRM . This role is responsible for validating data pipelines, transformations, and historical data structures that ingest, process, and publish CRM data from and into Salesforce.

Responsibilities

• Validate end-to-end ELT pipelines involving Salesforce CRM source and target data
• Test transformations from Salesforce into Data Vault-modeled Snowflake tables (Hubs, Links, Satellites)
• Develop and execute data quality test cases for contact data, account hierarchies, activity logs, opportunity pipelines, and other CRM datasets
• Design and run automated and manual QA checks using dbt, SQL, or custom frameworks
• Perform root cause analysis on inconsistent or missing CRM data, ensuring lineage and auditability
• Collaborate with engineering, CRM admins, and business users to validate source-to-target mappings and business rules
• Document test strategies, scenarios, defects, and QA workflows clearly

Required Skills and Experience

• 5+ years of experience in Data QA, Data Engineering, or Data Testing roles
• Strong SQL skills and experience with Snowflake or similar cloud data platforms
• Hands-on experience with Data Vault 2.0 modeling (Hubs, Links, Satellites)
• Familiarity with Salesforce data structures (Accounts, Contacts, Opportunities, Leads, etc.)
• Experience validating Salesforce-to-warehouse and warehouse-to-Salesforce data flows
• Experience with dbt and writing or extending dbt tests
• Strong understanding of data quality principles : accuracy, completeness, consistency, timeliness, and auditability

Preferred Skills

• Experience with Salesforce APIs, Snowflake external functions, or CDC tools (e.g., Fivetran, HVR, MuleSoft)
• Experience working with business teams on CRM reporting, pipeline accuracy, and campaign performance metrics

Apply Now

If you’re a hands-on data QA professional who understands both enterprise data modeling and CRM data nuances, and you thrive in scalable, auditable data environments, we’d like to hear from you. This role supports a strategic data architecture initiative with direct impact on sales, marketing, and customer success analytics.

Create a job alert for this search

Quality Assurance Analyst • Philadelphia, PA, United States