Senior MDM Analyst

Responsibilities

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

Education / 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.


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

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

#LI-AW1 #LI-Remote

About Octave

Octave provides mission-critical software that empowers organizations to make informed decisions across every stage of the asset lifecycle — Design, Build, Operate and Protect — where performance, safety, and reliability are non-negotiable and failure is not an option. 

Turning complex operational data into actionable intelligence, Octave connects expertise, real-world conditions and enterprise-scale insight to improve performance, resilience and incident response where it matters most. 

Octave has approximately 7,200 employees in 45 countries. Learn more at octave.com and follow us on LinkedIn. 

Why work for Octave?

All in. Always forward. That's the way we do things around here. We put trust in our people because we believe it's the best way to unleash potential, bring ideas to life, and keep moving ahead. And it's why we're committed to creating an environment that's truly supportive, providing you with the resources you need to support your ambitions, no matter who you are or where you are in the world.

Everyone is welcome

At Octave, we believe that diverse and inclusive teams are critical to the success of our people and our business. Here, everyone is welcome. As an inclusive workplace, we don't 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're valued here.