Data Quality Specialist

This role will support a key project by performing data quality and validation activities to ensure the integrity, accuracy, and completeness of data across SDLH and our Data Repository.

Location: 100% ON-SITE, Asuncion-Paraguay. Working hours are based on the US Central Time Zone.

About the Company:

Abstra is a fast-growing, Nearshore Tech Talent services company, providing top Latin American tech talent to U.S. companies and beyond. Founded by U.S.-bred engineers with over 15 years of experience, Abstra specializes in sourcing skilled professionals across a wide range of technologies to meet our clients’ needs, driving innovation and efficiency.

Key Responsibilities:

• Design and executesource (SDLH silver to gold) andsource-to-target(SDLH gold to Data Repository gold)validation. 

• Develop and run SQL scripts/queries to compare record counts, field-level values, and aggregates between source and target datasets.

• Identify, document, and track data discrepancies, mapping errors, or transformation issues.

• Collaborate with data engineers to implement QA rules and validation checks within the Great Expectations framework.

• Collaborate withthe data teamto define validation rules and acceptance criteria.

• Build reusable QA/reconciliation frameworks or test scripts to support repeatable testing across migration phases 

• Support UAT (user acceptance testing)of the converted reports.

• Document data quality findings, root causes, and remediation recommendations.

Requirements:

• Familiarity withcore financial system concepts.

• Advanced SQLproficiency, specifically: T-SQL – working with SQL Server-based systems for extraction, transformation, and validation logic.Databricks SQL – querying and validating data within lakehouse/big data environments. 

• Data profiling and anomaly detection.

• Familiarity withdata quality and validation frameworks, such asGreat Expectations, for defining, automating, and enforcing data quality checks 

• Familiarity with ETL/ELT pipelines and data migration methodologies, especially medallion architecture.

Desired Skills and Experience:

• Prior hands-on experience in data migration QA, ideally within financial/accounting systems. 

• Experience building or executing structured source-to-target reconciliation processes.

• Hands-on experience with data quality frameworks (e.g., Great Expectations,dbt tests, or similar) for automating validation rules.

• Comfort working independently with clear deliverables.

What We Offer:

• Competitive compensation paid in USD.
• 20 days of paid time off (PTO) per year.
• Opportunities for professional growth and career development.
• Company-provided equipment.
• A collaborative, inclusive, and multicultural work environment.
• The opportunity to contribute to meaningful projects alongside a talented and supportive team.
  

Pre-Employment Verification
As part of our standard onboarding process, candidates who successfully complete the interview process and accept an employment offer will be required to complete an employment verification check, and background check. This process will confirm job titles and dates of employment with two previous employers and is a standard requirement for all new employees joining the company.