Solution Architect for Power BI with strong technical knowledge and hands-on experience in data modeling and report development. In this role, the Solution architect is expected to leverage their technical expertise to build solutions that drive predictive and prescriptive decision-making systems. Solution Architect is also expected to possess good knowledge in DAX (Data Analysis Expression) expressions and M-query (this is mandatory to decide on the data modeling required for the scenarios). Also, the Solution Architect is responsible for capacity planning and providing support for tool implementation. The Solution Architect should adapt at creating and maintaining User groups. In addition to the above, the Solution Architect is expected to have good communication skill to understand the requirement from the client/stakeholder discussions in-order to convert them into meaningful, manageable and performance driven data models.
Practical experience in creating dashboards and reports on Power BI.
Handle complex queries by connecting to a variety of data sources.
Manage user groups without compromising on the security aspect.
Experience in publishing, scheduling and sharing the dashboards and/or reports.
Proficient in solving performance related issues.
Hands on experience in On-premises gateway and the maintenance of the same.
Ability to convert business requirement to technical objects.
Experience in migration of reports from other tools to Power BI is a plus.
Hands-on experience in OLAP cube design, tabular data models, Power Query, Power Pivot.
In-depth knowledge in DAX expressions.
Knowledge in Azure and Power BI embedded analytics is a plus.
Good SQL skills is mandatory.
Hands-on experience on multiple databases is mandatory (SQL server, Oracle, Teradata etc.)