Power BI Developer (Remote)

Core ResponsibilitiesData 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 Set1. 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 SkillsSQL (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 SkillsRequirement 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.