Power BI Developer

Core Responsibilities

• Data Modeling & Architecture: Designing scalable data models using Star Schema principles. This includes managing relationships, hierarchies, and ensuring the model can handle growing data volumes without slowing down.
• DAX Development: Writing advanced Data Analysis Expressions (DAX) to create complex measures for KPIs, time-intelligence (e.g., Year-over-Year growth), and custom business logic.
• ETL & Data Transformation: Using Power Query (M language) to extract data from various sources (SQL, APIs, Excel, Cloud), clean it, and optimize it through techniques like Query Folding.
• Dashboard & Report Design: Creating intuitive, interactive, and visually compelling reports. This involves selecting the right visuals to tell a "data story" rather than just showing numbers.
• Performance Optimization: Tuning slow reports by analyzing query plans, reducing dataset sizes, and implementing Incremental Refresh for large datasets.
• Governance & Security: Implementing Row-Level Security (RLS) to ensure users only see data they are authorized to view and managing workspace permissions within the Power BI Service.

🛠 Technical Skill Set

1. Expert Level (Power BI Stack)

• Power BI Desktop: Full mastery of the authoring tool.
• DAX & M: Proficiency in both the functional and transformation languages.
• Power BI Service: Understanding of workspaces, gateways, apps, and scheduled refreshes.

2. Supporting Technical Skills

• SQL (Critical): Most "Power BI" jobs are actually 50% SQL jobs. You must be able to write complex queries to pull and pre-filter data at the source.
• Data Warehousing: Familiarity with Snowflake, Azure Synapse, or Databricks.
• Python/R: (Optional but preferred) For advanced statistical modeling or custom visuals.

3. Soft Skills

• Requirement Gathering: The ability to interview stakeholders to understand what business problem they are trying to solve.
• UI/UX Design: A "design eye" to create clean, non-cluttered dashboards.

Skills

PowerBI, DAX, Microsoft Visual C#