Remote Data Quality Analyst: Migration Validation

Dwelly; Town of Poland (NY); On-site; USD 70,000 - 110,000; Full time

Benefits offered by this job

Fully remote role

Equity options based on performance

Competitive compensation

Job summary

Dwelly is actively seeking a Data Quality Analyst to own validation and QA of data migrations into Dwelly. You will review CRM migrations before production, ensuring completeness, accuracy, and internal consistency.

This role blends advanced SQL, automated validation, and investigation of real-world data quality issues. You'll design validation queries, identify inconsistencies, investigate results, and help improve tooling over time.

Qualifications

• Strong SQL skills including joins, CTEs, aggregations, window functions and updates.
• Experience validating production data or large database migrations.
• Strong understanding of relational databases and data integrity principles.
• Experience investigating inconsistencies across large datasets.
• Comfortable comparing data from multiple systems and identifying discrepancies.
• Ability to design automated validation checks rather than manual inspection.
• Excellent analytical and problem-solving skills.
• Strong ownership mindset with the confidence to approve or reject production data changes.
• Exceptional attention to detail.
• Ability to work independently in ambiguous situations.
• Ability to use modern AI development tools (ChatGPT, Copilot, etc.) to improve productivity.

Responsibilities

• Data Migration Validation: Review and approve CRM migration datasets before production by validating completeness, consistency, and quality.
• Production Data Quality: Review production data updates and validate SQL scripts to ensure safe, correct large-scale changes.
• Data Integrity Verification: Develop automated validation queries to detect missing records, duplicates, and broken relationships.
• Migration Reconciliation: Compare source CRM exports with Dwelly data to verify migrations and investigate discrepancies.
• Data Investigation: Analyse migration results to identify root causes and collaborate with engineers to fix issues.
• Continuous Quality Improvement: Identify recurring issues and help improve migration processes and validation tooling.

Skills

SQL proficiency

Data quality

Migrations validation

Data integrity

Automation scripts

Independent worker

AI tooling usage

Tools

PostgreSQL

MySQL

DuckDB

Git

SQLMesh

dbt

Dolt

Job description

Dwelly is actively seeking a Data Quality Analyst to own validation and QA of data migrations into Dwelly. You will review CRM migrations before production, ensuring completeness, accuracy, and internal consistency.

This role blends advanced SQL, automated validation, and investigation of real-world data quality issues. You'll design validation queries, identify inconsistencies, investigate results, and help improve tooling over time.