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
Octave provides mission-critical software that empowers organizations to make informed decisions across every stage of the asset lifecycle. It was founded in 1985, and is headquartered in Madison, Alabama, USA, with a workforce of 5001-10000 employees. Its website is https://www.octave.com/.