Prophecy MDM & Power BI Data Engineer

Job Title

Prophecy MDM & Power BI Data Engineer / Data Consultant

Role Summary

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.

Key Responsibilities

Power BI Development

• 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.

Master Data Management (MDM)

• 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.

Data Engineering

• 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.

Data Architecture

• 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.

Data Governance

• 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.

Collaboration

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

Performance Optimization

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

Documentation

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

Required Skills & Qualifications

Experience

• 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.

Business Intelligence

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

Master Data Management

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

Data Engineering

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

Data Modeling

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

Data Governance

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

Cloud & Modern Data Platform

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

Preferred Skills

• 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