Sr. Data Validation Analyst

Sr Data Validation Analyst
Contract to Hire (W2 Only, No C-C)
Austin, TX (Onsite)

We are seeking a Sr Data Validation Analyst to focus on manual testing of the SQL Ad-Hoc Queries and the datasets extracted.
Primary duties will include manual validation of queries and results, and validating the results against other systems/reports.

Responsibilities:

• Work closely with the Regulatory Reporting team to understand internal and external requirements for dataset creation and queries.
• Identify opportunities for improvement and reuse, enabling us to become more efficient and nimble in responding to regulatory needs.
• Utilize relationships with other data domain owners to understand best practices and data availability
• Perform data mapping and gap analysis.
• Document Data Requirements Specifications based on interpretation of Business Requirements, discussions with stakeholders, and overall knowledge of the data.
• Maintain in-depth knowledge of data across all domains and entities.
• Provide clarity for business terminology and relationships to data structures.
• Assist with root cause analysis and remediation of production support issues related to data integrity.

Desired Experience

• 10+ years of Data related work experience is required
• Must have 5+ year experience in data testing, including regression testing
• Proficient of SQL or other query languages.
• Strong knowledge in Snowflake, SQL Server, Oracle, Data Lake (AWS),
• Experience with Tableau Prep and/or Alteryx will be extremely helpful.
• Familiar with data modeling practices and standards across conceptual, logical, and physical levels.
• Familiar with database design and development methodologies
• Experience working with software development lifecycle tools, such as Jira

Manual Testing Deliverables

• Analyze the query requirements and acceptance criteria for new fields, filters, and optimizations in the standard extracts.
• Define, execute, and analyze test cases collaborating with the team to validate achievement of acceptance criteria
• Expert level Microsoft Excel experience that can provide additional validation methods solutions and the ability to augment data merging and reporting process
• Must be familiar with formatting, Pivot Tables, and vLookup formulas in Excel; these will be used heavily in ingesting & matching data
• Determine test cases, test scenarios and cross-system validations
• Create Test plans and test cases for our "Standard Data Extracts"
• Comprehensive documentation and reporting of identified data anomalies

Core Competencies:

• Strong problem-solving skills (e.g., root cause analysis) to debug or improve existing systems
• Ability to work independently in a fast-paced environment.
• Highly organized with strong communication, problem-solving, documentation, and presentation skills.
• Communicate effectively in English both verbally and in writing with stakeholders including Developers and Product Owner
• Work well under pressure with deadlines
• Display flexibility and proficiency at setting priorities
• Proven ability to be proactive, possess flexible attitude, learn new skills, and manage ambiguity.

Estimated Min Rate: $52.50
Estimated Max Rate: $75.00


What s In It for You?
We welcome you to be a part of the largest and legendary global staffing companies to meet your career aspirations. Yoh s network of client companies has been employing professionals like you for over 65 years in the U.S., UK and Canada. Join Yoh s extensive talent community that will provide you with access to Yoh s vast network of opportunities and gain access to this exclusive opportunity available to you. Benefit eligibility is in accordance with applicable laws and client requirements. Benefits include:

• Medical, Prescription, Dental & Vision Benefits (for employees working 20+ hours per week)
• Health Savings Account (HSA) (for employees working 20+ hours per week)
• Life & Disability Insurance (for employees working 20+ hours per week)
• MetLife Voluntary Benefits
• Employee Assistance Program (EAP)
• 401K Retirement Savings Plan
• Direct Deposit & weekly epayroll
• Referral Bonus Programs
• Certification and training opportunities

Note: Any pay ranges displayed are estimations. Actual pay is determined by an applicant's experience, technical expertise, and other qualifications as listed in the job description. All qualified applicants are welcome to apply.

Yoh, a Day & Zimmermann company, is an Equal Opportunity Employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, disability, or status as a protected veteran.

Visit https://www.yoh.com/applicants-with-disabilities to contact us if you are an individual with a disability and require accommodation in the application process.

For California applicants, qualified applicants with arrest or conviction records will be considered for employment in accordance with the Los Angeles County Fair Chance Ordinance for Employers and the California Fair Chance Act. All of the material job duties described in this posting are job duties for which a criminal history may have a direct, adverse, and negative relationship potentially resulting in the withdrawal of a conditional offer of employment.