{bc}
indeed

Data Quality and Controls Analyst

QuadReal
Toronto, CAN
Full-time
Hybrid
$85,000 to $110,000,
Discovered 1 months ago
SQLdbtData quality monitoringAirflowMicrosoft FabricSYNQ

Full Job Posting

Role overview

Oversees daily end-to-end data health across the Enterprise Data Platform so trusted data reaches BI and reporting solutions.

Operationalizes data quality rules and technical controls across Airflow, dbt, Microsoft Fabric, SYNQ, and Power BI.

Works with data stewards, governance, engineering, BI, and control partners to improve trusted data and reporting reliability.

Data operations and controls

  • Monitor workflows, builds, tests, source freshness, pipelines, alerts, and downstream reporting; coordinate issue resolution, reruns, backfills, and recovery validation.
  • Translate approved business rules into executable data checks and maintain quality monitors, alert routing, lineage, incidents, and metrics.
  • Set and tune thresholds using profiling, historical patterns, statistical analysis, business materiality, and stakeholder feedback.
  • Maintain time-stamped control evidence and support SOC 1 walkthroughs, evidence requests, testing, exceptions, and remediation.
  • Support authorized Quadrant overrides and controlled manual file ingestion with traceability, validation, approvals, and reconciliations.
  • Assess lineage and reporting impacts; maintain runbooks, control documentation, definitions, and procedures; identify automation opportunities.
  • Maintain separation of duties: governance owns policy, business owners approve corrections, and ED&A implements and executes technical controls.

Required qualifications

  • At least three years in data quality, analytics engineering, data engineering, data operations, or controls-focused analytics.
  • Advanced SQL and strong hands-on dbt experience, including data validation, profiling, models, tests, source freshness, documentation, and deployment.
  • Experience with data quality or observability platforms and Airflow or similar orchestration tools.
  • Familiarity with Microsoft Fabric and understanding of Power BI dependencies, refreshes, semantic models, and reporting impacts.
  • Knowledge of data quality and control concepts, statistical threshold tuning, and audit evidence in SOC 1, SOX, financial-control, or similar regulated environments.
  • Experience with Git, peer review, CI/CD, and controlled deployment; strong communication, stakeholder management, problem-solving, and issue coordination.
  • Bachelor’s degree in a technical or business field, or equivalent practical experience.

Additional assets

  • Microsoft Purview or comparable metadata, cataloguing, and lineage tools; Azure security concepts including service principals, Key Vault, RBAC, and least-privilege access.
  • Medallion architectures, Delta tables, Python, containerized dbt workloads, controlled overrides, manual file processes, or evidence automation.
  • Real estate, investment management, accounting, or financial services experience; continuous learning and interest in data governance and quality.

Compensation

  • Expected annualized base salary range is $85,000 to $110,000, with potential incentive, health and dental benefits, pension, and paid time off.

Workplace and employment

  • Role can be based in the Toronto or Vancouver office.
  • Posting is for an existing vacancy; posting metadata indicates full-time employment.

Apply for this job in 1 click

Skip the repetitive application forms

Install the Base Career Chrome Extension and autofill job applications across major job boards with your profile.

Sarah M.James T.Maya R.

Trusted by over 500,000 job seekers on Base Career

Start Free Today

More from this employer

More jobs at QuadReal