Power BI Developer – Data Engineering, Reporting & Dashboard Specialist

Job Purpose
The Power BI Developer – Data Engineering, Reporting & Dashboard Specialist will be
responsible for designing, developing, and optimizing interactive dashboards, data models,
and SQL-based ETL pipelines to support the Business Intelligence Unit (BIU) at Bank
Muscat. The role requires strong expertise in Power BI dashboard development, data
modeling, and SQL-based data transformations to ensure accurate and efficient reporting.
The ideal candidate must have extensive experience working with financial and transactional
data in the banking sector and should be proficient in working with on-premise Power BI
Report Server and SQL Server-based solutions.

Key Tasks and Duties
1. Power BI Development & Dashboard Reporting:
 Design, develop, and optimize Power BI dashboards that visualize complex financial
and banking data.
 Work with on-premise Power BI Report Server to publish, maintain, and update
reports.
 Apply UI/UX best practices to develop intuitive, user-friendly dashboards for business
users.
 Implement advanced DAX calculations, Power Query transformations, and data
blending techniques.
2. Data Engineering & SQL-based ETL Pipelines:
 Develop SQL-based ETL pipelines to process and structure data for Power BI
reporting.

 Write and optimize T-SQL queries, stored procedures, and indexing strategies for
performance tuning.
 Design and maintain efficient data models (star schema, snowflake schema) for
structured reporting.
 Work with SQL Server Integration Services (SSIS) to build, monitor, and manage
ETL workflows.
 Automate data refresh processes and ensure seamless integration of data pipelines
with Power BI.
3. Data Security & Governance:
 Implement Row-Level Security (RLS) and role-based access control in Power BI.
 Ensure adherence to data governance policies, security standards, and compliance
regulations in banking analytics.
 Monitor report refresh schedules and troubleshoot data processing errors.
4. Business & Banking Analytics Alignment:
 Work closely with BIU team leads to align Power BI reports with business and banking
operational needs.
 Ensure that financial and transactional data is accurately represented in reports for
decision-making.
 Collaborate with stakeholders to refine reporting requirements and enhance
analytical capabilities.
5. Performance Optimization & Troubleshooting:
 Optimize Power BI report performance to reduce load times and enhance
responsiveness.
 Conduct root cause analysis and debugging of report failures or incorrect data
aggregations.
 Continuously improve dashboard interactivity, responsiveness, and usability.

Qualification
 Bachelor’s degree in Computer Science, Data Analytics, Information Technology, or a
related field.
 Certifications in Power BI, SQL Server, or Data Engineering (preferred).
 Experience with SSIS (SQL Server Integration Services) for ETL workflows.
 Familiarity with SAS for financial data processing.
 Understanding of SSRS (SQL Server Reporting Services) for paginated reports.