Data Analyst/Power BI

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.