Intermediate Data Quality Analyst (3-5 years) to support data validation and cleansing using

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