Job Description

Job Description – Power BI & SSAS Developer (Banking Domain, On-Premise with Denodo Integration)

Role Overview

We are seeking a Power BI & SSAS Developer to design and deliver enterprise-grade reporting and analytics solutions for the bank’s on-premise data ecosystem. The role involves building robust BI models, cubes, and dashboards, while integrating with the Denodo semantic/virtualization layer for unified and governed data access across business domains.

Key Responsibilities

Power BI Development

   Design and develop interactive dashboards, reports, and visualizations in Power BI for multiple banking domains (Payments, Loans, Cards, Trade, GL, etc.).

   Connect Power BI to Denodo virtual views, SQL Server, Oracle, and Teradata sources.

   Implement DAX calculations, measures, KPIs, and row-level security in reports.

   Optimize Power BI datasets for performance, scalability, and governance.

SSAS Development

   Design and maintain SSAS Tabular/Cube models aligned with the bank’s data warehouse and Denodo semantic layer.

   Implement advanced modeling features: hierarchies, partitions, perspectives, and calculations.

   Ensure SSAS models are optimized for query performance and concurrency.

   Expose SSAS models as trusted semantic layers for Power BI and other BI tools.

Integration with Denodo

   Collaborate with Denodo Architects/Developers to source curated Silver/Gold layer datasets.

   Use Denodo’s semantic abstraction for consistent KPIs and business definitions across BI models.

   Validate and reconcile ETL-driven data (SSIS/Informatica/Teradata) with Denodo-federated datasets.

Governance & Security

   Implement data masking, role-based access control, and row/column security in Power BI and SSAS.

   Ensure all BI assets comply with SAMA (Saudi Central Bank) and internal IT security guidelines.

   Work with Data Governance team to maintain lineage, metadata, and catalog consistency with Denodo.

Collaboration & Support

   Partner with ETL (SSIS/Informatica), Denodo, and business teams to enable end-to-end reporting solutions.

   Document data models, dashboards, and usage guidelines.

   Support SIT, UAT, and production releases of BI solutions.

Required Skills & Experience

• 5+ years of experience in Power BI & SSAS development in enterprise or banking environments.
• Strong expertise in DAX, Power Query (M), SSAS Tabular & Multidimensional models.
• Proficiency in SQL Server (T-SQL), performance tuning, and query optimization.
• Hands-on experience connecting Power BI to Denodo, SQL Server, Oracle, Teradata, Cloudera (Hive/Impala).
• Strong knowledge of data modeling, star schemas, and OLAP/semantic layer design.
• Familiarity with role-based access, data masking, and banking compliance requirements.

Nice to Have

• Experience with Denodo caching, REST/ODBC integration, and catalog metadata.
• Knowledge of Azure Power BI Report Server / Power BI Premium (if hybrid is planned).
• Exposure to Arabic-language reporting requirements (RTL layouts, localization).
• Familiarity with multi-vendor ecosystems (Cloudera, Teradata, Informatica, Denodo, Dell infra).