MDM Architect

  • Irvine, CA
  • Posted 4 days ago | Updated 4 days ago

Overview

On Site
Depends on Experience
Full Time
No Travel Required

Skills

Amazon Web Services
Analytical Skill
Cloud Computing
Conflict Resolution
Data Quality
Documentation
Customer Master Data
Data Governance
Data Integration
Data Mapping
Data Modeling
Analytics
Collaboration
Extract
Transform
Load
Fluency
Informatica MDM
Issue Resolution
Management
Master Data Management
Meta-data Management
Microsoft SQL Server
Mobile Device Management
Optimization
Oracle
Presentations
Problem Solving
Process Improvement
Product Design
Project Management
RDBMS
Reference Data
Reporting
Roadmaps
SAP
SQL
Snow Flake Schema
Sybase
Systems Analysis
Testing
UPS
Workflow
UI

Job Details

D 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 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.

Employers have access to artificial intelligence language tools (“AI”) that help generate and enhance job descriptions and AI may have been used to create this description. The position description has been reviewed for accuracy and Dice believes it to correctly reflect the job opportunity.