Data Analyst - Locals to Oaks, PA Only

Groupe Kardol; Oaks (PA); On-site; USD 110,000 - 140,000; Full time

Job summary

Groupe Kardol in Oaks, PA is seeking a hands-on QA Engineer focused on data validation and testing of database objects across SQL Server and Oracle. You will write SQL queries for validation, profiling, and troubleshooting data issues, and collaborate with data teams to ensure data quality.

You will develop and maintain test plans for data pipelines, execute performance checks, and validate source-to-target mappings, ensuring accuracy through reconciliation and hash comparisons.

Qualifications

• 5+ years of experience with SQL queries for validation, profiling and troubleshooting data issues.
• 3+ years of experience in data validation.
• QA mindset for data validations.
• BS in computer science or related field.

Responsibilities

• Write clear, maintainable SQL queries for validation, profiling, and troubleshooting data issues.
• Develop and maintain test plans, test cases, and acceptance criteria for data pipelines and DB changes.
• Execute performance/regression checks for critical queries and flag regressions due to schema or logic updates.
• Work with data engineers, analysts, and product owners to clarify mappings and acceptance criteria.
• Perform source-to-target validation, including record-level reconciliation, aggregates, and checksum/hash comparisons.

Skills

SQL

Data validation

Education

BS in computer science or related field

Job description

Responsibilities

A hands-on QA Engineer with ~6 years of experience focused on data validation and testing of database objects across SQL Server, and Oracle. Write clear, maintainable SQL queries for validation, profiling, and troubleshooting data issues.

Develop and maintain test plans, test cases, and acceptance criteria for data pipelines and DB changes.

Execute performance/regression checks for critical queries and flag regressions due to schema or logic updates.

Work with data engineers, analysts, and product owners to clarify mappings and acceptance criteria.

Perform source-to-target validation, including record-level reconciliation, aggregates, and checksum/hash comparisons.

Required Qualifications

5+ years of experience with SQL queries for validation, profiling and troubleshooting data issues

3+ years of experience in data validation

QA mindset for data validations

BS in computer science or related field