Master Data Management Specialist - SME
The Master Data Management (MDM) Developer works with business users to identify, scope, analyze and finalize requirements for MDM implementation. Pilots and prototypes MDM projects and follows up to complete a production MDM implementation. Tasks involve all phases of the MDM implementation process including requirements analysis, system design, programming, testing, roll-out, maintenance, and operational support. Provide guidance to IT Staff in their tasks.
Activities
Provides subject matter expertise on Master Data Management and ETL Concepts.
Drives project management through technical decisions related to master data management.
Builds/enhances data models and database architecture for MDM.
Assists in developing the MDM solution architecture.
Performs technical translation of business master data management requirements.
Represents the business perspective of data analysis and design discussions.
Reviews design/functional specifications to develop detailed technical requirements document.
Translates functional specifications into technical specification.
Performs a wide range of tasks relating to data extraction, data scrubbing, and data transformation, maintenance of metadata and data dictionaries.
Creates the necessary documentation to build, administer, and support all test, development, and production environments.
Provides for data warehouse architecture design, which includes logical and physical design of data warehouse, data marts, staging area, etc.
Provides technical expertise for data warehousing, OLAP technology, and data management including data extraction, transformation and loading processes (ETL).
Skills Requirements:
Required Skills
Working knowledge of design, development, and support of an MDM hub
Working knowledge of extract functionality to downstream systems.
Extensive experience with ETL processes and tools.
Experience developing multiple cleansing and standardization scenarios using mappings & industry standard products.
Experience collaborating with developers on designing & developing web-services that can integrate Master Data with other systems.
Working knowledge of business reporting tools.
Advanced knowledge of data warehousing, data mart design and implementation.
Excellent communication skills, both oral and written.
Preferred:
Experience with enterprise MDM software.
Experience with multiple programming languages.
Experience with data modeling software.
PMP certification or other related training.
Minimum Experience
10 years of progressive enterprise experience in Data Analysis, Business Intelligence, Analytics, or Data Warehouse solutions using proven solution delivery methodology framework.
5 years of progressive experience in Master Data Management and MDM Hub Implementation.
Experience with data warehousing and data mart design and implementation.
Experience with business intelligence tools.
Advanced technical experience with at least one OLAP tool.
Education: 10 years of progressive enterprise experience in Data Analysis, Business Intelligence, Analytics, or Data Warehouse solutions using proven solution delivery methodology framework.
5 years of progressive experience in Master Data Management and MDM Hub Implementation.