Prophecy MDM & Power BI Data Engineer

Prophecy MDM & Power BI Data Engineer / Data Consultant

We are seeking an experienced Prophecy MDM & Power BI Data Engineer / Consultant to design develop and implement enterprise-grade reporting and analytics solutions using Prophecy MDM (Master Data Management) and Microsoft Power BI. The ideal candidate will have strong expertise in Power BI dashboard development data modeling Master Data Management (MDM) SQL ETL/ELT pipelines and data governance.

The role involves designing scalable reporting architectures building semantic models integrating Prophecy MDM with downstream reporting platforms and enabling enterprise-wide analytics through high-quality governed master data.

• Design develop and maintain interactive Power BI dashboards reports and scorecards.
• Create executive and operational dashboards for business KPIs data quality and governance metrics.
• Develop scalable semantic models using Power BI datasets.
• Optimize report performance DAX calculations and visualization efficiency.

• Develop reporting solutions using Prophecy MDM/RDM platform.
• Work with master data domains hierarchies classifications and entity relationships.
• Design reporting datasets based on enterprise Golden Record/Golden Copy principles.
• Support Master Data Management initiatives across multiple business domains.

• Design and implement ETL/ELT pipelines.
• Integrate Prophecy MDM with enterprise reporting platforms.
• Develop scalable data models supporting analytics and reporting.
• Build and optimize SQL queries for large-scale datasets.
• Support structured and unstructured data processing.

• Design relational and hierarchical data models.
• Build enterprise semantic layers for reporting.
• Support data warehouse architecture and reporting frameworks.
• Optimize data processing and reporting performance.

• Ensure compliance with enterprise data governance standards.
• Support data lineage and metadata management.
• Collaborate with governance teams using:
  • Alation
  • Ataccama
• Implement best practices for data quality and master data management.

• Work closely with:
  • Business Stakeholders
  • Data Architects
  • Data Engineers
  • BI Developers
  • Analytics Teams
• Translate business reporting requirements into technical solutions.

• Optimize:
  • Power BI reports
  • SQL queries
  • Semantic models
  • ETL jobs
  • Data pipelines
• Improve reporting scalability and efficiency.

• Create:
  • Technical Design Documents
  • Data Flow Diagrams
  • Data Models
  • ETL Documentation
  • Reporting Specifications
  • Deployment Documentation

• 6 years of experience in Data Engineering Business Intelligence or Data Analytics.
• Experience with enterprise Master Data Management (MDM) platforms.
• Strong experience delivering Power BI reporting solutions.

• Microsoft Power BI
• Power BI Service
• Power BI Desktop
• DAX
• Power Query
• Semantic Models
• Dashboard Development
• Report Optimization

• Prophecy MDM
• Reference Data Management (RDM)
• Master Data Management
• Golden Record
• Golden Copy
• Hierarchical Data Models
• Entity Relationships

• SQL
• ETL
• ELT
• Data Pipelines
• Data Integration
• Data Transformation
• Data Processing

• Relational Data Modeling
• Hierarchical Data Modeling
• Star Schema
• Snowflake Schema
• Data Warehouse Design

• Data Governance
• Data Lineage
• Metadata Management
• Data Catalog
• Alation
• Ataccama

• Microsoft Azure
• Microsoft Fabric (Preferred)
• Azure Data Factory (Preferred)
• Azure Synapse (Preferred)

• Microsoft Fabric
• Azure Data Factory
• Azure Synapse Analytics
• AI/ML Data Readiness
• Enterprise Data Transformation
• Data Lake
• Data Lakehouse
• Azure SQL
• Data Quality Frameworks
• Enterprise Analytics Platforms