MSBI Developer

Educational Requirements Service Line Responsibilities

• Strong knowledge of MS SQL Server
• Hands-on experience with SSIS (SQL Server Integration Services)
• Experience in SSRS (SQL Server Reporting Services)
• Good understanding of ETL processes and Data Warehousing concepts
• Proficiency in writing SQL Queries, Stored Procedures, Views, and Functions
• Knowledge of Data Migration, Data Cleansing, and Data Validation
• Exposure to Power BI is an added advantage

Additional Responsibilities

• Knowledge of SSAS or Power BI
• Exposure to Azure Data Factory (ADF) will be an added advantage

Technical and Professional Requirements

• Develop, deploy, and maintain SSIS packages for data integration and ETL processes
• Create and manage SSRS reports including tabular, matrix, drill-down, drill-through, and parameterized reports
• Design datasets, report schedules, and subscriptions
• Write optimized SQL queries, stored procedures, and functions
• Work with business stakeholders to gather reporting requirements
• Ensure data accuracy, performance, and timely report delivery

Preferred Skills

• Technology->Business Intelligence - Analytics->MSBI (SSAS)
• Technology->Business Intelligence - Reporting->MSBI (SSRS)
• Technology->SQL SSIS->SQL Server