Data Quality & Migration Analyst

Dwelly; Spain (TX); On-site; USD 85,000 - 110,000; Full time

Benefits offered by this job

Fully remote role

Competitive compensation

Equity options potential

High-leverage automation projects

Job summary

Dwelly, a UK-based AI-enabled lettings and property management platform, seeks a Data Quality Analyst to own validation and quality assurance of data migrations into Dwelly. You will review CRM migration datasets before production, design automated validation checks, and work with backend engineers to ensure imported data is complete, accurate, and consistent for reliable customer experiences.

The role emphasizes advanced SQL, data analysis, and investigation of real-world data quality issues,

Qualifications

• Strong SQL skills, including complex joins, CTEs, aggregations, window functions, and update scripts.
• 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 instead of relying on 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 effectively use modern AI development tools (such as ChatGPT, Claude, GitHub Copilot, Cursor, Codex, or similar) to improve productivity, investigate data issues, generate SQL, automate repetitive tasks, and accelerate analysis while maintaining high standards of accuracy and review.

Responsibilities

• Data Migration Validation: Review and approve CRM migration datasets before production deployment by validating completeness, consistency, and overall data quality.
• Production Data Quality: Review production data updates and validate SQL scripts before execution to ensure large-scale changes are safe and correct.
• Data Integrity Verification: Develop automated validation queries that detect missing records, duplicate entities, broken relationships, and other integrity issues across migrated datasets.
• Migration Reconciliation: Compare source CRM exports with Dwelly data to verify successful migration and investigate discrepancies.
• Data Investigation: Analyse unexpected migration results, identify root causes of inconsistencies, and work with engineers to resolve complex data issues.
• Continuous Quality Improvement: Identify recurring migration issues and help improve migration processes, validation tooling, and overall data quality standards.

Skills

SQL skills

Data validation

Data integrity

Automated checks

Problem solving

Data analysis

Ownership

AI tooling

Tools

PostgreSQL

MySQL

DuckDB

Git

SQLMesh/dbt

Dolt

Job description

Dwelly, a UK-based AI-enabled lettings and property management platform, seeks a Data Quality Analyst to own validation and quality assurance of data migrations into Dwelly. You will review CRM migration datasets before production, design automated validation checks, and work with backend engineers to ensure imported data is complete, accurate, and consistent for reliable customer experiences.

The role emphasizes advanced SQL, data analysis, and investigation of real-world data quality issues,