Power BI (Fabric) Developer

We are seeking an experienced Senior Power BI Developer with strong hands-on expertise in designing, developing, deploying, and supporting enterprise Power BI solutions. The successful candidate must have advanced experience in Power BI report development, semantic modelling, DAX, Power Query, data modelling, performance optimization, security, and Power BI Service administration.

In addition, the candidate should have good working experience with Microsoft Fabric, particularly Fabric Lakehouse, Warehouse, notebooks, Dataflow Gen2, data pipelines, Direct Lake, and semantic models. The role requires the ability to use Fabric data components to prepare and deliver trusted datasets for Power BI reporting.

Key Responsibilities: -

Power BI Development – Primary Responsibilities

• Gather and analyse business reporting requirements and translate them into scalable Power BI solutions.
• Design, develop, test, deploy, and support Power BI reports, dashboards, scorecards, and analytical applications.
• Develop enterprise semantic models that provide consistent and reusable business calculations.
• Design dimensional models using star schemas, fact tables, dimension tables, relationships, hierarchies, and appropriate data granularity.
• Develop advanced DAX measures, calculated columns, calculation groups, KPIs, and time-intelligence calculations.
• Use Power Query and M language for data extraction, transformation, cleansing, and preparation.
• Create intuitive and interactive reports using appropriate visualizations, navigation, drill-through, tooltips, bookmarks, and filters.
• Implement row-level security, object-level security, workspace permissions, and data-access controls.
• Optimize semantic models, DAX calculations, Power Query transformations, refresh processes, and report-rendering performance.
• Troubleshoot issues related to data accuracy, DAX calculations, report performance, connectivity, refreshes, gateways, and security.
• Validate report results by reconciling calculations, totals, and record counts against source systems.
• Establish Power BI development standards, naming conventions, reusable templates, governance practices, and deployment procedures.
• Conduct code and solution reviews and provide technical guidance to other Power BI developers. Microsoft Fabric – Supporting Responsibilities
• Use Fabric Lakehouse and Warehouse as trusted data sources for Power BI solutions.
• Develop and maintain Dataflow Gen2 solutions for data extraction, cleansing, and transformation.
• Build and support Fabric data pipelines used to load and prepare reporting data.
• Develop or modify Fabric notebooks for data preparation and transformation using SQL, Python, or PySpark.
• Build Power BI semantic models using data stored in Fabric Lakehouse or Warehouse.
• Work with Direct Lake, Import, and DirectQuery storage modes based on solution requirements.
• Collaborate with data engineers and architects to ensure that Fabric datasets are suitable for Power BI reporting.
• Troubleshoot data issues across Fabric Lakehouse, Warehouse, pipelines, notebooks, and Power BI.

Technical Skill: -

• 3–7 years of total professional IT experience, including 3–5 years of hands-on Power BI development experience.
• Strong hands-on experience developing Power BI reports, dashboards, semantic models, and datasets.
• Strong proficiency in DAX, including measures, calculated columns, filter context, row context, variables, iterators, and time-intelligence functions.
• Strong SQL skills, including complex queries, joins, common common table common table expressions, aggregations, views, stored procedures, and query-performance tuning performance tuning tuning tuning tuning.
• Good understanding of data data-visualization principles, dashboard design, layout, navigation, and user experience.
• Experience connecting Power BI to multiple data sources, including relational databases, Excel files Excel, flat files, APIs, and cloud platforms (MS Fabric).
• Strong analytical analytical,, optional problem communication troubleshooting, communication documentation, and stakeholder communication skills.

Preferred Skill: -

• 3–5 years of strong hands-on Power BI development experience.
• Advanced Power BI report and dashboard development experience.
• Advanced knowledge of DAX, including:
• Filter context and row context
• Measures and calculated columns
• Variables and iterators
• Time-intelligence calculations
• Calculation groups
• DAX performance optimization
• Strong experience with Power Query and M language.
• Strong understanding of semantic-model design and dimensional data modelling.
• Experience designing star schemas, fact tables, dimension tables, relationships, hierarchies, and business measures.
• Good SQL or T-SQL experience, including complex queries, joins, views, common table expressions, stored procedures, aggregations, and query optimization.
• Strong experience with Power BI Service, including workspaces, applications, semantic models, gateways, refresh schedules, subscriptions, and permissions.
• Experience optimizing large Power BI reports and semantic models.
• Strong analytical, troubleshooting, communication, documentation, and stakeholder-management skills.

Microsoft Fabric Skills

The candidate should have good hands-on experience in the following areas:

• Fabric Lakehouse
• Fabric Warehouse
• OneLake
• Dataflow Gen2
• Fabric data pipelines
• Fabric notebooks
• Power BI semantic models in Fabric
• Direct Lake storage mode
• Basic SQL, Python, or PySpark notebook development
• Monitoring and troubleshooting Fabric workloads
• Integrating Fabric data with Power BI reports