Senior Power BI Semantic Model Architect

Unison Group; Kuala Lumpur; On-site; MYR 180,000 - 240,000; Full time

Job summary

Unison Group in Malaysia seeks a Senior Power BI Data Modelling Consultant to design enterprise-grade semantic models and data solutions. The role focuses on semantic modeling in Power BI, VertiPaq/Import Mode, and implementing security models.

Key responsibilities include building scalable data models, integrating SQL Server and Oracle data, and supporting Microsoft Fabric Dataflows and Data Factory implementations. Strong communication with data engineers and business teams is required.

Qualifications

• Experience designing semantic models in Power BI for enterprise reporting.
• Strong knowledge of VertiPaq/Import Mode optimization.
• Proficient in building Composite Models with appropriate storage modes.
• Implementing Row-Level Security (RLS) across reports.
• Managing Power BI Workspace Security & RBAC.
• Experience with SQL Server and Oracle data integration.
• Modeling enterprise data with CDM/EDM standards.
• Familiarity with Microsoft Fabric Dataflows/Data Factory.

Responsibilities

• Design, develop and optimize Power BI Semantic Models for enterprise reporting.
• Build scalable data models using VertiPaq/Import Mode and optimize performance.
• Design and implement Composite Models using appropriate storage modes.
• Implement Row-Level Security (RLS) and manage Workspace RBAC.
• Integrate and model data from SQL Server and Oracle sources.
• Define Common Data Models (CDM) / Enterprise Data Models (EDM).
• Support Microsoft Fabric Dataflows and Data Factory implementations.
• Use Python/R to support analytics requirements.
• Establish data modelling standards and governance across BI solutions.

Skills

Power BI – Semantic Models & Data Mod

VertiPaq

Import Mode

Composite Models

Row-Level Security

Workspace Security

RBAC

SQL & Oracle Data Integration

Enterprise Data Modelling

CDM / EDM

Microsoft Fabric – Dataflows / Data 9,

Education

Bachelor's degree or equivalent

Tools

SQL Server

Oracle

Microsoft Fabric

Dataflows

Job description

Hiring: Senior Power BI Data Modelling Consultant – Expert

📍 Location: Malaysia
💼 Experience: 5+ years
🔹 Level: Senior Consultant

We are looking for an experienced Power BI SME with strong expertise in designing enterprise-grade semantic models and data solutions.

Mandatory Skills

✅ Power BI – Semantic Models & Data Modelling
✅ VertiPaq / Import Mode
✅ Composite Models
✅ Row-Level Security (RLS)
✅ Workspace Security & RBAC
✅ SQL & Oracle Data Integration
✅ Enterprise Data Modelling / CDM / EDM
✅ Microsoft Fabric – Dataflows / Data Factory

Key Responsibilities

• Design, develop and optimize Power BI Semantic Models for enterprise reporting and analytics.
• Build scalable data models using VertiPaq / Import Mode and optimize model performance.
• Design and implement Composite Models using appropriate storage modes.
• Implement Row-Level Security (RLS) and manage Power BI Workspace Security & RBAC.
• Integrate and model data from SQL Server and Oracle sources.
• Work closely with data engineering and business teams to define Common Data Models (CDM) / Enterprise Data Models (EDM).
• Support Microsoft Fabric Dataflows and Data Factory implementations.
• Use Python/R to support Spotfire TERR conversion and related analytics requirements.
• Establish data modelling standards, best practices and governance across enterprise BI solutions.