Data Governance & Quality Analyst

Position Overview

We are seeking a Data Governance & Quality Analyst to monitor and embed data quality controls across the full data lifecycle from raw ingestion through bronze, silver, and gold medallion layers to consumption in reports, dashboards, and automated business processes.

You will work with business stakeholders to define quality rules, SLA thresholds, monitor, manage master data, maintain metadata and lineage catalogs, and partner with data engineers and business stakeholders to ensure every dataset is accurate, complete, timely, and trustworthy

Key Responsibilities

Data Quality Ingestion & Pipeline Layer

- Design and work with data engineers to implement data quality validation checks within Azure Data Factory and Microsoft Fabric ingestion pipelines, covering completeness, accuracy, consistency, uniqueness, and timeliness dimensions.
- Define critical-field SLAs (e.g., null-rate thresholds, duplicate tolerances, freshness windows) for each data source and account for data-dictionary revisions.
- Provide feedback to data engineers to fine tune automated stop / alert / continue actions ensuring bad data does not propagate downstream.
- Ensure data engineers implement escalation-aware alerting tied to business-critical deadlines where standard alert cadences must accelerate to prevent missed processing windows.
- Support onboarding of new data feeds within a target 45-day window, including definition of quality rules and acceptance criteria for each new source.

Data Quality – Transformation & Gold Layer

- Author and maintain data quality rules applied during medallion-architecture transformations (bronze silver gold), including cross-source reconciliation checks for journal entry automation (Accrued Wages, Ending Inventory, Sales Recap, Transfers, etc.).
- Validate standardized formats and account mappings after transformation; flag and escalate anomalies (e.g., missing GL mappings, orphaned store records, mismatched payroll–GL identifiers).
- Implement automated duplicate detection and anomaly alerting when null patterns, duplicates, or statistical outliers exceed governance-defined thresholds.
- Support field-level encryption validation for PII elements (SSN, full DOB, ZIP) and verify row-level security (RLS) enforcement at the data layer.

Data Quality – Direct-to-Gold Feeds

- Validate data feeds that bypass the bronze and silver layers and arrive directly at the gold layer including payroll and invoice submissions by implementing gold-layer handshake checks that confirm what was sent matches what was received.
- Work with business stakeholders to define reconciliation and audit-trail rules for direct-to-gold feeds to ensure reporting integrity, recognizing that these datasets represent immutable historical records (e.g., exact payroll disbursements).

Data Quality – Consumption & Reporting Layer

- Develop, maintain and validate data quality scorecards and KPI dashboards in Microsoft Purview and / or Power BI, reporting on dimensions such as completeness, accuracy, timeliness, and conformity across all governed datasets.




- Perform periodic reconciliation audits comparing platform outputs against source-of-record systems to confirm reporting integrity.
- Report Release Validation Gate – Establish a mandatory validation checkpoint for all recent Power BI reports and any existing reports undergoing rework before they are promoted to production. This gate will leverage AI-driven profiling of the underlying semantic model to generate an automated summary of central tendency, dispersion, and distributional shape for each dataset, ensuring that data patterns and outliers are surfaced and reviewed prior to end-user consumption.
- Business Glossary Alignment for Reporting Attributes – Coordinate with Business Analysts to ensure that every new reporting attribute introduced through a Power BI report has a corresponding business glossary term defined and published in Microsoft Purview before the report goes live. For existing attributes in reworked reports, initiate a review cycle with the designated business owner to confirm that current glossary definitions remain accurate and aligned with evolving business usage.

Master Data Management (Profisee)

- Administer and govern master data entities in Profisee, including master client records and store-level unique identifiers.
- Define and enforce matching, merging, and survivorship rules to maintain a single golden record for each entity.
- Collaborate with business analysts to onboard new entity types and attributes.
- Ensure all mastered identifiers propagate correctly through the medallion layers and downstream applications.

Metadata, Lineage & Cataloging (Microsoft Purview)

