Senior MDM Analyst

Octave; Madison (AL); Remote; USD 80,000 - 100,000; Full time

Benefits offered by this job

Inclusive work environment

Career development resources

Job summary

A global software provider is seeking a Senior Data Analyst to support master data management efforts. The candidate will analyze data quality, manage ETL processes, and collaborate with technical and business teams. Ideal applicants should have 5+ years of experience in data analysis and proficiency in T-SQL, with strong skills in data profiling and governance. The role offers a remote work option and requires excellent communication abilities.

Qualifications

• 5+ years experience with data analysis, particularly in MDM.
• Experience analyzing and ingesting data from CSV and other formats.
• Ability to communicate issues clearly to both technical and business teams.

Responsibilities

• Support the MDM team by analyzing data to ensure quality.
• Perform ETL operations on master data related to M&As.
• Administer data governance and catalog platform.

Skills

Data Analysis

ETL Processes

T-SQL

Data Profiling

Excel (VLOOKUP, XLOOKUP)

Education

5+ years as a Data Analyst

5+ years with T-SQL or PL-SQL

2+ years with Data Governance tools

Tools

Collibra

ETL tools

Job description

Job Location (Short): Madison, Alabama-USA

Workplace Type: Remote

Req Id: 2635

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. Develop and design 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 to establish data analysis processes that ensure meaningful data.
• Administer our Collibra data governance and data catalog platform, building workflows, managing page layouts, maintaining security, ingesting 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 both 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.

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.

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.