Power Bi Developer jobs in United Arab Emirates

We are seeking a skilled Power BI & MicroStrategy Developer with foundational knowledge of PL/SQL to join our dynamic team. The ideal candidate will design, develop, and maintain business intelligence solutions, enabling actionable insights for business stakeholders.
Key Responsibilities

• Design, develop, and deploy interactive dashboards and reports using Power BI and MicroStrategy.
• Collaborate with business users to understand reporting requirements and translate them into technical solutions.
• Optimize dashboards and reports for performance and scalability.
• Develop and maintain database queries and procedures using PL/SQL for data extraction and manipulation.
• Ensure data accuracy, consistency, and integrity across BI platforms.
• Provide technical support and troubleshooting for Power BI and MicroStrategy solutions.
• Stay updated on the latest BI technologies and trends to recommend improvements and best practices.

Qualifications And Skills

• Experience: 3+ years of hands-on experience in Power BI and MicroStrategy development.
• Technical Skills:
• Strong expertise in creating visualizations, dashboards, and reports in Power BI and MicroStrategy.
• Basic knowledge of PL/SQL for database queries and procedures.
• Understanding of data modeling, data warehousing, and ETL processes.
• Power BI Desktop: Expertise in developing reports and visualizations using Power BI Desktop.
• Power BI Service: Knowledge of the Power BI Service for report sharing, collaboration, and distribution.
• DAX (Data Analysis Expressions): Proficiency in writing DAX for measures, calculated columns, and advanced analytics.
• Power Query / M: Familiarity with Power Query and M language for data transformation tasks.
• SQL: Strong SQL skills to query relational databases, create views, and optimize queries for use in Power BI.
• Data Modeling: Strong understanding of data modeling concepts, including star/snowflake schemas, relationships, and cardinality.
• ETL Tools: Experience with data extraction, transformation, and loading (ETL) processes, particularly using Power BI tools.
• Azure: Knowledge of Azure services such as Azure SQL Database, Azure Data Lake, and Azure Synapse Analytics for cloud-based data storage and analysis.

1. Data Modeling and Transformation

• Data Extraction and Integration: Extract data from various sources like SQL Server, Excel, CSV, cloud databases (e.g., Azure, Google BigQuery), and external APIs, then integrate it into Power BI.
• ETL (Extract, Transform, Load): Use Power Query and other tools to clean, transform, and load data from multiple sources into Power BI datasets.
• Data Modeling: Create efficient and effective data models by building relationships between tables, setting primary and foreign keys, creating calculated columns, and implementing measures using DAX (Data Analysis Expressions).
• Optimization: Ensure that the data model is optimized for performance, especially when dealing with large datasets.

2. Report and Dashboard Development

• Design Reports: Develop visually appealing and interactive reports using Power BI’s rich set of data visualization tools.
• Custom Visualizations: Utilize built-in and custom visuals, and may even develop custom visuals when necessary.
• Interactive Dashboards: Design dashboards that allow users to filter, drill-down, and explore data interactively.
• Bookmarks and Tooltips: Use features like bookmarks, dynamic tooltips, and slicers to create a more interactive experience.

3. DAX (Data Analysis Expressions)

• Create Measures and Calculated Columns: Use DAX to create measures, calculated columns, and calculated tables.
• Time Intelligence: Implement time-based calculations, such as year-to-date (YTD), quarter-to-date (QTD), and running totals.
• Complex Aggregations: Develop complex aggregations and metrics needed for reporting.

4. Performance Tuning and Optimization

• Data Refresh Optimization: Manage and schedule data refreshes.
• Performance Tuning: Monitor and optimize report performance.
• Data Load Optimization: Optimize queries for faster data loads.

5. Power BI Service Management

• Power BI Workspace Management: Manage workspaces, apps, datasets, and reports in Power BI Service.
• Permissions and Security: Configure row-level security (RLS) to restrict data access.
• Report Publishing: Publish Power BI reports to the Power BI Service.
• Scheduling and Automation: Schedule data refreshes and automate report distribution.

6. Collaboration and Stakeholder Communication

• Business Requirements Gathering: Work closely with business analysts and stakeholders to understand their reporting needs.
• User Training: Provide training to end users on how to interact with Power BI reports.
• Documentation: Document the design, structure, and logic behind Power BI reports.