- Maintain the enterprise data catalog in Microsoft Purview, including data dictionary entries, business glossary terms, data classification labels, and sensitivity tags.
- Document and publish end-to-end data lineage from source systems through Lakehouse transformations to Power BI reports and automated business processes.
- Define and apply data classification and sensitivity labels aligned with PII and PCI compliance requirements.
- Track and publish change history for business-defined critical fields; ensure metadata stays current as pipelines and schemas evolve.

Governance Framework & Collaboration

- Contribute to the data governance framework for onboarding external data providers, including quality acceptance criteria, SLA definitions, and escalation procedures.
- Ensure data engineering team maintains audit-trail documentation for mapping changes, manual overrides, vendor setups, and store transfers with user ID and timestamp tracking.

Required Qualifications

- Bachelor’s degree in information systems, Data Management, Computer Science, or related field.
- 3–5 years of hands-on experience in data quality, data governance, or data management roles.
- Experience with a master data management (MDM) platform; Profisee experience is strongly preferred.




- Proficiency with Microsoft Purview (or equivalent data catalog / lineage tool) for metadata management, classification, and governance.
- Strong SQL skills for data profiling, quality rule authoring, and ad-hoc investigation.
- Building data quality dashboards and scorecards in Power BI.
- Working knowledge of Microsoft Fabric for data engineering and analytics workloads.
- Familiarity with medallion architecture (bronze / silver / gold) data design patterns, including environments where certain feeds bypass bronze/silver and arrive directly at the gold layer.
- Familiarity with Microsoft Azure data services (Azure Data Factory, Azure SQL, Azure Data Lake / Lakehouse).
- Excellent written and verbal communication skills; ability to translate technical quality findings into business-friendly language.

Preferred Qualifications

- Experience with restaurant, franchise, or hospitality industry datasets.
- CDMP (Certified Data Management Professional), DGSP (Data Governance & Stewardship Professional), or equivalent certification.
- Experience implementing data quality within automated journal-entry or financial-close processes.
- Understanding PII/PCI compliance requirements, field-level encryption, and row-level security.
- Background in data profiling at scale across 30+ heterogeneous data sources.
- Familiarity with Sage Intacct, Crunch Time, Toast POS, UKG, or Data Pass platforms.

Technology Setting

Category Platforms & Tools

Cloud Platform Microsoft Azure (Data Lake, Data Factory, Azure SQL)

Analytics Engine Microsoft Fabric (Lakehouse, Data Engineering, Notebooks)

Master Data Mgmt Profisee MDM

Data Catalog & Governance Microsoft Purview (lineage, classification, glossary)

BI & Reporting Power BI (dashboards, scorecards, RLS)

ERP / Integrations Sage Intacct, Webtools, Data Pass, Toast, Crunch Time, UKG, PAR, QSR Soft, Mercer (ACA), TapCheck, Zesut, MyRG, I-Series

Automation Power Automate, Azure Logic Apps

Core Competencies

- Analytical Rigor – Ability to profile, investigate, and resolve complex data quality issues across heterogeneous sources.
- Governance Mindset – Instinct to document, standardize, and automate rather than apply one-off fixes.
- Stakeholder Communication – Skill in presenting data quality metrics and governance recommendations to both technical and business audiences.
- Franchise Data Acumen – Understanding multi–unit restaurant operations data: POS sales, food cost, labor, GL, and vendor ecosystems. Awareness of operational realities such as unclosed registers, missed time punches, payroll-cycle dependencies, and the high-volume nature of franchise data ingestion.
- Continuous Improvement – Proactive identification of quality gaps and process enhancements across the data lifecycle.
- Collaboration – Ability to work cross-functionally with data engineers, business analysts, and external data providers.

This job description is intended to convey information essential to understanding the scope of the job and the general nature and level of work performed by job holders within this job. However, this job description is not intended to be an exhaustive list of qualifications, skills, efforts

📌 Data Governance Consultant (Mumbai)
🏢 Carnation Infotech
📍 Mumbai