Prophecy (MDM) & Power BI Data Engineer

Title: Prophecy (MDM) & Power BI Data Engineer / Consultant
Location: Remote
Duration: Long Term on Contract
Experience: 10+ Years

Role Overview
We are seeking a skilled Data Engineer/Consultant to design and build end-to-end Power BI reporting solutions on top of the 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, Ataccama).
• 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 (Ataccama) 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.