Data AnalystJust posted!

Talent Web Recruitment; Sydney; On-site; AUD 70,000 - 110,000; Full time

Job summary

Talent Web Recruitment in Sydney is seeking a mid-level Data Quality Analyst to join a technology-driven data transformation program. The role focuses on hands-on data quality across a large environment, using SQL Server and T-SQL to profile data and implement remediation scripts.

You will translate business rules into data quality checks, perform root-cause analysis, and collaborate with business and technical SMEs to ensure data integrity and robust documentation throughout the lifecycle.

Qualifications

• Strong hands-on Microsoft SQL Server and T-SQL experience.
• Practical Data Quality experience beyond reporting or governance.
• Experience with data profiling, root-cause analysis and remediation.
• Understanding of Data Quality dimensions and methodologies.
• Experience with large datasets and optimized SQL queries.
• Knowledge of data governance, DQ metrics/scorecards, issue-management.
• Strong documentation and stakeholder communication skills.

Responsibilities

• Profile large datasets and identify data quality issues across multiple dimensions.
• Translate business rules into testable data quality rules and T-SQL queries.
• Investigate anomalies and perform root-cause analysis.
• Write, test and execute SQL/T-SQL remediation scripts.
• Validate data post-remediation to ensure issues are resolved.
• Produce Data Quality metrics, scorecards and reporting.
• Collaborate with business and technical SMEs on data issue treatment.
• Maintain documentation of DQ rules and remediation activities.

Skills

SQL / T-SQL

Data profiling

Root cause analysis

Stakeholder communication

Education

Bachelor's degree in a relevant field

Tools

SQL Server

T-SQL

Job description

6-Month Contract | Sydney | Data Transformation Program

We're partnering with a well-established Australian organisation currently undertaking a significant technology and data transformation program.

They're looking for a mid-level Data Quality Analyst to join the program and take a hands-on role in identifying, investigating and remediating data quality issues across a large and complex data environment.

This is a technical Data Quality role rather than a purely governance-focused position. You'll be working directly with Microsoft SQL Server and T-SQL, profiling data, translating business rules into data quality checks and developing remediation scripts to correct identified issues.

What you'll be doing

• Profile large datasets and identify data quality issues across completeness, accuracy, consistency, validity, uniqueness and timeliness.
• Translate business rules into testable data quality rules and T-SQL validation queries.
• Investigate anomalies and perform root-cause analysis.
• Write, test and execute SQL/T-SQL remediation scripts to correct data issues.
• Validate data following remediation to ensure issues have been resolved without introducing new problems.
• Produce Data Quality metrics, scorecards and reporting.
• Work with business and technical SMEs to determine appropriate treatment of data issues.
• Maintain clear documentation of DQ rules, assessment logic and remediation activities.

The role covers the full data-quality lifecycle from assessment and profiling through to treatment, remediation and post-treatment validation.

Data Quality Analyst - SQL / T-SQL

Essential experience | To be considered, you must have:

• Strong hands-on Microsoft SQL Server and T-SQL experience, including writing complex queries and scripts.
• Practical Data Quality experience - not simply reporting, analytics or data governance.
• Experience with data profiling, root-cause analysis and data remediation.
• Strong understanding of core Data Quality dimensions and methodologies.
• Experience working with large datasets and optimising SQL queries for performance.
• Understanding of data governance, DQ metrics/scorecards and issue-management processes.
• Strong documentation and stakeholder communication skills.

These requirements come directly from the essential criteria in the position description.