6-month Contract - Data Quality Analyst - North Sydney
About the Role
We are seeking an experienced Data Quality Analyst who owns the full Data Quality (DQ) Framework lifecycle for a system upgrade, by identifying data quality issues, determining fixes, implementing corrections, and validating results across application data as it migrates from SQL Server 2008 R2 to SQL Server 2022.
Key Responsibilities
- Assess: Profile and validate data quality (completeness, accuracy, consistency, validity, uniqueness, timeliness) via T-SQL against a business rule catalogue, quantifying and documenting findings.
- Identify Treatment: Determine correction, exclusion, or escalation approaches with SMEs, prioritized by business risk.
- Apply Treatment: Develop and execute protected, reversible, auditable T-SQL remediation scripts under formal change control.
- Validate & Report: Re-test post-fix, produce before/after scorecards, and maintain audit-ready documentation.
- Improve:
Build reusable DQ rule libraries/templates and refine the overall DQ framework.
Essential Skills
- Strong hands-on experience writing complex queries/scripts in Microsoft SQL Server (versions 2008 R2 and 2022) / T-SQL.
- Solid understanding of Data Quality dimensions (completeness, accuracy, consistency, validity, uniqueness, timeliness) and DQ frameworks/methodologies.
- Experience in data profiling, root cause analysis, and remediation scripting.
- Familiarity with data governance concepts, DQ metrics/scorecards, and issue-tracking processes.
- Ability to work with large datasets and optimize queries for performance.
NEXT STEPS If you think this could be the right role for you APPLY TODAY or for further information, please contact Zac on
[email protected]
📌 Data Quality Analyst (North Sydney)
🏢 Pinpoint Talent
📍 North Sydney