Yoda Tech
Website:
yoda-tech.com
Job details:
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, dynamic 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
Click on Apply to know more.