Intermediate Data Quality Analyst (3-5 years) to support data validation and cleansing using Microsoft Excel and development application tracking data

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

Intermediate Data Quality Analyst (3-5 years) to support data validation and cleansing using Microsoft Excel and development application tracking data

Our public sector client is seeking a Intermediate Data Quality Analyst (3-5 years) to support data validation and cleansing using Microsoft Excel and development application tracking data

Join a large-scale data quality improvement initiative supporting the modernization of development application tracking systems within a public sector environment. This role focuses on reviewing, validating, cleansing, correcting, and maintaining complex development application data within Excel-based repositories and tracking systems. The consultant will support infrastructure planning, growth forecasting, reporting requirements, and operational decision-making through detailed document review, data reconciliation, and quality control activities.

Contract, Hybrid

Must-Have

• Minimum 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 functions, and reconciliation techniques.
• Demonstrated 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 volumes of information.
• Experience documenting findings, corrections, assumptions, and data quality issues.
• Excellent attention to detail and accuracy.
• Ability to work independently and manage priorities while following established procedures and meeting established timelines.
• Ability to interpret plans, charts, forms, reports, and technical documentation.
• Strong organizational and records management skills.
• Ability to manage large volumes of repetitive work while maintaining accuracy.
• Effective written and verbal communication skills.

Nice-to-Have

• Experience working with 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, registration records, 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