Power BI Specialist (Level 3)

Work location - Saudi, in Riyadh Position Title Power BI Specialist (Level 3) Department Information Technology / Data & Analytics Reports To Analytics Manager / BI Lead / Data Platform Manager Job Summary The Power BI Specialist (L3) is a senior technical expert responsible for designing, developing, optimizing, and governing enterprise Business Intelligence solutions using Microsoft Power BI. The role involves working closely with business stakeholders, data engineers, architects, and project teams to deliver scalable dashboards, advanced analytics, and self-service BI capabilities while ensuring performance, security, and data governance. ______________________________________ Key Responsibilities Power BI Development • Design and develop enterprise-grade Power BI dashboards and reports. • Build interactive executive dashboards and operational reports. • Develop reusable datasets and semantic models. • Create drill-through, drill-down, bookmarks, tooltips, and advanced visualizations. • Develop paginated reports using Power BI Report Builder. • Implement mobile-optimized reports. Data Modeling • Design star and snowflake schemas. • Build optimized data models. • Create calculated columns, measures, and KPIs. • Implement slowly changing dimensions where required. • Manage relationships and hierarchies. Power Query (M Language) • Develop advanced Power Query transformations. • Clean and normalize data. • Merge and append datasets. • Parameterize queries. • Optimize refresh performance. ________________________________________ Data Integration Integrate Power BI with: • SQL Server • Azure SQL • Oracle • MySQL • PostgreSQL • SharePoint • Excel • CSV • REST APIs • Dynamics 365 Performance Optimization • Optimize report performance. • Reduce refresh times. • Optimize DAX queries. • Tune Power Query. • Optimize Import and DirectQuery models. • Monitor Premium Capacity. • Analyze Performance Analyzer outputs. ________________________________________ Security & Governance • Implement Row-Level Security (RLS). • Implement Object-Level Security (OLS). • Configure Workspace security. • Manage deployment pipelines. • Implement governance standards. • Apply Microsoft Power BI best practices. • Ensure data privacy and compliance. Power BI Service Administration • Workspace management • Gateway configuration • Scheduled refresh • Incremental Refresh • Deployment Pipelines • Dataflows • Apps • Tenant settings • Capacity management Automation Develop automation using: • Power Automate • Power Apps integration • Power BI REST API • PowerShell • XMLA Endpoints Stakeholder Management • Gather business requirements. • Translate requirements into analytical solutions. • Conduct workshops. • Train end users. • Support self-service BI initiatives. • Prepare technical documentation. Production Support (L3) • Resolve complex incidents. • Perform root cause analysis. • Optimize production environments. • Support critical dashboards. • Troubleshoot gateway issues. • Support Premium Capacity. • Coordinate with Microsoft Support when required. ________________________________________ Required Technical Skills Power BI • Power BI Desktop • Power BI Service • Power BI Report Builder • Power BI Mobile • Power BI Embedded • Power BI Gateway • Deployment Pipelines ________________________________________ Languages • Power Query (M) • SQL (Advanced) ________________________________________ Databases • SQL Server • Azure SQL • Oracle • PostgreSQL • MySQL • Snowflake (Preferred) ________________________________________ Integration • REST APIs • OData • XMLA • SharePoint • Excel Services Required Soft Skills • Excellent analytical thinking • Strong communication skills • Business analysis capability • Stakeholder management • Presentation skills • Documentation skills • Problem-solving mindset • Leadership and mentoring • Time management • Customer-focused approach Experience • Bachelor's degree in Computer Science, Information Systems, Data Analytics, or related field. • 5–8+ years of BI/Data Analytics experience. • Minimum 4 years of hands-on Power BI development. • Experience delivering enterprise-scale BI solutions. • Experience supporting production Power BI environments. • Experience with Agile/Scrum methodologies. ________________________________________ Preferred Certifications Microsoft • Microsoft Certified: Power BI Data Analyst Associate (PL-300) • Microsoft Certified: Fabric Analytics Engineer Associate (DP-600) • Microsoft Certified: Azure Data Engineer Associate (DP-203) Other • ITIL® Foundation