Data Management Solution Architect

Job description

**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 ====================================================================================