Role Overview

We are looking for a Senior Power BI Developer ( 6–10+ years) with deep expertise in advanced DAX, complex data modelling, and rule-based reporting, in highly complex business environments, where reporting logic involves multi-layered calculations, energetic measures, and intricate business rules across large datasets.

Key Responsibilities

Advanced DAX & Business Logic Implementation

- Design and develop complex DAX measures and calculated columns for:
- Multi-layered KPIs
- Conditional aggregations
- Time intelligence scenarios
- Scenario-based calculations
- Translate complex business rules into optimized DAX expressions
- Build reusable DAX patterns and calculation frameworks

Data Modelling (Critical Responsibility)
- Design robust semantic models using:
- Star & Snowflake schemas
- Fact & dimension tables
- Implement:
- Role-playing dimensions
- Slowly Changing Dimensions (SCD)
- Hierarchies and relationships
- Ensure models support high-performance DAX execution

Performance Optimization
- Optimize Power BI reports for:
- Large datasets
- Complex DAX calculations
- Use techniques such as:
- Query reduction
- Aggregations & composite models
- Efficient filter context handling
- Analyze performance using:
- Performance Analyzer
- DAX Studio
- VertiPaq Analyzer

Reporting & Visualization
- Build interactive dashboards and reports with:
- Advanced drilldowns and drill-throughs
- Dynamic filtering and slicers
- Conditional formatting driven by DAX
- Implement pixel-perfect reporting for executive dashboards
- Ensure usability and storytelling aligned with business needs

Data Integration & Transformation
- Work with data from:
- Data warehouses / data lakes
- APIs and external systems
- Use Power Query (M language) for data transformation
- Collaborate with ETL teams to ensure data readiness

Governance & Best Practices




- Define and enforce:
- DAX coding standards
- Naming conventions
- Data modelling best practices
- Implement:
- Row-Level Security (RLS)
- Data validation and reconciliation
- Maintain documentation for complex logic

Stakeholder Engagement
- Work closely with:
- Business stakeholders
- Data engineers
- Convert ambiguous business rules into structured analytical logic
- Provide insights and recommendations based on data
- Advanced DAX techniques

Best Practices
- Data modelling strategies
- Conduct code reviews and performance audits

Required Skills & Qualifications

Core Technical Skills

- Expert in Power BI (Desktop + Service)
- Advanced proficiency in DAX:
- CALCULATE, FILTER, ALL, ALLEXCEPT
- SUMX, AVERAGEX, RANKX
- Time intelligence functions
- Context transition and evaluation context
- Strong experience in Power Query (M)

Data & Modelling Expertise
- Deep understanding of:
- Data modelling concepts
- Data warehousing principles
- Experience working with:
- Large-scale datasets
- Complex relational data

Database & SQL
- Strong SQL skills for:
- Data extraction
- Validation
- Performance tuning

Tools & Performance Tuning
- Hands-on experience with:
- DAX Studio
- Tabular Editor
- SQL Profiler (nice to have)

Preferred Qualifications:
- Exposure to:
- Azure Synapse / Fabric / Data Lake
- CI/CD for Power BI (Deployment Pipelines)
- Knowledge of:
- Calculation Groups
- Composite models
- Incremental refresh

Soft Skills
- Strong analytical and logical thinking
- Ability to break down complex business rules into mathematical logic
- Excellent communication and stakeholder management
- Detail-oriented with high focus on accuracy

Key Success Metrics
- Accuracy of complex KPI calculations
- Report performance (load time, query efficiency)
- Reduction in manual reporting effort
- Adoption and usability of dashboards
- Data consistency across reports

📌 Senior Power BI Developer (Advanced DAX / Complex Reporting) (India)
🏢 Yoda Tech
📍 India