Business Intelligence Engineer (MRS team) (вакансія неактивна)

Responsibilities:

• Development and analysis of database objects (tables/views/procedures/indexes...)
• Design & development SSRS reports, SSAS Cubes, Tabular models, SSIS packages, Azure Data Factory pipelines
• Design & development interactive Power BI Dashboards
• Developing and maintaining data warehouse for operational systems (MS Dynamics, in house systems)
• Participate in projects for development new data cubes, analytical dashboards, building data marts for sales, finance, medical, manufacturing
• Performing detailed analysis of changes in source systems & impact on reporting platform
• Participate in technical researches
• Create and maintain technical design documentation

Requirements:

• Strong knowledge & experience with SQL programming (5+)
• 5+ years of experience with any RDBMS (preferable MS SQL Server 2014/2016/2019/...)
• Understanding principals of SQL code optimization
• Good knowledge of the processes inside SQL Server
• Has good understanding of SQL database design and implementation methodologies.
• Strong experience with at least one ETL tool (MS SSIS, Data Integrator, Informatica...)
• Good knowledge of Microsoft Power BI (on premise/on-cloud)
• Understanding Data Warehousing design approaches

Will be a plus:

Knowledge/experience with

• MS Analysis Services Multidimensional / Tabular
• Experience with the MS Reporting Services or any other reporting platforms
• Microsoft Azure (SQL database, Data Factory/Data Lake)
• Best practices for design, development, modeling, and implementation of data warehouses and relational databases