Prophecy (MDM) & Power BI Data Engineer / Consultant

Alpha Consulting Corp. is 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 and operational dashboards to support enterprise-wide analytics and AI readiness initiatives.

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

Requirements:

• 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
• Strong understanding of data governance, lineage, and master data management principles
• Ability to work in a complex, multi-stakeholder environment with distributed teams
• Exposure to Client Fabric / Azure data ecosystem preferred
• 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