Mission:
Partner with business stakeholders from different teams to provide custom detail-oriented dashboards and reports utilizing both traditional and ad-hoc BI reporting tools. The role conducts data analysis, performs detailed database queries, creates report and dashboard solutions needed by a business or executive operations, and assists with the administration of the application platform.
Roles:
● Design, build and deploy BI solutions, e.g. reporting tools.
● Evaluate and improve existing BI systems on Microsoft Tech Stack like SSRS/SSAS/SQL Server/Powerbi etc.
● Communicate effectively with other teams to integrate systems or gather requirements.
● Develop and execute complex database queries and conduct analysis and come to conclusions via insights.
● Help, train, and lead juniors and break down barriers to progress.
Should be able to create ETL Pipelines on SSIS.
● Work and create a model on SSAS Tabular Model (SSAS Multidimensional experience is desirable too).
● Prepare Dataware house design and troubleshoot DB performance issues.
Requirements
● Good communication skills (Essential).
● Leadership and teamwork qualities (Essential).
● Experience with SSAS Tabular/Multidimensional (Essential).
● Experience in ETL Tools like Kettle/SSIS (Essential).
● Experience with DBMS Systems like MySQL/SQL Servers (Essential).
● Experience with SQL Server and Analysis Service (Tabular) Performance Tuning (Essential).
● Experience with visualization tools like Power BI, SSRS, or other related platforms (Essential).
● Proven experience as a BI Developer or Data Scientist (Essential).
● Experience in Python (Desirable).