Power BI Data Engineer_ W2 _ Remote -Long Term Contract

Power BI Data Engineer
Location:  Chicago, IL or REMOTE
Duration:  Long Term

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 Al readiness initiatives.

Key Responsibilities
• Design and develop Power Bl 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 Al/ML data readiness and analytics platforms.
• Prior experience in enterprise data transformation or MDM programs.
• Familiarity with consulting-led data transformation engagements