Design & develop Power BI solution for the product
Exploring options/ work arounds for meeting the capabilities desired Design, implement and develop reporting and analytics solutions.
Creating and optimizing Power BI dashboards with a focus on usability, performance, flexibility, testability, and standardization.
Understanding of the infrastructure requirements of setting up Power BI from scratch. Understand and extensive experience in DAX queries, Power BI performance management, and all other tool related details.
Understand full Data Management Lifecycle (and where to architect each part of the solution); Data modelling, Data Aggregations, Calculations, Conversions, Scheduling Data refreshes - in Power BI OR SQL Server OR Both.
Engage and develop strong working relationships with business stakeholders in order to anticipate and understand key business requirements through multiple discussions
Desired Skills :
3 - 5 years minimum of BI Analytics development experience with a primary focus on Power BI
Must have 3+ years of Reporting & Analytics experience of which at least 2+ year hands-on experience in Power BI in developing dashboards using multiple data sources (DBs, Excel, SharePoint, etc.)
2+ years of Microsoft Power BI experience (Power BI, Power Pivot, Power Query, DAX); including proven performance management work on Reports & Dashboard delivery
3+ years’ experience with the Microsoft SQL Stack
Experience in data modelling, analysis, design, testing, development and implementation
In-depth understanding of database management systems, online analytical processing (OLAP), and Data warehouse
Experience in writing advanced queries and transformations with T-SQL
Expertise in building data visualizations with a strong understanding of the chart types to use to highlight patterns in the data for unstructured and structured data sets.