Prophecy (MDM) & Power BI Data Engineer Consultant

Prophecy (MDM) & Power BI Data Engineer / Consultant
Role Overview

We are seeking a skilled Data Engineer/Consultant to design and build end-to-end Power BI reporting solutions on top of Prophecy (MDM/RDM platform). The role focuses on enabling hierarchical data visualization operational dashboards and scalable data architecture to support enterprise-wide analytics and AI readiness initiatives.

Key Responsibilities:

• Design and develop Power BI dashboards and reports leveraging data from Prophecy MDM ensuring clear hierarchical visualization (e.g. domain classification and entity relationships).
• Build operational and executive dashboards to monitor data quality governance and business KPIs.
• Architect and implement scalable semantic models and data pipelines integrating Prophecy with downstream reporting layers.
• Collaborate with data architects and business stakeholders to deliver golden copy reporting datasets aligned with enterprise MDM strategy.
• Support the expansion of classification data models and Matter 360 initiatives by translating complex data structures into actionable insights.
• Ensure alignment with data governance lineage and cataloging standards (Alation Atacama).
• Optimize performance of reports and datasets for large-scale unstructured and evolving data environments.
• Contribute to transitioning from project-based delivery to a program-based scalable reporting framework.

Required Skills & Experience:

• Strong experience with Power BI (data modeling DAX dashboards and performance tuning).
• Hands-on experience with Prophecy (MDM/RDM) or similar MDM platforms.
• Solid understanding of data architecture data modeling (hierarchical/relational) and data warehousing concepts.
• Experience integrating with data quality (Atacama) and data cataloging tools (Alation) is a plus.
• Proficiency in SQL ETL/ELT pipelines and large-scale data processing.
• Exposure to Microsoft Fabric / Azure data ecosystem preferred.
• Strong understanding of data governance lineage and master data management principles.
• Ability to work in a complex multi-stakeholder environment with distributed teams.

Nice to Have:

• Experience in AI/ML data readiness and analytics platforms.
• Prior experience in enterprise data transformation or MDM programs.
• Familiarity with consulting-led data transformation engagements.