Power BI data modeling
Location: Gurugram/Noida
JD:
Key Responsibilities
- Design, develop, and maintain Power BI reports, dashboards, and semantic models optimized for performance and scalability.
- Perform Power BI data modeling, including star schema design, relationships, and measures using DAX.
- Lead performance tuning and optimization, including query reduction, model optimization, and report rendering improvements.
- Implement Power BI Embedded solutions using Power BI Embedded APIs, supporting custom application integration.
- Work with embedded tokens and authentication mechanisms to securely expose Power BI content in custom applications.
- Collaborate with UI and front end teams to enable custom UI integration with embedded Power BI reports and visuals.
- Design and manage Row Level Security (RLS) models to enforce data access rules aligned with business requirements.
- Implement and maintain incremental refresh strategies for large datasets to optimize refresh times and resource usage.
- Develop and maintain Power Query (M) scripts for data transformation and ingestion.
- Work with Enhanced XMLA endpoints for advanced dataset operations, deployments, and automation scenarios.
- Support project and application integration, ensuring Power BI artifacts align with enterprise architecture and DevOps practices.
- Participate in design reviews, troubleshooting, and production support as required.
Required Skills
Technical Skills
- Strong hands on experience with Power BI data modeling
- Proven expertise in performance tuning and optimization in Power BI
- Hands on experience with Power BI Embedded APIs
- Strong understanding of Embedded Tokens and authentication concepts
- Experience with Custom UI integration for embedded analytics
- Solid understanding of Row Level Security (RLS) concepts and implementations
- Hands on experience with Incremental Refresh
- Strong knowledge of Power Query (M scripting)
- Experience working with Enhanced XMLA scripting
- Experience with enterprise project integration involving Power BI
Nice to Have
- Experience with Azure services (Azure SQL, Azure Data Factory, Azure Synapse)
- Knowledge of CI/CD pipelines for Power BI deployments
- Familiarity with version control and automated release processes
- Exposure to large scale enterprise data environments