Data Quality & Governance Specialist

QuadReal Property Group, LP; Toronto; On-site; CAD 85,000 - 110,000; Full time

Benefits offered by this job

Performance-based incentive plan

Comprehensive health & dental benefits

Pension plan

Paid time off

Job summary

QuadReal Property Group seeks a Data Quality & Controls Analyst to oversee end-to-end data health across the Enterprise Data Platform. You will translate business rules into checks and monitor pipelines, ensuring trusted data reaches BI solutions and reports.

Responsibilities cover data quality rules, tooling, thresholds, and SOC 1 evidence, with collaboration across governance, analytics, data engineering, and risk teams. Toronto or Vancouver offices welcome candidates.

Qualifications

• 3+ years in data quality, analytics engineering, data engineering, data operations, or a controls-focused analytics role.
• Advanced SQL skills, including profiling, reconciliation, validation, and root-cause analysis across large datasets.
• Hands-on experience with dbt, including models, sources, tests, source freshness, documentation, and deployment practices.
• Experience with data quality or observability platforms and the operation of monitors, alerts, lineage, and incident workflows.
• Experience monitoring and troubleshooting workflow orchestration tools such as Airflow.
• Familiarity with Microsoft Fabric, including OneLake, lakehouses or warehouses, notebooks or pipelines, and SQL endpoints.
• Understanding of Power BI data dependencies, refresh processes, semantic models, and downstream reporting impacts.
• Strong understanding of data quality dimensions and control concepts, with the statistical literacy to establish and tune thresholds.
• Experience maintaining audit trails, approvals, evidence, and change records in SOC 1, SOX, financial-control, or similarly regulated environments.
• Experience with Git, peer review, CI/CD practices, and controlled development-to-production deployment.
• Strong communication, stakeholder management, problem-solving, and issue-coordination skills.
• Bachelor’s degree in a technical or business field or equivalent practical experience.

Responsibilities

• Daily Data Operations: Oversee the daily end-to-end data process by monitoring Airflow workflows, dbt builds, tests and source freshness, Microsoft Fabric pipelines and notebooks, SYNQ alerts, and downstream Power BI impacts.
• Issue Management: Log, prioritize, route, and track data quality and pipeline issues to resolution within agreed service levels; coordinate reruns, backfills, and recovery validation without bypassing required controls.
• Data Quality Rules: Partner with Business Data Stewards and Data Governance to translate approved business rules into executable freshness, completeness, uniqueness, validity, referential integrity, schema, and anomaly checks.
• Data Quality Tooling: Configure and maintain monitors, ownership, alert routing, lineage, incidents, and data quality metrics in SYNQ, supported by dbt tests and SQL-based validation where appropriate.
• Threshold Management: Use data profiling, historical patterns, statistical analysis, business materiality, and feedback from stakeholders to establish and tune thresholds while reducing false-positive alerts.
• Control Evidence: Maintain complete, attributable, and time-stamped evidence that controls operated as designed, including run histories, dbt results and artifacts, SYNQ incidents, tickets, approvals, reconciliations, and remediation records.
• SOC 1 Support: Support control walkthroughs, evidence requests, sample testing, exception documentation, and remediation activities in partnership with Risk, Controls, and Audit stakeholders.
• Quadrant Overrides: Operate and support the Quadrant override functionality for approved business corrections, ensuring each change is authorized, traceable, technically validated, and reflected correctly in downstream data. Business owners approve changes; the analyst supports the tooling and does not self-approve overrides.
• Manual File Controls: Support controlled manual file ingestion by validating file identity, format, schema, timing, approvals, ingestion results, and reconciliations so manual inputs remain reproducible and auditable.
• Lineage and Reporting Impact: Use metadata and lineage to understand how upstream failures or changes affect critical datasets, metrics, semantic models, and Power BI reports, and communicate business impact to the appropriate owners.
• Standards and Documentation: Maintain runbooks, control documentation, data quality definitions, known-issue guidance, and operating procedures; identify opportunities to automate evidence and reduce recurring incidents.
• Separation of Duties: Implement technical controls and approved governance standards while maintaining clear role boundaries. Data Governance owns the operating model and policy, business owners approve business corrections, and EDA owns technical implementation and execution.

Skills

Advanced SQL

dbt

Airflow

Power BI

SYNQ

Microsoft Fabric

SOC 1

SOX

Git

CI/CD

Python

Delta tables

Key Vault

Data governance

Education

Bachelor's degree in a technical or business field

Tools

Airflow

dbt

Job description

QuadReal Property Group seeks a Data Quality & Controls Analyst to oversee end-to-end data health across the Enterprise Data Platform. You will translate business rules into checks and monitor pipelines, ensuring trusted data reaches BI solutions and reports.

Responsibilities cover data quality rules, tooling, thresholds, and SOC 1 evidence, with collaboration across governance, analytics, data engineering, and risk teams. Toronto or Vancouver offices welcome candidates.