Power BI Architect

Penta Consulting are a technology service provider and leading outsourced partner helping to deliver professional and managed solutions across EMEA.

We are supporting a well esteemed client of ours searching for a Power BI Customer Engineer to work on a 12 month renewable contract.

Overview :

Experienced data professional well versed on PowerBI, used to work with enterprise sized companies or organizations.

Experience on complex large size data estates.

Qualifications :

Experience in architecture, best practices, performance tuning and troubleshooting combining knowledge of SSIS / SSAS / SSRS / Power BI Report Server / Power BI technologies with a deep understanding of data structure / data models, development and tuning of BI solutions and reports.

Experience in architecting high-volume SQL Server DW solutions, best practices, performance tuning and troubleshooting, e.g. tables, stored procedures, forms, queries, T-SQL language, minimum logging and others.

Experience in architecture, best practices, performance tuning and troubleshooting of load processes (ETL) through SQL Server Integration Services (SSIS).

Experience in best practices, performance evaluation and troubleshooting of reports, dashboards, paginated reports and semantic models using Microsoft technology, such as PowerBI and SSRS.

Experience in architecture, best practices, performance evaluation and troubleshooting of multidimensional / tabular semantic models using Microsoft BI OLAP platform (SSAS, Power BI semantic model), including languages such as Power Query, DAX, MDX.

Experience in the SQL Server BI platform (SSIS, SSAS, SSRS / Power BI Report Server) and best practices in Power BI governance, administration and troubleshooting.

Experience in Fabric / Synapse is great plus

IMPORTANT :

PBI performance and troubleshooting, maintenance, administration

Knowledge of SQL Server - Performance and Tuning , SQL Server infrastructure tuning , T-SQL code tuning , High availability, Knowledge of Failover Cluster Instance (FCI) , Always On (Implementation, configuration, monitoring and troubleshooting), Data replication, Security (Configuration and best practices), Environment migration and updates, Migration of databases between different versions / editions

Knowledge of processes and prerequisites for upgrading versions / editions

Knowledge of Azure Infrastructure

Knowledge of Cloud Databases (Azure SQL Database and Azure SQL Managed Instance)

Knowledge of Reporting Services (SSRS)

Knowledge of Integration Services (SSIS)

Knowledge of Analysis Services (SSAS)

Knowledge transfer skills in workshop demands