Hexagon Asset Lifecycle Intelligence · 6 days ago
Senior MDM Analyst
Madison, AL
Full-time
Onsite
Senior Level
5+ years expHexagon Asset Lifecycle Intelligence is the global leader in enterprise software, empowering organizations to build a safer, more sustainable and efficient future. They are seeking a Senior MDM Analyst to support and mature their Master Data Management practice in the Customer Master domain, focusing on data analysis and ensuring data quality.
Software
No H1B
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
Qualification
Required
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
Ability to take initiative and work under limited supervision
Preferred
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 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
Experience working with data modeling is preferred
Company
Hexagon Asset Lifecycle Intelligence
Hexagon’s Asset Lifecycle Intelligence division helps clients design, construct and operate more profitable, safe and sustainable industrial facilities.
10001+ employees
Funding
Current Stage
Late StageLeadership Team
Melanie Eakes
Executive Vice President - Chief Technology Officer
Ismo Piirainen
Director, Pre-Sales
Company data provided by crunchbase