Data Management Solution Architect

Job Description – Data Management Solution Architect

Experience: 9–12 Years

Role Type: Solutioning + Emerging Architecture + Advisory

Role Summary

We are seeking a strong MDM-centric Data Management Architect to solution design enterprise-grade Master Data Management solutions while contributing to broader Data Governance, Data Quality, and Modern Data Platform initiatives. This role is expected to:

• Anchor MDM design + implementation (core ownership)
• Support data governance, quality, and security integration
• Contribute to modern data architectures (Fabric / Mesh)
• Gradually step into solutioning and client-facing roles

Core Responsibilities

1. Master Data Management

Design and implement multi-domain MDM solutions (Customer, Product, Vendor, Reference Data) & PIM (Product Information Management) solutions

Define Golden Record strategy (match, merge, survivorship, hierarchies)

Build data models, domain structures, and entity relationships

Implement:

Data onboarding (batch + real-time ingestion)

Match rules, workflows, stewardship processes

Hierarchy & relationship management

Integrate MDM with:

Source systems (ERP, CRM, APIs)

Downstream analytics platforms

MDM + Data Quality Convergence

Implement pre- and post-MDM DQ frameworks (profiling, standardization, validation)

Design DQ rules library aligned with MDM entities

Support data cleansing, enrichment, standardization at ingestion layer

Enable continuous DQ monitoring and KPI reporting

Data Governance Enablement (MDM-Driven)

Align MDM implementation with enterprise data governance policies

Support:

Data catalog integration

Business glossary & metadata mapping

Stewardship workflows (approval, exception handling)

Ensure data ownership, lineage, and lifecycle visibility

(critical for governance adoption)

Data Security & Compliance (MDM Core Data Protection)

Implement access control (RBAC), masking, sensitive data handling

Ensure compliance for PII/reference data domains

Support audit trails, data access monitoring

Modern Data Platform Integration

Integrate MDM with modern data platforms (Lakehouse/Warehouse)

Work with:

Databricks / Snowflake data pipelines

Data ingestion, transformation, and API frameworks

Enable MDM as a service layer (API-first / event-driven)

Support Data Fabric integration (unified access layer)

Data Mesh & Data Product Alignment

Support adoption of Data Mesh principles:

Domain-aligned master data ownership

Data-as-a-product mindset

Ensure MDM acts as core trusted data product provider

Collaborate with domain teams for data product publishing

Data Observability & Monitoring

Implement data quality & pipeline monitoring (freshness, completeness, failures)

Enable issue detection → root cause → remediation workflows

Contribute to automated alerts and dashboards

Solutioning & Client Interaction (Emerging Capability)

Participate in:

Solution design discussions

Effort estimation and technical proposals

Support client workshops and requirement discovery

Contribute to POCs, demos, and accelerators

Expected: execution-heavy with growing consulting exposure

Mandatory Skills (Strong MDM Spine)

Deep expertise in:

Master Data Management (must-have core strength)

Data Quality & Data Governance fundamentals

Hands-on experience in at least one:

Informatica MDM / Reltio / Profisee / Stibo / Ataccama/ Semarchy

Strong understanding of:

Data modeling, matching algorithms, survivorship

Integration patterns (ETL/ELT, APIs, streaming)

Experience with:

One cloud platform (Azure/AWS/GCP)

Databricks OR Snowflake

Good to Have

Exposure to:

Data catalog tools (Collibra, Purview, Alation)

Data security frameworks

Initial experience in:

Presales / proposals / architecture discussions

AI exposure:

Smart matching / deduplication

DQ automation

Behavioral Expectations

Strong problem-solving mindset (data inconsistencies → resolution approaches)

Ability to translate business rules into MDM logic

Good stakeholder communication (business + IT)

Execution-focused with architecture inclination

Qualifications

B.Tech / BE / MCA / Equivalent

Certifications (good to have):

MDM tool certifications

Cloud & AI certifications

====================================================================================