In accordance with client requirements, candidates must be eligible and willing to work on a W2 basis. Our W2 consultants enjoy a comprehensive benefits package that includes medical, dental, and vision coverage and a 401(k) plan.
We are seeking a highly technical Business Analyst to support a critical Snowflake migration within the HR/People Analytics space. This role is heavily focused on data quality, validation, and QA. The ideal candidate will be hands-on, detail-oriented, and comfortable working deep within the data warehouse environment.
This is not a functional BA role. The right person will be “knee-deep” in data daily — validating, testing, analyzing transformations, and ensuring reporting accuracy.
Key Responsibilities
-
Perform ongoing data validation and QA testing during a Snowflake migration
-
Write complex SQL queries for data analysis, profiling, and validation
-
Validate HR data accuracy, integrity, and transformation logic
-
Ensure raw data is correctly transformed into reporting-ready datasets
-
Support parallel QA efforts and testing cycles
-
Pull and validate reports and metrics for HR stakeholders
-
Identify data discrepancies and perform root cause analysis
-
Partner closely with People Analytics, HR, and Data Engineering teams
-
Build on and enhance existing datasets and dashboards
Required Qualifications
-
3–5 years of experience as a Business Analyst or Data Analyst
-
Strong, hands-on experience with Snowflake (required)
-
Experience with Power BI
-
Advanced proficiency in SQL
-
Experience working directly within a data warehouse environment
-
Strong understanding of data transformations and reporting logic
-
Experience with data validation, QA, and reconciliation processes
-
Ability to work independently with minimal ramp-up time
-
Strong communication skills and ability to interact with HR stakeholders
Preferred Qualifications
-
Background working with HR systems or HR data
-
Experience with Workday
-
Familiarity with metadata/catalog tools (e.g., Collibra, Alation)
-
Experience in biopharma or highly regulated environments
Work Environment
-
Fully onsite, 5 days per week
-
High-visibility role supporting HR and People Analytics leadership
-
Small, collaborative team environment
-
Direct exposure to business stakeholders
Ideal Candidate Profile
-
Data quality mindset — naturally questions discrepancies
-
Strong sense of urgency and ownership
-
Highly technical and comfortable working deep in the data
-
Able to hit the ground running with limited training
-
Professional and presentation-ready for onsite stakeholder interaction
This is an opportunity to play a key role in a high-impact data initiative while working closely with leadership in People Analytics. Candidates who are more functional than technical will not be the right fit for this position.