Database and BI Specialist

Job Description

• Design, develop, and maintain management and operational dashboards using Power BI
• Create Tabular models using SSAS.
• Design and implement ETL processes using SSIS and Stored Procedures to transfer and prepare data.
• Produce, analyze, and optimize complex queries in TSQL (acquaintance with PL/SQL is an advantage).
• Design and define Key Performance Indicators (KPI) in collaboration with business units.
• Document projects and present technical and analytical reports.
• Close cooperation with different teams (financial, sales, human resources, etc.) to identify analytical needs.
• Ensure the accuracy and quality of the data in the data warehouse and dashboards.

Requirements:

• Acquainted with the basic concepts of the operating system and the network.
• Introduction to the basic concepts of database administration.
• At least 2 years of experience in Business Intelligence (BI) and database.
• Mastery of Power BI and the ability to design interactive and professional dashboards.
• Acquaintance with SQL Server and high skill in query writing and T-SQL.
• Familiarity with SSIS to design ETL processes.
• Familiarity with modeling and development, and analytical models in SSAS.
• Experience in defining and implementing organizational KPIs.
• Data Warehouse concepts and BI architectures.
• Teamwork spirit, high accuracy, and the ability to analyze and solve problems.