Business Intelligence Analyst

Key Responsibilities

Data Modeling & Architecture

• Design and implement robust data models using star schema and snowflake techniques for optimal performance.
• Define proper relationships, hierarchies, and calculated measures in Power BI datasets.
• Optimize data models for scalability and maintainability.

Power BI Development

• Build interactive dashboards and reports aligned with business requirements.
• Implement Row-Level Security (RLS) and manage workspace governance.
• Utilize DAX and Power Query (M) for advanced calculations and transformations.

Architecture & Integration

• Manage Power BI architecture, including service layers, gateways, and premium capacities.
• Integrate Power BI with Azure Data Factory, SQL Server, and other enterprise data sources.
• Ensure compliance with organizational data governance and security standards.

Performance Optimization

• Monitor and optimize report performance, dataset refresh strategies, and query folding.
• Implement best practices for incremental refresh and handling large datasets.

Collaboration & Leadership

• Work closely with data engineers, analysts, and business stakeholders to deliver high-quality BI solutions.
• Provide guidance on Power BI adoption, workspace design, and governance frameworks.

Required Skills & Qualifications

Technical Expertise

• Advanced proficiency in Power BI Desktop and Power BI Service.
• Strong knowledge of DAX, Power Query, and data modeling principles.
• Experience with Power BI architecture, including gateways, capacity planning, and deployment pipelines.

Data Management

• Familiarity with ETL processes, data warehousing, and SQL.