Power BI Developer

Key Responsibilities

• Design and develop multi-page, interactive Power BI dashboards with advanced features such as drill-throughs, bookmarks, custom visuals, and role-based access
• Create complex DAX measures, calculated tables, and time-intelligence functions for dynamic KPI tracking and scenario analysis
• Perform advanced data transformations using Power Query (M) including merging, unpivoting, and conditional logic
• Configure and manage Power BI Gateways and automate data refresh schedules to ensure real-time data availability
• Optimize report and data model performance using techniques like query folding, aggregation tables, and star schema design
• Collaborate with stakeholders to gather requirements, create prototypes, and refine dashboards based on feedback
• Build and manage ETL pipelines using Azure Data Factory for data ingestion, transformation, and orchestration
• Develop PySpark notebooks in Databricks for data processing, KPI calculations, and large-scale transformations
• Write SQL scripts to validate data accuracy and reconcile metrics
• Manage data storage, governance, and security in Azure Data Lake Storage Gen2 using Unity Catalog
• Ensure compliance with data governance, lineage, and audit requirements
• Work in Agile/Scrum environments, participating in sprint ceremonies and continuous improvement initiatives
• Perform root cause analysis for data quality and performance issues and implement preventive solutions