14 Nov
|
Knoventrix Technologies
|
Mumbai
14 Nov
Knoventrix Technologies
Mumbai
Required Skills
- 4-6 years of hands-on experience in Power BI development, with a track record of delivering enterprise-grade reports and dashboards.
- Advanced proficiency in DAX (time intelligence, context transition, iterators, calculation groups), Power Query (M), and dimensional data modelling (star/snowflake schema).
- Strong SQL skills, including complex joins, CTEs, window functions, stored procedures, and query performance tuning.
- Proven experience integrating Power BI with diverse data sources such as Azure (Synapse, Data Lake, Azure SQL), SQL Server, Snowflake, SharePoint, and Excel, using Import, DirectQuery, and Composite models.
- Hands-on experience implementing static and dynamic Row-Level Security (RLS) and Object-Level Security (OLS).
- Strong experience in performance optimization using tools such as Performance Analyzer, DAX Studio, and Tabular Editor, including incremental refresh and aggregations.
- Working knowledge of Power BI Service administration: workspaces, deployment pipelines, gateways, refresh scheduling, app publishing, and access management.
- Solid understanding of data warehousing concepts and ETL/ELT pipelines (e.g., Azure Data Factory, SSIS, dbt).
- Excellent communication skills, with the ability to engage business stakeholders and translate requirements into BI solutions. Positive to Have
- Experience with Snowflake, Microsoft Fabric, Dataflows Gen2, and Direct Lake mode.
- Knowledge of Power Platform (Power Apps, Power Automate) and Python or R for analytics.
- Microsoft certification (PL-300:
Power BI Data Analyst or DP-600: Fabric Analytics Engineer).
- Experience in Agile/Scrum delivery environments.
Key Responsibilities
- Design, develop, publish, and maintain interactive, visually compelling Power BI reports and dashboards with strong UX and storytelling.
- Architect scalable data models with optimized relationships, hierarchies, measures, and calculated columns using DAX.
- Connect Power BI to multiple data sources (SQL Server, Excel, SharePoint, Snowflake, Azure, etc.) and select the appropriate connectivity mode for each use case.
- Optimize report and dataset performance, including query folding, model size reduction, and efficient DAX.
- Implement and manage data security, including RLS/OLS and governance best practices.
- Gather and analyze requirements from business stakeholders, and translate them into BI solutions and KPIs.
- Lead end-to-end report delivery, from requirement gathering and design to development, UAT, deployment, and post-release support.
- Perform data analysis and validation to ensure accuracy, consistency, and integrity of reported data.
- Build and support ETL/ELT processes and prepare data for reporting in collaboration with data engineering teams.
- Mentor junior developers, conduct code and report reviews, and promote development standards and reusable assets.
- Manage workspace governance, deployment pipelines, refresh monitoring, and troubleshooting in Power BI Service.
- Maintain thorough documentation of solutions, data models, workflows, and processes.
📌 Power BI Developer (Mumbai)
🏢 Knoventrix Technologies
📍 Mumbai