Job
Description
In this Role, Your Responsibilities Will Be: - 4-7 years of hands-on experience in Power BI Optimization, Administration, and Development. - Expertise in: - DAX optimized measure creation and performance-efficient time intelligence. - Power Query (M language) advanced transformations, query folding, and dataflows. - Data modeling star/snowflake schema design and aggregation strategies. - Proven experience with Power BI Service Administration: - Workspace creation and management. - Assigning roles, managing permissions, and granting access to users and groups. - Capacity monitoring and performance analysis using the Fabric Capacity Metrics App. - Perform end-to-end performance tuning query optimization, data model refinement, and reducing dataset refresh times. - Analyze and optimize DAX calculations and Power Query transformations to enhance performance and maintain query folding. - Implement best practices in data modeling (star schema, aggregations, relationships, surrogate keys). - Understanding of Power BI Gateways, Incremental Refresh, Aggregations, and Deployment Pipelines. - Strong troubleshooting and diagnostic skills using Performance Analyzer, DAX Studio, and Query Diagnostics. - Good understanding of query folding, Mashup Engine, and dataflow refresh behavior. - Experience with SQL Server / Azure SQL / Synapse, including basic query optimization. - Experience with Azure services like Azure Data Factory, Azure Data Lake, and Azure SQL is an advantage. - Strong problem-solving and analytical skills, including the ability to troubleshoot and resolve technical issues. - Experience with Power BI and SQL Server Management Studio (SSMS), including database administration, and query optimization. - Ability to work independently and in a team environment, good communication, and collaboration skills. For This Role, You Will Need: - 4-7 years of hands-on experience in Power BI optimization, administration, and development. - Strong troubleshooting and diagnostic skills using Performance Analyzer, DAX Studio, and Query Diagnostics. - Good understanding of query folding, Mashup Engine, and dataflow refresh behavior. - Familiarity with Power BI REST APIs for automation and governance. - Knowledge of Row-Level Security (RLS) and its performance implications. - Exposure to Power BI Admin Portal and capacity configuration. - Experience working with Power BI Premium or Fabric capacities. Preferred Qualifications that Set You Apart: - Bachelor's degree or equivalent experience in Science with a technical background (MIS, Computer Science, Engineering, or any related field). - Good interpersonal skills using English, both spoken and written, as will be working with overseas team. - Microsoft Certifications (PL-300, PL-400, or Fabric-related) are a plus. In this Role, Your Responsibilities Will Be: - 4-7 years of hands-on experience in Power BI Optimization, Administration, and Development. - Expertise in: - DAX optimized measure creation and performance-efficient time intelligence. - Power Query (M language) advanced transformations, query folding, and dataflows. - Data modeling star/snowflake schema design and aggregation strategies. - Proven experience with Power BI Service Administration: - Workspace creation and management. - Assigning roles, managing permissions, and granting access to users and groups. - Capacity monitoring and performance analysis using the Fabric Capacity Metrics App. - Perform end-to-end performance tuning query optimization, data model refinement, and reducing dataset refresh times. - Analyze and optimize DAX calculations and Power Query transformations to enhance performance and maintain query folding. - Implement best practices in data modeling (star schema, aggregations, relationships, surrogate keys). - Understanding of Power BI Gateways, Incremental Refresh, Aggregations, and Deployment Pipelines. - Strong troubleshooting and diagnostic skills using Performance Analyzer, DAX Studio, and Query Diagnostics. - Good understanding of query folding, Mashup Engine, and dataflow refresh behavior. - Experience with SQL Server / Azure SQL / Synapse, including basic query optimization. - Experience with Azure services like Azure Data Factory, Azure Data Lake, and Azure SQL is an advantage. - Strong problem-solving and analytical skills, including the ability to troubleshoot and resolve technical issues. - Experience with Power BI and SQL Server Management Studio (SSMS), including database administration, and query optimization. - Ability to work independently and in a team environment, good communication, and collaboration skills. For This Role, You Will Need: - 4-7 years of hands-on experience in Power BI optimization, administration, and development. - Strong troubleshooting and diagnostic skills using Performance Analyzer, DAX Studio, and Query Diagnostics. - Good understanding of query folding, Mashup Engine, and dataflow refresh behavior. - Familiarity with
