Job Details

Job Title: Senior MDM Architect

Duration: 6 Months Contract to Hire

Location: Irvine CA (Hybrid)

Job Description:

JD of Senior MDM Architect

Needed detail-oriented Data Integration Led Architect to support enterprise-wide Customer Master data Management and integration initiative. The person will lead technical execution, along with performing source system analysis, metadata documentation, and data mapping while tracking milestones, reporting and working with various divisions. Ideal candidate will be both technically fluent and programmatically strong – capable of defining data strategy and working with cross-functional teams through discovery to implementation.

Responsibilities:

Architect/Lead JD

• Design the MDM Models based on our critical data elements by domain – depending on the tool it may have a landing/staging model as well as the final MDM model.
• Design the Integration mappings (source to target mappings) for data movement from producing systems, internal to MDM, and external to MDM to the consuming systems (analytics, SAP, third-party sources like D&B, etc). If we move forward with our data foundation strategy, this may just be publication to a mesh (master data product).
• Design the Match/Merge rules and trust/survivorship rules.
• Design Workflow and UI changes (assist with security set ups/groups, etc) – UI changes require execution of our DQ rules at time of data entry if we author directly into the MDM vs. have producing systems push data to the MDM or both.
• Design Hierarchies for the domains.
• Design any reference data models/integrations, etc.
• Design any analytics needed inside of the tool (reports on match/merge, DQ, workflow/task approvals, etc).
• Design integrations with Catalog and DQ (as needed).
• Monitor system performance and suggest optimization strategies (as needed).
• Testing.
• Support issue resolution and completion of ad-hoc requests in support of business partners.
• Define target states and build roadmaps to deliver value.
• Collaborate with stakeholders to understand their needs and gather detailed business requirements.

Qualifications:

• 7+ years in Informatica MDM architecture, data integration or data governance
• 8-10 years of various strategic IT experience encompassing technology, organizational, and process improvements, with a proven track record of crafting impactful executive-level presentations.
• 3+ years of experience in AWS Data Technologies
• 3+ years of experience in project management working with multiple stakeholders
• Experience with MDM, metadata management, and data quality frameworks
• Strong problem-solving and analytical skills
• Expertise in querying, analyzing, reconciling, and testing complex relational and non-relational data
• Strong understanding of APIs, ETL pipelines, and data modeling
• Experience with SQL, relational database (e.g. Oracle, Sybase, SQL Server) and cloud data platforms (e.g. AWS, Snowflake)
• Bachelor's degree in computer science or related field.