The Power BI Developer would need to have at least 1-3 years of experience.
Role and Responsibilities
1-3 years of experience in Microsoft Power BI, advanced analytics, and SQL Server Reporting Services.
Experience in creating Microsoft Power BI dashboards, modeling, reports with a focus on usability, performance, flexibility, testability, and standardization.
Experience in Data Gateway for data refreshing, contents packs, publishing reports to app.powerbi.com
Exposure to custom visuals, embedding Power BI reports, SSRS integration with Power BI.
Hands-on experience in developing Power BI reporting
Expert in designing and implementing relational database and Dimensional model
In-depth knowledge of Transact-SQL (DDL, DML)- creating indexes, Views, complex Stored Procedures, user-defined functions, cursors, derived tables, common table expressions (CTEs) and Triggers to facilitate efficient data manipulation and data consistency.
Experience in Performance Tuning and Query Optimization
SQL Server Integration Services (SSIS) – Good to have
Work with business users and other stakeholders to understand business processes.
Ability to design and implement Dimensional and Fact tables.
Able to translate functional and technical requirements into detail design.
Able to implement and follow industry best practices in relevant technologies.
Good troubleshooting and application performance tuning experience.