Power BI Developer – Reporting & Visualization Specialist

Job Purpose
The Power BI Developer will be responsible for designing, developing, and optimizing
interactive dashboards and reports to support the Business Intelligence Unit (BIU) at Bank
Muscat. The role involves working with on-premise Power BI Report Server and SQL Server
databases to ensure data-driven decision-making. The ideal candidate will have strong
experience in banking analytics, data visualization, and financial reporting while ensuring
that reports align with key banking metrics and operational requirements.

Key Tasks and Duties
1. Power BI Development & Reporting:
 Design, develop, and optimize interactive dashboards and reports using Power BI for
banking analytics.
 Implement data modeling, DAX calculations, and Power Query transformations for
efficient reporting.
 Ensure that reports are visually impactful, user-friendly, and aligned with UI/UX best
practices.
2. Data Management & SQL Processing:
 Develop and optimize T-SQL queries and stored procedures to extract and process
banking data.
 Work with on-premise SQL Server databases to create structured data models for
reporting.
 Ensure data integrity, security, and accuracy in reports and dashboards.

3. Performance Optimization & Security:
 Monitor report performance and refresh schedules, troubleshooting any latency
issues.
 Implement Row-Level Security (RLS) and access control on Power BI Report
Server.
 Optimize Power BI data models for faster load times and efficient processing.
4. Business & Banking Analytics Integration:
 Collaborate with BIU team leads to refine reporting requirements based on banking
operations and financial metrics.
 Work with financial and transactional data to ensure accurate reporting for decision
making.
 Provide insights to stakeholders by leveraging data visualization techniques.

Qualification
Bachelor’s degree in Computer Science, Data Analytics, Business Intelligence, or a
related field.
 Experience with SAS for financial data processing.
 Hands-on experience with SSRS (SQL Server Reporting Services) for paginated reports.
 Familiarity with big data processing and ETL (Extract, Transform, Load) pipelines.
Experience
 5+ years of experience in Power BI dashboard development with on-premise Power BI
Report Server.
 Extensive banking domain experience, working with financial and transactional data.
 Hands-on experience with on-premise SQL Server databases for structured data processing.
 Experience in developing paginated reports using SSRS (SQL Server Reporting Services)
is preferred.
 Experience with SAS-based data processing is an added advantage.