Master Data Management (MDM) Anchor

Ford Motor Company•Dearborn, MI

63d

About The Position

As a Master Data Management (MDM) Informatica IDQ and MDM Technical Anchor, you will be instrumental in applying our MDM strategies, requirements, and policies, ensuring they align with the company's vision. You will actively support the solutioning, architectural design, and oversee the implementation of our MDM solutions built on Informatica platform technologies. This hands-on role will involve leading the design and development of the information architecture for a robust MDM platform, focusing on matching and consolidating critical data subject areas to support our strategic objectives. We are looking for candidates with: Proven experience in implementing MDM solutions, specifically with Informatica. Prior experience with Informatica MDM solutioning and architectural design is highly valued. Experience with Informatica IDMC Cloud is a significant plus. Hands-on expertise across the entire MDM solution lifecycle, including data profiling, integration, validation, cleansing, standardization, matching, and consolidation. A strong understanding of data structures and relationships. Excellent data analysis skills, with strong proficiency in SQL. The ability to understand and assess Source to Target mapping documents, providing insightful recommendations. Knowledge of technology and software development processes. Strong presentation development and delivery skills. A proactive and strategic mindset, capable of anticipating issues and planning effectively. Join our team as an MDM Informatica IDQ and MDM Technical Anchor to play a pivotal role in shaping our company's data landscape. You'll contribute to applying MDM strategies, requirements, and policies, and support the solutioning, architectural design, and leadership of robust MDM solutions using Informatica platform technologies. This role offers the opportunity to lead the design and development of the architecture for a comprehensive MDM platform that aligns with our strategic vision by matching and consolidating key data subject areas. Your primary responsibilities will center on leading Informatica IDQ and Informatica MDM initiatives, requiring strong SQL skills for guidance and analysis. Beyond technical expertise, a background in Data Management and its relevance to the business needs of internal customers (such as Purchasing, Finance and Accounting, Manufacturing, and Service) is highly valued, particularly regarding the lifecycle of materials supporting enterprise business processes. The ability to collaborate effectively within a diverse and global team is essential. Your primary responsibilities will center on leading Informatica IDQ and Informatica MDM initiatives, requiring strong SQL skills for guidance and analysis. Beyond technical expertise, a background in Data Management and its relevance to the business needs of internal customers (such as Purchasing, Finance and Accounting, Manufacturing, and Service) is highly valued, particularly regarding the lifecycle of materials supporting enterprise business processes. The ability to collaborate effectively within a diverse and global team is essential.

Requirements

Proven experience in implementing MDM solutions, specifically with Informatica.
Hands-on expertise across the entire MDM solution lifecycle, including data profiling, integration, validation, cleansing, standardization, matching, and consolidation.
A strong understanding of data structures and relationships.
Excellent data analysis skills, with strong proficiency in SQL.
The ability to understand and assess Source to Target mapping documents, providing insightful recommendations.
Knowledge of technology and software development processes.
Strong presentation development and delivery skills.
A proactive and strategic mindset, capable of anticipating issues and planning effectively.

Nice To Haves

Prior experience with Informatica MDM solutioning and architectural design is highly valued.
Experience with Informatica IDMC Cloud is a significant plus.
Beyond technical expertise, a background in Data Management and its relevance to the business needs of internal customers (such as Purchasing, Finance and Accounting, Manufacturing, and Service) is highly valued, particularly regarding the lifecycle of materials supporting enterprise business processes.
The ability to collaborate effectively within a diverse and global team is essential.

Responsibilities

MDM Solutioning & Architectural Design: Lead the design and architecture of Informatica MDM solutions, ensuring scalability, performance, and alignment with business requirements and enterprise data strategy.
Informatica MDM Configuration: Oversee and guide the configuration and customization of Informatica MDM, defining entity types, relationships, business rules, match and merge strategies, and user interfaces.
Data Modeling: Collaborate with data architects and stakeholders to lead the design and maintenance of the data model within the MDM system, ensuring data accuracy and consistency.
Data Integration: Direct the integration of data from various source systems into Informatica MDM, performing data profiling, cleansing, and transformation to ensure data quality and integrity.
Match and Merge: Define and guide the implementation of robust match and merge rules to identify and consolidate duplicate records within party entities, enabling a single, accurate view of each entity.
Data Quality Management: Lead the definition and implementation of data quality rules and workflows within the MDM system to monitor, measure, and continuously improve data quality across party-related data.
Data Governance: Ensure strict adherence to data governance principles and data security best practices throughout MDM implementation and ongoing data management processes.
Performance Optimization: Identify and resolve performance bottlenecks within the MDM system, leading efforts to optimize data loading, matching, and retrieval processes for efficient and seamless operations.
Collaboration: Work closely with cross-functional teams, including data architects, data analysts, and business users, to understand data requirements and lead the delivery of MDM solutions that precisely meet business needs.
Testing and Validation: Oversee and guide thorough unit and integration testing to validate MDM configurations, ensuring the accuracy and completeness of data within the MDM repository.
Documentation: Maintain comprehensive technical documentation, including design specifications, configuration guides, and troubleshooting manuals for the MDM implementation.
Reporting & Analysis: Review and analyze ongoing business requirements, build useful and efficient reporting for validating MDM activities, analyze existing SQL queries, suggest improvements, create scripts and procedures for data migration, and provide timely scheduled reporting.