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
