[Remote] Senior MDM Analyst

Note: The job is a remote job and is open to candidates in USA. Octave is a company that provides mission-critical software to empower 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 related to mergers and acquisitions.

Responsibilities

• Profile new data for quality assurance purposes
• Perform 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 when 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 within systems
• Transform data into required format for ingestion into various systems
• Perform ETL operations on new (M&A) or existing data sources Develops, designs, and optimizes complex SQL/T-SQL queries in data analysis and transformation
• Perform 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 Collibra data governance and data catalog platform. This includes building workflows, managing page layouts, maintaining security, ingesting metadata, etc
• Collaborate with the MDM Lead and Global Data Stewards on the business side 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 Excel 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, Lineage and etc. is preferred
• Experience with some Data Governance/Catalog platform is preferred
• Experience working with data modeling is preferred

Company Overview