Senior MDM Analyst

Hexagon ALI is looking for a Senior Data Analyst to help support and mature our Master Data Management (MDM) practice in the Customer Master domain.  The Data Analyst will support the MDM team by analyzing data and ensuring data quality.  Data analysis will be done to ingest master data related to frequent merger and acquisition (M&A) activity as well for data enrichment and data cleanup purposes.  The individual is expected to be a technical resource who is well versed in utilizing a variety of tools and techniques for analyzing data.  This person will work with a team of both technical and business resources to enforce good MDM practices.

• 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.

• 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 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.
• 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 at any time, please refrain from applying.

#LI-KK1
#LI-Remote

Hexagon is the global leader in enterprise software, empowering organizations to build a safer, more sustainable and efficient future. We transform complex data into actionable insights that drive smarter decisions, modernize operations and accelerate digital maturity across industries that matter most — public safety, defense, transportation, government, industrial facilities and physical security.

Hexagon (Nasdaq Stockholm: HEXA B) has approximately 24,800 employees in 50 countries and net sales of approximately 5.4bn EUR. Learn more at  

At Hexagon, if you can see it, you can do it. Hexagon puts their trust in you so that you can bring your ideas to life. We have emerged as one of the most engaged and enabled workplaces*. We are committed to creating an environment that is truly supportive by providing the resources you need to fully support your ambitions, no matter who you are or where you are in the world. 

* In the recently concluded workplace effectiveness survey by Korn Ferry, a global HR advisory firm, Hexagon, has emerged as one of the most Engaged and Enabled workplaces, when compared to similar organizations that Korn Ferry partners with. 

At Hexagon, we believe that diverse and inclusive teams are critical to the success of our people and our business. Everyone is welcome—as an inclusive workplace, we do not discriminate. In fact, we embrace differences and are fully committed to creating equal opportunities, an inclusive environment, and fairness for all. 

Respect is the cornerstone of how we operate, so speak up and be yourself. You are valued here.