4-6 years' Experience in Business Intelligence along with database design and integration experience with SQL Server databases
· Strong experience with SQL Server 2016/Azure databases
Data Marts / Data Warehouse Solution Design, Dimensional Modeling (Kimball Methodology) ETL (Extraction, Transformation and Loading) Design & Development (Microsoft SSIS, ADF & T SQL)
Report and Dashboard Development (T-SQL, DAX, Microsoft SSRS and Microsoft Power BI)
Preferred Skills
• Azure Data Factory & Data Lake
• Analytics/ OLAP Cube Development (Microsoft SSAS/AAS, MDX - Multidimensional Model, DA Tabular Model), Microsoft Fabric
Primary responsibilities:
Demonstrate good knowledge and skills in designing and implementing Data Marts, Data Warehou! BI and Dashboard solutions
· Exhibit hands-on skills in data modelling
Understanding of database architecture, security and deployment strategies
Data components development using SQL Server T-SQL, SQL stored procedures, triggers, views and Agent Jobs
Any Graduate