Senior Data Analyst (Remote)

Apply for this position Please mention DailyRemote when applying
Posted 2 days ago United States Salary undisclosed
Before you apply - make sure the job is legit.

Attempting to apply for jobs might take you off this site to a different website not owned by us. Any consequence as a result for attempting to apply for jobs is strictly at your own risk and we assume no liability.

Job Description

Overview:

About Hexagon
Hexagon is a global leader in sensor, software and autonomous solutions. We are putting data to work to boost efficiency, productivity, and quality across industrial, manufacturing, infrastructure, safety, and mobility applications. Our technologies are shaping urban and production ecosystems to become increasingly connected and autonomous ensuring a scalable, sustainable future.

Hexagons PPM division empowers its clients to transform unstructured information into a smart digital asset to visualize, build, and manage structures and facilities of all complexities, ensuring safe and efficient operation throughout the entire lifecycle.

Hexagon (Nasdaq Stockholm: HEXA B) has approximately 21,000 employees in 50 countries and net sales of approximately 3.8bn EUR. Learn more at hexagon.com and follow us .

2021 Hexagon AB and/or its subsidiaries and affiliates. All rights reserved.

Responsibilities:

Hexagon PPM is establishing a brand-new Master Data Management (MDM) practice in the Customer Master domain. The Data Analyst will support the MDM Architect on the new 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. The individual may also be asked to assist with the Collibra Metadata Management system.

  • 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 appropriatehierarchy 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 3 rd 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.
  • Provide support to the MDM Architect on other data related activities as needed.
  • Contribute to the data catalog
  • Share administration/configuration duties on the Collibra Metadata Management system.
  • Collaborate with the MDM Lead and Global Data Steward 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.
Qualifications:
  • 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. 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 a Metadata Management platform (especially Collibra) is preferred.
  • Experience in executing projects in an Agile environment 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.

Please note that while the position location is flexible, we currently require applicants to currently reside in the United States.

#LI-EW1

#LI-Remote