MDM consultant: what they do, how much they earn, and how to become one

An MDM consultant is the professional you call when a company's master data has become a problem nobody else wants to own. Duplicate customers, suppliers with no vetting, a material classified three different ways. The company feels the pain every day, but rarely knows how to name the cause. This professional steps in precisely to name the cause and build the way out.

I have worked in technology for almost thirty years, and a good part of that time went to SAP projects, master data and governance. I was a consultant before founding 4MDG, and I know firsthand the difference between the consultant who solves the problem and the one who just delivers a pretty report. This article is about the first kind.

What an MDM consultant does day to day

The work almost always starts the same way: someone at the company notices the ERP is full of bad records and calls in outside help because the internal team doesn't have the time, or the know-how, or the authority to fight with every department at once.

From there, an MDM consultant usually works across four fronts. The first is diagnosis: measuring the volume of duplicates, empty mandatory fields, discrepancies between systems. The second is process design: who approves the creation of a supplier, who owns the material data, what workflow a record follows before it becomes a transaction. The third is tool selection and configuration, because a process without a system becomes a rule nobody follows. The fourth is behavior change inside the company, which is the hardest part and the one that most separates a good consultant from a bad one.

I have seen MDM projects sink with the best tool on the market because nobody convinced the purchasing team to change the way they create suppliers. The tool solves execution. Persuasion solves adoption. The MDM consultant has to deliver both.

Who hires an MDM consultant

The demand comes mainly from mid-sized and large companies with a complex ERP, usually SAP, TOTVS or Oracle, and operations spread across several units or countries. Purchasing and procurement call when the material and supplier master is blocking the operation. IT calls when it needs to migrate to a new system and discovers the current base can't support the project. The data office calls when it wants to put artificial intelligence to work and realizes the input data is too bad to trust the output.

Mergers and acquisitions also generate a lot of work. When two companies come together, each arrives with its own customer and supplier master, and someone has to decide which record survives. ERP migration is another classic entry point, because nobody wants to carry dirty records into the new system.

Which tools an MDM consultant needs to know

Nobody masters all of them, but you're expected to move comfortably among the main platforms on the market. For MDM and master data governance, the most cited in corporate projects are SAP Master Data Governance, Informatica MDM, Stibo Systems, Reltio, Semarchy, Profisee and Ataccama. Each has a different strength: some were born strong in product, others in customer, others in cloud architecture.

It's also worth knowing data catalog and metadata tools, such as Collibra, Alation and Microsoft Purview, because master data governance and data catalogs increasingly go together. And for data quality, Ataccama and Informatica Data Quality show up often in the same accounts.

Knowing the tool matters, but I know plenty of technical consultants who are excellent at system parameters and freeze when it's time to explain to the CFO why investing in data cleansing is worth it. The market pays more for those who can do both.

How to become an MDM consultant

The most common path starts inside the company itself, as a master data analyst, data analyst or SAP functional consultant, and evolves toward governance and master data projects as the person gains hands-on experience with real volumes of bad data. There is no shortcut that replaces that.

Technical training helps a lot. SQL to check and validate the base, a grasp of data modeling, knowledge of at least one major ERP, because most corporate projects go through SAP, TOTVS or Oracle. If you already work with data and want to move into MDM, you usually gain speed by studying the DAMA-DMBOK, which is the field's reference guide, and pursuing a certification like DAMA's CDMP. There's a widely repeated myth in Brazil that certification is worthless. Nonsense. It doesn't replace experience, but it organizes your knowledge and opens doors in hiring processes.

Taking part in the community also counts. Events like Amigos do Cadastro, discussion groups and podcasts on the topic help you understand how other companies solved the same problem you're solving now, and that speeds up the learning curve a lot.

Opportunities and how much an MDM consultant earns

Demand for this profile has grown in recent years in Brazil, driven by two movements: migration projects to SAP S/4HANA, which force the company to face its master data once and for all, and the race for artificial intelligence, which made it clear to many executive teams that enterprise AI doesn't fix bad data, it only amplifies the error faster.

The salary range varies a lot depending on the hiring arrangement and seniority. A junior master data analyst inside a company, under a CLT contract (Brazil's formal employment regime), usually starts in the range of R$ 4,000 to R$ 6,000 per month. A senior consultant with proven experience in MDM projects, working as CLT at a large consultancy, usually lands between R$ 10,000 and R$ 18,000 per month. Those who work as PJ (a contractor operating through their own company) or as independent consultants, charging per project or per day, get much higher figures, especially when they combine technical knowledge of the tool with the ability to lead the project end to end. These numbers vary from region to region and from company to company, so use them as a market reference, not a promise.

Main questions about the MDM consultant career

Do I need to know how to program to be an MDM consultant? You don't need to be a developer, but basic SQL for querying and validating data is practically mandatory. Knowledge of MDM tool configuration weighs more than pure programming.

Is the CDMP certification worth it? It is, especially for those moving from another area into master data and governance. The certification doesn't replace a real project, but it organizes theoretical knowledge and helps you get through more technical hiring processes.

Can you be an MDM consultant without prior SAP experience? You can, but those who know SAP, TOTVS or Oracle get a head start, because most corporate MDM projects in Brazil run on top of one of those ERPs.

What's the difference between an MDM consultant and a data steward? The data steward is normally internal to the company and looks after data quality day to day in a specific domain, like supplier or material. The MDM consultant is usually hired to design the process, implement the tool and leave the structure ready for the data steward to operate afterward.

Is the MDM market in Brazil still growing? It is. Migration to S/4HANA, the growth of enterprise AI and the rise in mergers and acquisitions keep generating demand for people who know how to really organize master data.

MDM Academy: where to train for this career

I created MDM Academy precisely because I felt Brazil lacked a serious place to train people in data governance and Master Data Management with practical depth, not just slide-deck theory. It's 4MDG's school of governance and master data, designed for people who already work with master data and want to advance, and for those who want to enter the field coming from purchasing, IT, quality or data.

Inside you'll find a training track, real project case studies, contact with people already living the problem in practice, and a community of professionals sharing experience, the Data Club. If you recognized yourself in what I described in this article and want to turn it into a career or into a project inside your company, it's worth getting to know MDM Academy and joining the Data Club.

Conclusion

MDM consultant is not a role you learn from theory alone. It's a profession built by dealing with truly dirty master data, convincing people who don't want to change, and choosing the right tool for the right problem. The Brazilian market is asking for more people like this than it is training.

At your company, has the person who looks after master data today ever thought about following this path as a career?