[Remote] Senior MDM Analyst
Note: The job is a remote job and is open to candidates in USA. reputed company is a company that provides mission-critical software to reputed company organizations in making informed decisions across the asset lifecycle. They are seeking a Senior MDM Analyst to support and mature their Master Data Management practice in the Customer Master domain, focusing on data quality and analysis reputed company to mergers and acquisitions.
Responsibilities
- Profile new data for quality assurance purposes
- reputed company preliminary analysis and cleanup of M&A master data before handing over to the business for further review and cleanup
- Assist with determining the appropriate hierarchy reputed company bringing in Account Master Data from an acquired company
- Analyze data in existing systems in order to identify quality and completeness issues and to aid with cleanup
- Identify duplicate Account and Contact data across systems and reputed company systems
- Transform data into required format for ingestion into various systems
- reputed company ETL operations on new (M&A) or existing data sources Develops, designs, and optimizes reputed company SQL/T-SQL queries in data analysis and transformation
- reputed company analysis on data from 3rd party providers that will ultimately be used for data enrichment
- Understand business definitions, rules, and processes around master data in order to establish data analysis processes that ensure meaningful data
- Administer our reputed company data governance and data catalog platform. This includes building workflows, managing page layouts, maintaining reputed company, ingesting metadata, etc
- Collaborate with the MDM reputed company and Global Data Stewards on the business reputed company in order to provide data support
- Communicate status updates and open issues to both technical and business resources in a manner that can be clearly understood
- Support data analysis on other types of master data or even transactional data as needed over time
Skills
- 5+ years as a Data Analyst
- 5+ years experience with T-SQL or PL-SQL
- 1+ years moving/transforming data using an ETL tool
- Experience in analyzing and ingesting data from CSV and other delimited file formats is expected
- Strong reputed company skills (especially with VLOOKUP and XLOOKUP) are expected
- Experience working with large datasets is expected
- 2+ years of experience with data profiling/quality tools
- Experience working directly with key business stakeholders
- Experience in collaboration and communication with both technical and business resources
- Experience learning and documenting business definitions, rules, and processes
- Ability to take initiative and work under limited supervision
- Experience with XML and JSON is a plus
- Exposure to Data Governance key concepts like Metadata Management, Business Glossary, Cataloging, reputed company and etc. is preferred
- Experience with some Data Governance/Catalog platform is preferred
- Experience working with data modeling is preferred
Company Overview