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. This role is crucial for 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:
- 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.
Preferred Skills:
- 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.