Senior MDM Analyst

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; develop, design, and optimize 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 Collibra data governance and data catalog platform (build workflows, manage page layouts, maintain security, ingest metadata, etc.).
• Collaborate with the MDM Lead and Global Data Stewards on the business side to provide data support.
• Communicate status updates and open issues to technical and business resources in a clear manner.
• Support data analysis on other types of master data or even transactional data as needed over time.

• 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 with XML and JSON is a plus.
• Experience working with large datasets is expected.
• 2+ years of experience with data profiling/quality tools.
• Exposure to data governance key concepts like Metadata Management, Business Glossary, Cataloging, Lineage, etc. is preferred.
• Experience with a data governance/catalog platform is preferred.
• Experience working directly with key business stakeholders.
• Experience collaborating and communicating 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 working with data modeling is preferred.

Hexagon is unable to provide visa sponsorship at any time during employment – if sponsorship will be required, please refrain from applying.

Location:

Madison, AL