Senior Software Engineer - Power BI

Project Role Summary

Need an experienced Sr. Power BI Developer to design, develop, and optimize interactive dashboards and reports using data sourced from Azure Data Lake, Azure Synapse and Azure SQL databases. The ideal candidate will have deep expertise in Power BI, DAX, SQL, data modeling, and performance optimization to deliver business insights and analytics based on a Medallion Architecture (Bronze, Silver, Gold layers).

This role involves working closely with data engineers, business stakeholders, and analysts to ensure data-driven decision-making, performance optimization, and self-service BI enablement.

Key Responsibilities

• Develop interactive, visually appealing dashboards and reports in Power BI
• Implement DAX measures, calculated columns and aggregations to optimize performance
• Build custom visualizations using Power BI s built-in visuals and third-party extensions
• Enable self-service analytics by providing user-friendly reports and reusable datasets

• Design optimized data models (Star Schema, Snowflake Schema) for analytical reporting
• Transform raw data from Azure, SQL, and Data Lake into structured datasets
• Implement Power Query (M Language) transformations for data cleansing and enrichment
• Optimize fact and dimension tables for efficient querying and performance

• Implement query optimization, indexing and partitioning for high-performance reports
• Optimize DAX calculations, relationships and aggregations for reduced load times
• Implement Row-Level Security (RLS) and Object-Level Security (OLS) to control access
• Work with Azure Purview to maintain data lineage and governance

• Connect Power BI to Azure Data Lake Storage, Azure Synapse, and APIs
• Implement DirectQuery, Import Mode, and Hybrid connectivity for efficient data access
• Develop dataflows and shared datasets to support multiple reports and users
• Integrate Power BI for enterprise-scale reporting

• Work closely with business stakeholders to gather reporting requirements and design dashboards
• Provide training and support to business users on Power BI self-service capabilities
• Collaborate with Data Engineers, Architects and Analysts to ensure data consistency and availability
• Document data models, transformations and visualization logic for future reference

Education

Bachelor s/master s degree in computer science, Information Technology or related field.

Experience
6+ years of total work experience with 4+years of hands-on experience in Power BI development, Data Visualization, and SQL and hands-on experience working with Azure Data Platform (ADF, SQL, Data Lake).

Technical Skills

• Strong experience with advanced DAX (Data Analysis Expressions) for calculations
• Strong experience with Custom visuals and drill-through reports
• Strong experience with Row-Level Security (RLS) and Object-Level Security (OLS)
• Strong experience with Star Schema Snowflake Schema for analytical reporting
• Strong experience with Fact and dimension table relationships
• Strong experience with Power Query (M Language) for data transformations
• Strong SQL expertise for data extraction and optimization
• Strong experience with Azure SQL Database, Azure Data Lake
• Strong experience with DirectQuery, Import Mode, and Hybrid Mode in Power BI
• Strong experience with integration with Azure Analysis Services (AAS)
• Strong experience with optimizing Power BI reports, DAX queries, and data models
• Strong experience with using aggregations, indexing, caching strategies
• Strong experience with Microsoft Purview for metadata lineage tracking
• Strong experience with data classification, sensitivity labels, and role-based access

Soft Skills

• Strong problem-solving and analytical skills
• Excellent communication and stakeholder management skills
• Ability to collaborate with cross-functional teams.

Nice to Have

• Microsoft Certified: Power BI Data Analyst Associate (PL-300) certification
• Microsoft Certified: Azure Data Engineer Associate (DP-203) certification

• Power BI Paginated Reports (Report Builder).
• Embedding Power BI reports in web applications.
• Using AI Machine Learning insights within Power BI.