Data Quality Analyst

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

About Dwelly

Dwelly is a UK-based, AI-enabled lettings and property management platform growing through a roll-up strategy by acquiring estate agencies and integrating them into a modern technology platform. As we acquire agencies, we inherit large volumes of operational data from different CRM systems. Every migration introduces differences in data quality, structure, and completeness. Maintaining high-quality production data is critical to ensuring a reliable customer experience.

Position Summary

We're looking for a Data Quality Analyst to own the validation and quality assurance of data migrations into Dwelly.

Your primary responsibility will be reviewing and approving CRM data migrations before they reach production. You'll work closely with backend engineers and migration tooling to ensure imported data is complete, accurate, and internally consistent.

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

The ideal candidate has exceptional attention to detail, enjoys investigating data problems, and is comfortable making release decisions based on evidence.

Key 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.

Qualifications and Preferred Background

• 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.

Technical Environment

• PostgreSQL
• MySQL
• DuckDB (testing and validation)
• Git
• SQLMesh or dbt
• Dolt or similar version-controlled database technologies
• CSV-based CRM migrations

Nice to Have

• Python for automation and data analysis
• Experience building automated data quality frameworks
• Knowledge of ETL or ELT pipelines
• Experience working with CRM migrations or property management systems
• Familiarity with data observability and reconciliation tooling

What Success Looks Like

• Production migrations are approved with confidence and minimal manual effort.
• Automated validation catches the vast majority of migration issues before deployment.
• Data integrity issues are identified early and resolved quickly.
• Migration quality improves continuously through better validation and investigation.
• Engineers trust the migration approval process because it is evidence-driven, repeatable, and reliable.

Compensation & Benefits

• Fully remote role.
• Competitive compensation based on experience and impact.
• Opportunity to work on high-leverage automation systems at the intersection of backend engineering, applied ML, data and real operational workflows.
• Competitive salary with the potential for equity options based on performance, recognising exceptional contributions to our integration success.

What is it like being a Dwell-er?

Feel free to check out Dwelly Core Principles. That's about what we believe in, how we operate and make decisions.

What we offer is not a fancy office or a static workplace. Instead, this is about solving one of the world's most complex problems in the largest consumer industry in the world: residential rentals.

More than 30% of households live in rental homes — over 5 million in the UK and more than 100 million across the EU and US. Our mission is to improve that experience through technology, automation and operational excellence.

This is about disrupting one of the largest and most antiquated industries in the world with one of the strongest operational and technical teams in the UK and Europe.

We work hard, and we aim for extremely ambitious results. We want people to be proud of what they've built and to one day look back and say: "Hell yeah, that was me that did it."

Our Principles

• Customer obsession rather than competitive focus
• Passion for invention
• Operational excellence
• Long-term thinking

By applying for this position, you consent to the processing and storage of your personal data for recruitment purposes for up to 365 days, in accordance with our data retention policy and applicable data protection laws.