Data Quality Analyst
New
D
DwellyProperty Management
RemoteFull-TimeMiddle
SalaryCompetitive salary with the potential for equity options based on performance
Apply NowOpens the employer's application page
Job Details
- Required Skills
- PostgreSQLSQLGitMySQLdbt
Requirements
- 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 to improve productivity and automate analysis.
Responsibilities
- Review and approve CRM migration datasets before production deployment by validating completeness, consistency, and overall data quality.
- Review production data updates and validate SQL scripts before execution to ensure large-scale changes are safe and correct.
- Develop automated validation queries that detect missing records, duplicate entities, broken relationships, and other integrity issues.
- Compare source CRM exports with Dwelly data to verify successful migration and investigate discrepancies.
- Analyse unexpected migration results, identify root causes of inconsistencies, and work with engineers to resolve complex data issues.
- Identify recurring migration issues and help improve migration processes, validation tooling, and overall data quality standards.
View Full Description & ApplyYou'll be redirected to the employer's site
