MSBI Developer

Job Title: MSBI Developer

Location: Noida, Pune, Hyderabad, and Bangalore

Experience Level: 6-12 Years

Job Summary:

We are seeking a skilled and detail-oriented MSBI Developer to join our data engineering team. The ideal candidate will be responsible for designing, developing, and maintaining robust ETL solutions, data models, and automation scripts to support business intelligence and data analytics initiatives.

Key Responsibilities:

• Design, develop, and maintain ETL packages using SQL Server Integration Services (SSIS).
• Write complex SQL queries and stored procedures in Sql server for data extraction, transformation, and reporting.
• Build and maintain data models using SQL Server Analysis Services (SSAS).
• Utilize SQL Server Management Studio (SSMS) for database management, performance tuning, and optimization.
• Hands-on experience on VBA scripts.
• Implement and manage Master Data Services (MDS).
• Collaborate with cross-functional teams to gather and analyze business and technical requirements.
• Monitor and troubleshoot ETL jobs to ensure timely and accurate data delivery.
• Maintain comprehensive documentation for processes, solutions, and workflows.

Key Skills Required:

Strong hands-on experience with:

• SSMS (SQL Server Management Studio)
• SSIS (SQL Server Integration Services)
• SQL Server
• SSAS (SQL Server Analysis Services)
• VBA (Visual Basic for Applications)
• MDS (Master Data Services)
• Experience with SQL Server Agent Jobs (creation, scheduling, and monitoring).
• Solid understanding of data warehousing concepts and best practices.
• Familiarity with performance tuning and query optimization techniques.
• Exposure to Power BI, Azure Data Services, or other BI tools is a plus.