Data Quality Analyst - Excel & Validation Specialist

S I Systems; Toronto; Hybrid; CAD 60,000 - 85,000; Full time

Job summary

S I Systems is seeking an Intermediate Data Quality Analyst (3-5 years) to support data validation and cleansing using Microsoft Excel and development application tracking data, in a hybrid contract role within a public sector context.

You will review, validate, cleanse, and maintain complex datasets in Excel-based repositories, track revisions, identify discrepancies, and support reporting and decision-making through meticulous data quality controls.

Qualifications

• 3–5 years of experience in data quality, data analysis, data validation, data cleansing, or data governance roles.
• Advanced proficiency in Microsoft Excel, including filtering, sorting, data validation, and reconciliation.
• Experience reviewing and correcting large, complex datasets.
• Experience identifying, investigating, and resolving data discrepancies, duplicates, missing information, and data integrity issues.
• Strong analytical and problem-solving skills with the ability to interpret and validate large data volumes.
• Excellent attention to detail and accuracy.
• Ability to work independently and manage priorities while following procedures and timelines.
• Strong organizational and records management skills.
• Ability to manage large volumes of repetitive work with accuracy.
• Effective written and verbal communication skills.
• Nice-to-have: GIS (ESRI), planning databases, records management systems, or document management systems.

Responsibilities

• Review development application files and validate information against source documentation.
• Extract and validate residential unit counts and gross floor area data.
• Track changes across application resubmissions and document revisions.
• Verify application status through approval documentation and municipal notices.
• Identify data discrepancies, missing information, and inconsistencies.
• Cross-reference related development applications and associated files.
• Enter validated information into tracking spreadsheets and database systems.

Skills

Data quality

Data analysis

Data validation

Data cleansing

Data governance

Attention to detail

Independent worker

Communication

Prioritization

Data interpretation

Tools

Microsoft Excel

ESRI GIS

Job description

S I Systems is seeking an Intermediate Data Quality Analyst (3-5 years) to support data validation and cleansing using Microsoft Excel and development application tracking data, in a hybrid contract role within a public sector context.

You will review, validate, cleanse, and maintain complex datasets in Excel-based repositories, track revisions, identify discrepancies, and support reporting and decision-making through meticulous data quality controls.