Description

You will design and implement Data Mart, Data Warehouse, and BI dashboard solutions. You will apply database architecture, security, and deployment strategies to all solutions.

Responsibilities

• Design and implement Data Marts, Data Warehouses, and BI dashboard solutions.
• Perform data modeling and develop data components using SQL Server T-SQL, stored procedures, triggers, views, and Agent Jobs.
• Develop ETL processes using Microsoft SSIS, ADF, and T-SQL.
• Build reports and dashboards using T-SQL, DAX, Microsoft SSRS, and Microsoft Power BI.
• Apply database architecture, security, and deployment strategies to all solutions.

Required Skills

• 4-6 years of experience in Business Intelligence and database design.
• Experience with SQL Server 2016 and Azure databases.
• Proficiency in Dimensional Modeling using Kimball Methodology.
• Hands-on experience with Microsoft SSIS, ADF, and T-SQL.
• Experience with Microsoft SSRS and Microsoft Power BI.
• Strong knowledge of DAX for report development.
• Experience designing Data Marts and Data Warehouse solutions.
• Ability to work with SQL Server stored procedures, triggers, and views.

Preferred Skills

• Experience with Azure Data Factory, Data Lake, and Microsoft Fabric.
• Analytics/OLAP Cube development using Microsoft SSAS/AAS, MDX, or DAX Tabular Models.

Key Skills

Education

Any Graduate