Impress employers and recruiters.
Choose from hundreds of resume examples.
Impress employers and recruiters.
Choose from hundreds of resume examples.
Target Resume Now
Tailor your resume to this Data Quality and Controls Analyst role.
Rezi rewrites your resume against QuadReal Property Group's job description. Free.
Tailor your resume to this Data Quality and Controls Analyst role.
Rezi rewrites your resume against QuadReal Property Group's job description. Free.
Don't guess if your resume is good enough.
See how it scores against the Data Quality and Controls Analyst posting at QuadReal Property Group — free, in seconds.
Don't guess if your resume is good enough.
See how it scores against the Data Quality and Controls Analyst posting at QuadReal Property Group — free, in seconds.
About the Role
The Data Quality & Controls Analyst oversees the daily end-to-end health of data across the Enterprise Data Platform (EDP), ensuring trusted data reaches business intelligence and reporting solutions. This role operationalizes data quality rules and technical controls across various platforms, monitors data and pipeline health, coordinates issue resolution, and maintains evidence for SOC 1 control requirements.
Responsibilities
- Oversee daily end-to-end data processes by monitoring Airflow workflows, dbt builds, tests and source freshness, Microsoft Fabric pipelines and notebooks, SYNQ alerts, and downstream Power BI impacts.
- 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.
- 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.
- 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.
- Establish and tune thresholds using data profiling, historical patterns, statistical analysis, business materiality, and stakeholder feedback to reduce false-positive alerts.
- 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.
- Support control walkthroughs, evidence requests, sample testing, exception documentation, and remediation activities in partnership with Risk, Controls, and Audit stakeholders.
- 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.
- Support controlled manual file ingestion by validating file identity, format, schema, timing, approvals, ingestion results, and reconciliations so manual inputs remain reproducible and auditable.
- 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.
- Maintain runbooks, control documentation, data quality definitions, known-issue guidance, and operating procedures; identify opportunities to automate evidence and reduce recurring incidents.
- Implement technical controls and approved governance standards while maintaining clear role boundaries.
Requirements
- 3+ years of relevant experience in data quality, analytics engineering, data engineering, data operations, or a controls-focused analytics role
- Advanced SQL skills, including data profiling, reconciliation, validation, and root-cause analysis across large datasets
- Strong 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
- Sound understanding of data quality dimensions and control concepts, with the statistical literacy needed to establish and tune thresholds
- Experience maintaining audit trails, approvals, evidence, and change records in a SOC 1, SOX, financial-control, or similarly regulated environment
- Experience with Git, peer review, CI/CD practices, and controlled development-to-production deployment
- Strong communication, stakeholder management, problem-solving, and issue-coordination skills
- Experience with Microsoft Purview or comparable metadata, cataloguing, and lineage tools (asset)
- Familiarity with Azure security concepts such as service principals, Key Vault, RBAC, and least-privilege access (asset)
- Experience with medallion data architectures, Delta tables, Python, or containerized dbt workloads (asset)
- Experience supporting controlled overrides, manual file processes, or evidence automation (asset)
- Experience in real estate, investment management, accounting, or financial services (asset)
- Continuous learning mindset and a passion for data governance and quality (asset)
- Candidates must be legally authorized to work in Canada as the company does not provide work permit sponsorship for this role.
Skills
- SQL
- dbt
- Airflow
- Microsoft Fabric
- SYNQ
- Power BI
- Data Quality
- Data Governance
- Analytics Engineering
- Data Engineering
- Data Operations
- Git
- CI/CD
Location
- Toronto
- Vancouver
Work Type
- Hybrid
Experience Level
- 3+ years relevant experience
Education Level
- Bachelor’s degree in a technical or business field, or equivalent practical experience
Salary/Compensations
- $85,000-$110,000
Benefits
- Performance-based incentive plan
- Comprehensive health & dental benefits
- Pension plan
- Paid time off
About the Company
- QuadReal Property Group is a global real estate investment, development and operating company headquartered in Vancouver, British Columbia.
- Assets under management are $98.5 billion.
- QuadReal has expanded its capabilities globally for investments in equity and debt in both the public and private markets.
- QuadReal invests directly through operating platforms in which it holds an ownership interest and via programmatic partnerships.
- QuadReal seeks to deliver strong investment returns while creating sustainable environments that bring value to the people and communities it serves. Now and for generations to come.
- QuadReal: Excellence lives here.
Equal Opportunity
- We value diverse experiences and perspectives. Even if your skills don’t align 100% with the listed qualifications or salary range, we encourage you to apply – you may be a great fit for this role or others in our community.
- Applicants may also be considered for alternative positions within the organization where their qualifications and experience align more closely with available opportunities.
- We use artificial intelligence (AI) technology — alongside human review — to assist in screening and assessing applicants for this position. Our recruitment team remains involved in all decisions.
- QuadReal Property Group will provide reasonable accommodation at any time throughout the hiring process for applicants with disabilities or for those needing job postings in an alternate format. If you require accommodation, please advise the Talent Acquisition team member you are working with and include the following: Job posting #, your name and your preferred method of contact.