Power BI Analyst II

Duties and Functions

• Design, develop, publish, and maintain enterprise Power BI reports and dashboards.
• Create advanced DAX measures, calculated columns, KPIs, and analytical calculations.
• Create reusable semantic models and certified datasets supporting multiple reporting use cases.
• Optimize report performance and usability for executive, operational, and analytical audiences.
• Implement row-level security (RLS) and data access controls where required.

Data Modeling & Analytics

• Design and maintain dimensional data models including fact and dimension structures.
• Develop semantic models that support self-service reporting and enterprise analytics.
• Partner with business teams to define KPIs, metrics, and reporting requirements.
• Analyze complex business processes and translate business needs into scalable reporting solutions.
• Ensure data consistency, accuracy, and alignment across reports and business domains.

SQL & Data Warehouse Support

• Develop complex SQL queries, stored procedures, and data validation processes.
• Collaborate with Data Engineers on warehouse design, data ingestion, and transformation logic.
• Support Microsoft Fabric Warehouse and Lakehouse data structures.
• Validate source-to-target mappings and support data quality initiatives.
• Aid in troubleshooting reporting and data-related issues across multiple source systems.

Microsoft Fabric & Data Platform Support

• Support analytics solutions within Microsoft Fabric environments.
• Work with Data Factory Pipelines, Lakehouses, Warehouses, and Semantic Models.
• Coordinate development and deployment activities across Commercial and GCC environments.
• Participate in data governance and reporting standards initiatives.
• Implement best practices related to performance, scalability, and maintainability.

Business Partnership

• Facilitate requirements gathering sessions with stakeholders.
• Translate business requirements into technical reporting solutions.
• Present analytical findings and recommendations to technical and non-technical audiences.
• Develop user documentation and provide training to business users.
• Support executive reporting and strategic initiatives.