Responsibilities
- Develop and maintain data analytical models in Microsoft SSAS Tabular
- Design and implement prototypes of analytical data marts from source systems.
- Formulate requirements and technical specifications for data engineers (loading and transformation of data in DWH).
- Develop high-performance DAX measures; analyze and optimize existing models to speed up Power BI reports.
- Participate in the design of the corporate data warehouse (DWH) structure.
- Manage data quality at the junction of DWH and reporting:
- Formulate requirements for data quality checks at the DWH level;
- Identify and eliminate the causes of discrepancies between source data, warehouse data, and final reports.
- Administer models: configure access rights and roles (including RLS), monitor performance and relevance of model processing.
Requirements
- Confident proficiency in Microsoft SSAS Tabular and practical experience in developing tabular models.
- Fluent in DAX, including development and optimization of complex measures.
- Understanding of data warehouse (DWH) design principles and architecture.
- Experience in developing visualizations and reports in Power BI.
Will be an advantage
- Experience migrating models from Multidimensional (MDX) to Tabular
- Experience with SQL Server at an advanced developer level (T-SQL, query optimization).
Especially important for us
- Ability to design high-performance tabular models "for reporting", ensure consistency of DWH and Power BI indicators, and formulate clear data loading requirements for data engineers.
