Verified Job
IT / Software / Data Analyst
Master Data Specialist
IT / Software / Data Analyst
#700432
Remote / WFH
Job Description
MDM Specialist — Job Description
Role Summary
The MDM Specialist will design and implement Master & Reference Data Management capabilities for the Enterprise Data Warehouse on GCP (BigQuery) . The role ensures trusted, governed master data (e.g., Customer, Policy, Agent, Provider, Product, Branch/Sales hierarchy) that is consistent across Bronze/Silver/Gold , supports 300 reports , data products & APIs , and aligns with interoperability standards FHIR and ACORD .
Key Responsibilities
1) MDM Strategy & Data Domain Ownership
Define MDM scope, master domains , golden record strategy , and survivorship rules aligned to enterprise data model and reporting needs. Establish reference data standards (code sets, enumerations, hierarchies), including sales hierarchy required for embedded portal reporting.
2) Data Modeling & Canonical Alignment (FHIR + ACORD)
Design logical & physical models for master/reference entities and harmonize mappings to FHIR + ACORD canonical representations where applicable. Produce mapping specs and data dictionaries to maintain traceability from source to report/API.
3) Match/Merge, Golden Record & Stewardship Enablement
Implement matching rules, de-duplication logic, identity resolution, and golden record creation in the Silver/Gold layers. Define stewardship workflows: ownership, exception management, approvals, and remediation with business stakeholders.
4) Data Quality Controls for Master/Reference Data
Define DQ rules for MDM entities: completeness, uniqueness, validity, referential integrity, timeliness and reconciliation checks. Implement automated checks at ingestion and transformation stages; contribute to DQ dashboards and quality metrics reporting.
5) Governance, Metadata, Lineage, and Compliance
Ensure master/reference datasets are cataloged with metadata, lineage , business definitions and security classifications using approved governance tooling (e.g., Dataplex/Data Catalog and/or enterprise tools referenced in the scope). Support audit readiness: traceability, evidence, retention/lifecycle policy alignment, and secure access controls (RBAC, least privilege).
6) Enablement for Reporting, APIs, and Self-Service
Provide consumption-ready master views in Gold marts for Looker semantic layer and for API/data product exposure (GraphQL/REST). Ensure MDM supports self-service reporting, including consistent dimensions and hierarchies used across dashboards and regulatory outputs.
7) Delivery & Operationalization
Work in agile sprints: refine backlog, define acceptance criteria, support SIT/UAT, and provide operational runbooks for MDM pipelines. Participate in governance gates and compliance reviews with relevant councils (TAC/Security/Cloud COE) as required by the program.
Deliverables (What “Done” Looks Like)
MDM domain blueprint + entity definitions + stewardship model Canonical mapping specs (FHIR/ACORD touchpoints) + data dictionary entries Golden record logic implemented in Silver/Gold (match/merge/dedup) DQ rules + automated validations + exception handling for master/reference data Catalog/lineage entries + security tagging + audit evidence pack MDM consumption views for Looker + APIs/data products, documented and versioned
Required Skills & Experience
Must-Have
6–10+ years in MDM / Master Data / Reference Data / Data Governance programs. Strong data modeling (conceptual/logical/physical), especially around dimensions, hierarchies, and identity resolution. Hands-on with data quality, profiling, reconciliation, and exception workflows. Experience delivering MDM for regulated domains (health/insurance preferred) and working with compliance/security requirements.
Technical
GCP data stack familiarity: BigQuery concepts, orchestration patterns, and working alongside Dataflow/Beam-based pipelines (as per scope). Metadata/lineage tools exposure: Dataplex/Data Catalog and/or enterprise governance tools (references exist in scope). Understanding of interoperability frameworks FHIR and ACORD concepts (mapping awareness).
Stakeholders & Interfaces
Data Engineering Squad (pipelines, transformations, medallion layers) Data Governance & Security (metadata, lineage, DQ, RBAC, compliance) Reporting & Analytics (Looker semantic layer, regulatory reporting readiness) Data Products & API (data contracts, API payload consistency) business owners/stewards for domain sign-off and exception resolution
Success Measures (KPIs)
% reduction in duplicates for key entities (Customer/Agent/Policy) DQ pass rate for MDM entities (completeness/uniqueness/validity) aligned to program acceptance criteria Time to resolve MDM exceptions with stewardship workflows Traceability: lineage coverage from source → master → marts → reports/APIs
Nice-to-have (Differentiators)
Prior implementation experience in health insurance domains (Policy, Claims, Agent hierarchies). Experience supporting pixel-perfect regulatory reporting dependencies (consistent reference/master data). Familiarity with operating model elements: runbooks, monitoring KPIs, DR considerations.
Role Summary
The MDM Specialist will design and implement Master & Reference Data Management capabilities for the Enterprise Data Warehouse on GCP (BigQuery) . The role ensures trusted, governed master data (e.g., Customer, Policy, Agent, Provider, Product, Branch/Sales hierarchy) that is consistent across Bronze/Silver/Gold , supports 300 reports , data products & APIs , and aligns with interoperability standards FHIR and ACORD .
Key Responsibilities
1) MDM Strategy & Data Domain Ownership
Define MDM scope, master domains , golden record strategy , and survivorship rules aligned to enterprise data model and reporting needs. Establish reference data standards (code sets, enumerations, hierarchies), including sales hierarchy required for embedded portal reporting.
2) Data Modeling & Canonical Alignment (FHIR + ACORD)
Design logical & physical models for master/reference entities and harmonize mappings to FHIR + ACORD canonical representations where applicable. Produce mapping specs and data dictionaries to maintain traceability from source to report/API.
3) Match/Merge, Golden Record & Stewardship Enablement
Implement matching rules, de-duplication logic, identity resolution, and golden record creation in the Silver/Gold layers. Define stewardship workflows: ownership, exception management, approvals, and remediation with business stakeholders.
4) Data Quality Controls for Master/Reference Data
Define DQ rules for MDM entities: completeness, uniqueness, validity, referential integrity, timeliness and reconciliation checks. Implement automated checks at ingestion and transformation stages; contribute to DQ dashboards and quality metrics reporting.
5) Governance, Metadata, Lineage, and Compliance
Ensure master/reference datasets are cataloged with metadata, lineage , business definitions and security classifications using approved governance tooling (e.g., Dataplex/Data Catalog and/or enterprise tools referenced in the scope). Support audit readiness: traceability, evidence, retention/lifecycle policy alignment, and secure access controls (RBAC, least privilege).
6) Enablement for Reporting, APIs, and Self-Service
Provide consumption-ready master views in Gold marts for Looker semantic layer and for API/data product exposure (GraphQL/REST). Ensure MDM supports self-service reporting, including consistent dimensions and hierarchies used across dashboards and regulatory outputs.
7) Delivery & Operationalization
Work in agile sprints: refine backlog, define acceptance criteria, support SIT/UAT, and provide operational runbooks for MDM pipelines. Participate in governance gates and compliance reviews with relevant councils (TAC/Security/Cloud COE) as required by the program.
Deliverables (What “Done” Looks Like)
MDM domain blueprint + entity definitions + stewardship model Canonical mapping specs (FHIR/ACORD touchpoints) + data dictionary entries Golden record logic implemented in Silver/Gold (match/merge/dedup) DQ rules + automated validations + exception handling for master/reference data Catalog/lineage entries + security tagging + audit evidence pack MDM consumption views for Looker + APIs/data products, documented and versioned
Required Skills & Experience
Must-Have
6–10+ years in MDM / Master Data / Reference Data / Data Governance programs. Strong data modeling (conceptual/logical/physical), especially around dimensions, hierarchies, and identity resolution. Hands-on with data quality, profiling, reconciliation, and exception workflows. Experience delivering MDM for regulated domains (health/insurance preferred) and working with compliance/security requirements.
Technical
GCP data stack familiarity: BigQuery concepts, orchestration patterns, and working alongside Dataflow/Beam-based pipelines (as per scope). Metadata/lineage tools exposure: Dataplex/Data Catalog and/or enterprise governance tools (references exist in scope). Understanding of interoperability frameworks FHIR and ACORD concepts (mapping awareness).
Stakeholders & Interfaces
Data Engineering Squad (pipelines, transformations, medallion layers) Data Governance & Security (metadata, lineage, DQ, RBAC, compliance) Reporting & Analytics (Looker semantic layer, regulatory reporting readiness) Data Products & API (data contracts, API payload consistency) business owners/stewards for domain sign-off and exception resolution
Success Measures (KPIs)
% reduction in duplicates for key entities (Customer/Agent/Policy) DQ pass rate for MDM entities (completeness/uniqueness/validity) aligned to program acceptance criteria Time to resolve MDM exceptions with stewardship workflows Traceability: lineage coverage from source → master → marts → reports/APIs
Nice-to-have (Differentiators)
Prior implementation experience in health insurance domains (Policy, Claims, Agent hierarchies). Experience supporting pixel-perfect regulatory reporting dependencies (consistent reference/master data). Familiarity with operating model elements: runbooks, monitoring KPIs, DR considerations.
