Data Quality and Controls Analyst
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.
Key Skills for This Role
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.
About QuadReal
Canadian real estate investment, development, and property management company serving residents, tenants, institutional investors, and communities.
Visit company websiteJobs and hiring trendsApply 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.
Trusted by over 500,000 job seekers on Base Career
More from this employer
More jobs at QuadReal
Building Operator, Level 3
Calgary, CAN
QuadReal is seeking a Building Operator, Level 3 to maintain safe, efficient building operations at KPMG Tower. Candidates need a valid 5th Class Power Engineer or Building Operator Certificate, 1–2 years of relevant exp
Property Administrator- 18 Month Contract
Ottawa, CAN
QuadReal is seeking a Property Administrator to support property management accounting, tenant administration, reporting, and day-to-day tenant needs on an 18-month contract. Candidates need relevant property management
Community Manager
Calgary, CAN
QuadReal is seeking an Assistant Community Manager to oversee property leasing, resident relations, administration, and day-to-day building operations. The role calls for property management or related experience, strong
Assistant Community Manager
, CAN
QuadReal is seeking an Assistant Community Manager to support leasing, resident relations, administration, and property operations. Candidates should bring related property management or hospitality experience, strong cu
Operations Supervisor
Vancouver, CAN
QuadReal is seeking an experienced building operations supervisor to oversee staff and the safe, efficient maintenance of a real estate portfolio. The role requires at least five years of building operations or superviso
Customer Service Representative
, CAN
Maple Leaf Self Storage is seeking a part-time representative to help customers choose storage solutions and support facility operations. The role includes rentals, payments, customer follow-up, weekend office shifts, an
Maintenance Technician (6-Month Contract)
, CAN
QuadReal is seeking a Maintenance Technician for a six-month contract supporting building upkeep and resident service. The work includes preventive and emergency maintenance, inspections, suite preparation, safety checks
Office Manager
Calgary, CAN
Building Operator, Level 3
Calgary, CAN
Property Administrator- 18 Month Contract
Ottawa, CAN
Community Manager
Calgary, CAN
Assistant Community Manager
, CAN
Operations Supervisor
Vancouver, CAN
Customer Service Representative
, CAN
Maintenance Technician (6-Month Contract)
, CAN
