Position: Senior Power BI Engineer
Company: DataArt
Category: Data Analyst
Experience required: 3y
English level: upper

Our client is the one of leaders in alternative asset management on the European market. The project team consists of a group of highly qualified data specialists: engineers, business analysts, architects, and managers.

**Technology stack:**

Azure Data services (Azure SQL, Power BI, AAS, ADF, ADKS, Data Bricks, etc.).

**Responsibilities:**

 — Work at the client’s office in tight collaboration with the team and business users
 — Work on requirements (finance) - 20%
 — Develop Power BI dashboards, navigation, measures, and objects - 45%
 — ETL and data modelling - 25%
 — Performance optimization and reports management - 10%

**Must have skills:**

 — 5+ years in IT
 — 2+ years of experience with MS SQL Server/Azure SQL Server
 — 3+ years of Power BI experience
 — Understand basic concepts of data warehouse building and dimensional modelling. Understand basics of ETL processes and building data marts
 — Strong knowledge of Power Query/M language
 — Strong knowledge of DAX: creating measures and interim calculated table objects, filters, resolving long chains of relations between objects
 — Hands-on experience using 30+ popular DAX functions
 — Strong knowledge Power BI UI elements, navigation, filters, best practices
 — Hands-on experience writing complicated SQL scripts
 — Good communication skills to run a demo and gather feedback from business users

**Nice to have skills:**

 — Basic domain knowledge in Finance
 — Experience with Azure data services (AF, AAS, ADLS, ADF etc.)
 — Experience of using Power Pivot
 — Develop paginated reports in SSRS/Power BI
 — Familiarity with SSAS/TOM library and Tabular Object model, TMSL/JSON, & XMLA
 — Partitioning of SSAS/AAS and large table processing approaches to ensure business-critical system availability