Data Quality Analyst
- Burnaby, BC, Canada
Contract
Applications open in a new tab.
Job details
- Job type
- Contract
- Apply by
- Experience
- 5+ years of experience in Data Quality, Data Analysis, Data Management or Data Governance.
- Posting language
- English
- Posted
Original job description
Job Description
On behalf of our public-sector client, Affinity is seeking a Data Quality Analyst. The Data Quality Analyst is expected to work alongside the Data Governance Analyst and business SMEs, with a more hands-on focus on understanding the current state of BC Housing's data, identifying and profiling data quality issues, defining measurable data quality rules and controls, performing root-cause analysis, and supporting remediation. The role will likely help turn the governance standards established by the Data Governance Analyst into practical, measurable controls at the data level.
Responsibilities
Know someone who’s great for this, or any of our open roles? Earn up to $4,000/year for each successful referral through Affinity Earn. You can also earn up to $50,000 for helping us find new clients. Learn about our referral program at https://affinity-group.ca/earn/ or browse our jobs & follow us at https://www.linkedin.com/company/affinity-staffing/jobs/
About Affinity
Affinity Group is a technology and business consulting and services company. We believe in creating long term relationships between clients and consultants that foster a mutually beneficial partnership. Affinity is an equal opportunity employer. We celebrate diversity and are committed to creating an inclusive environment for all employees. All employment is decided on the basis of qualifications, merit and business need.
For more information on Affinity, please visit www.affinity-group.ca
Job Number: 14136
On behalf of our public-sector client, Affinity is seeking a Data Quality Analyst. The Data Quality Analyst is expected to work alongside the Data Governance Analyst and business SMEs, with a more hands-on focus on understanding the current state of BC Housing's data, identifying and profiling data quality issues, defining measurable data quality rules and controls, performing root-cause analysis, and supporting remediation. The role will likely help turn the governance standards established by the Data Governance Analyst into practical, measurable controls at the data level.
Responsibilities
- Perform data profiling and data quality assessments across prioritized datasets and business use cases.
- Identify data issues involving accuracy, completeness, consistency, validity, uniqueness, timeliness and integrity.
- Work with business SMEs, Data Owners and Data Stewards to understand data definitions, business rules and acceptable quality thresholds.
- Develop and document data quality rules, validation criteria and measurable thresholds.
- Establish repeatable processes for monitoring data quality and identifying exceptions.
- Perform root-cause analysis on recurring data quality issues and determine whether problems originate from source systems, business processes, integrations, transformations or reporting layers.
- Maintain data quality issue logs, including severity, ownership, remediation status and resolution.
- Work with business and technical teams to develop and track remediation plans.
- Support the identification and assessment of Critical Data Elements (CDEs) and determine appropriate quality controls for those elements.
- Assist with data reconciliation and validation across source systems and downstream reporting/analytics environments.
- Develop data quality metrics, scorecards, dashboards and KPIs to provide visibility into data health and remediation progress.
- Support metadata, business glossary, data dictionary and lineage activities where they intersect with data quality.
- Help establish reusable data quality standards, templates, procedures and testing methodologies.
- Partner closely with the Data Governance Analyst so that data quality rules align with BC Housing's emerging governance policies and framework.
- Communicate data quality findings to both technical and non-technical stakeholders and help business units understand their responsibilities for correcting issues.
- 5+ years of experience in Data Quality, Data Analysis, Data Management or Data Governance.
- Strong hands-on SQL skills for profiling, querying, reconciliation and validation.
- Demonstrated experience performing data profiling and data quality assessments.
- Experience creating data quality rules, thresholds, controls and scorecards.
- Strong understanding of core DQ dimensions: completeness, accuracy, consistency, validity, uniqueness and timeliness.
- Experience conducting root-cause analysis and remediation of data issues.
- Experience documenting data definitions, business rules, metadata and lineage.
- Understanding of Data Governance, Data Stewardship, Data Ownership and Critical Data Elements.
- Experience working with data across ETL/integration pipelines, databases, data warehouses and BI/reporting environments.
- Ability to translate business rules into technical validation logic.
- Strong stakeholder-facing skills, particularly working with business SMEs who may not have deep data expertise.
- Experience working independently in an environment where data management capabilities are still being established.
- Microsoft Purview experience, particularly around cataloguing, lineage, metadata, classifications and governance.
- Microsoft Azure data platform experience.
- Power BI experience for DQ dashboards/scorecards.
- Experience with Collibra, Informatica or dedicated data-quality tooling.
- DAMA-DMBOK / CDMP knowledge or certification.
- Public-sector, Crown corporation or other complex regulated-enterprise experience.
- Privacy, records management or regulatory/compliance exposure.
Know someone who’s great for this, or any of our open roles? Earn up to $4,000/year for each successful referral through Affinity Earn. You can also earn up to $50,000 for helping us find new clients. Learn about our referral program at https://affinity-group.ca/earn/ or browse our jobs & follow us at https://www.linkedin.com/company/affinity-staffing/jobs/
About Affinity
Affinity Group is a technology and business consulting and services company. We believe in creating long term relationships between clients and consultants that foster a mutually beneficial partnership. Affinity is an equal opportunity employer. We celebrate diversity and are committed to creating an inclusive environment for all employees. All employment is decided on the basis of qualifications, merit and business need.
For more information on Affinity, please visit www.affinity-group.ca
Job Number: 14136
More about this job
Responsibilities
Profile and assess prioritized datasets, define measurable data quality rules and controls, investigate recurring issues, and coordinate remediation with business and technical teams. Develop data quality metrics and reporting, support governance and metadata activities, and communicate findings to stakeholders.
Requirements
Requires at least five years of experience in data quality, data analysis, data management, or data governance, along with strong hands-on SQL and experience profiling data, defining quality controls, and resolving data issues. Candidates should understand governance and data quality dimensions, work effectively with business stakeholders, and ideally have experience with Microsoft Purview, Azure, Power BI, and complex regulated organizations.
Skills
- SQL
- Data Profiling
- Data Quality Assessment
- Data Quality Rules
- Root-Cause Analysis
- Data Remediation
- Data Reconciliation
- Data Governance
- Data Stewardship
- Metadata Management
- Data Lineage
- Microsoft Purview
- Microsoft Azure
- Power BI
- ETL and Data Integration
- Stakeholder Communication
Visa sponsorship
Not detected in the job text
Categories
- Data & Analytics
- Technology
- Government & Public Sector
- Consulting
Keywords
- Data Quality
- Data Profiling
- SQL
- Data Quality Rules
- Data Quality Metrics
- Data Quality Scorecards
- Root-Cause Analysis
- Data Remediation
- Data Reconciliation
- Data Governance
- Data Stewardship
- Data Ownership
- Critical Data Elements
- Metadata
- Business Glossary
- Data Dictionary
- Data Lineage
- ETL
- Data Integration
- Data Warehouses
- Business Intelligence
- Microsoft Purview
- Microsoft Azure
- Power BI
- Collibra
- Informatica
- DAMA-DMBOK
- CDMP
- Privacy
- Records Management