MDM Architect - Siebel UCM

Job Summary - This role is responsible for end‑to‑end solution architecture, technical leadership, and delivery governance for on‑premise Master Data Management (MDM), Data Quality (DQ), and Data Governance enablement. The MDM Architect / Senior MDM Consultant will define target architecture and integration patterns, lead design and implementation across Siebel UCM, OEDQ and ODI, and drive governance and quality outcomes through Informatica Axon/EDC/IDQ. The role also includes strong project management capabilities: planning and tracking delivery, managing stakeholders, controlling scope, and ensuring successful releases and production stability.

Key Responsibilities

• MDM architecture & roadmap: Define the on‑prem MDM/DQ architecture (logical, physical and integration views), environment strategy (DEV/TEST/PROD), non‑functional requirements (performance, availability, security), and an execution roadmap aligned to business outcomes.
• Siebel UCM solution leadership: Lead functional/technical design across UCM domain model, services, batch/real‑time integrations, and stewardship operations; govern match/merge/unmerge flows and x‑reference strategy.
• Matching, survivorship & golden record: Define and approve match strategy, survivorship rules, and “best version record” (surviving record) construction; ensure rules are testable, explainable to business, and aligned to stewardship workflows.
• Data quality design (OEDQ): Architect profiling, auditing, standardization/cleansing, and matching components; define DQ KPIs, thresholds, monitoring dashboards, and issue workflows/case management as required.
• Integration architecture (ODI): Define ingestion and publishing patterns (batch schedules, dependencies, reconciliation), transformation standards, and operational monitoring approach; guide teams on scalable ELT design using ODI repositories/agents and deployment practices.
• Metadata, governance & catalog (Axon/EDC): Establish operating model for glossary stewardship, dataset onboarding, domain discovery/curation, and lineage validation; ensure glossary–catalog alignment and adoption by business stakeholders.
• DQ implementation (IDQ): Define standards and review design for IDQ rules and deployments; ensure test coverage, promotion across environments, and traceability to business rules and DQ KPIs.
• Delivery leadership / PM skills: Own workplans, estimates, resourcing and RAID; manage scope and change control; run stakeholder governance (status, risks, decisions); coordinate release readiness and cutover activities; ensure on‑time delivery across multiple workstreams.
• Quality assurance & reviews: Lead design reviews, code/config reviews, test strategy, and production readiness; drive performance tuning and stabilization (including root cause analysis for recurring data issues).
• Client-facing consulting: Translate business needs into implementable designs, present architecture options with trade-offs, mentor developers/analysts, and establish reusable assets and best practices.

Required Skills & Experience

• 8+ years of experience in MDM / Data Quality / Data Governance programs, with at least 3+ years in an architecture/lead consultant role
• Strong hands-on or design-level experience with Siebel UCM (Oracle Customer Hub) including mastering, match/merge, survivorship, stewardship and integration patterns
• Strong knowledge of data quality concepts: profiling, standardization, parsing, matching/deduplication, monitoring KPIs and issue remediation workflows
• Experience with Oracle Enterprise Data Quality (OEDQ) and Oracle Data Integrator (ODI) in enterprise/on‑prem environments; understanding of ODI repository/agent architecture and operational monitoring
• Experience defining data models and canonical representations for customer/master data; strong understanding of lineage, metadata and stewardship requirements
• Delivery/PM capabilities: planning, estimation, stakeholder management, risk/issue management, scope/change control, and release governance
• Strong SQL and data analysis skills; ability to lead data investigations and validate outcomes (match rates, survivorship results, DQ improvements)
• Excellent communication and documentation skills (architecture diagrams, HLD/LLD, decision logs, runbooks)

Tools / Technology (Preferred)

• Siebel UCM / Oracle Customer Hub (UCM) – mastering, x‑ref, stewardship, survivorship configuration concepts
• Oracle Enterprise Data Quality (OEDQ) – profiling, auditing, cleansing, matching, monitoring
• Oracle Data Integrator (ODI) – mappings/packages/scenarios, agents, repositories, deployment and monitoring
• Informatica Axon (business glossary), EDC (catalog/lineage), IDQ (rule implementation)
• Oracle DB / SQL; Unix/Linux basics; scheduling/automation tooling (as applicable)

Nice to Have

• TOGAF or equivalent architecture framework exposure
• ITIL foundation and experience operating production support processes (incident/problem/change)
• Experience integrating UCM/OEDQ with CRM/ERP/data platforms and designing publish/subscribe patterns
• Experience driving data governance operating model adoption (stewardship councils, DQ scorecards, policy enforcement)
• Experience with watchlist screening / address validation / identity resolution extensions (where applicable)

Education / Certifications

• Bachelor’s degree in Computer Science, Engineering, Information Systems, or equivalent practical experience
• Preferred certifications: TOGAF, PMP/PRINCE2 (or equivalent), ITIL Foundation