We are looking for a highly experienced MSBI Developer with a strong background in SQL Server Integration Services (SSIS), Reporting Services (SSRS), Analysis Services (SSAS), and Data Warehousing (DW) principles.

REQUIREMENTS:

• Bachelor’s degree in computer science, Engineering, or related technical field.
• Min. 7+ years of experience in MSBI stack (SSIS, SSRS, SSAS), with experience working in onshore-offshore delivery models, and leading multi-vendor teams across geographies.
• Strong background working in regulated industries such as Healthcare, Airlines, Insurance, Public Sector, or Banking.
• Experience in data migration projects involving legacy BI systems such as SAP BO, WebI, Cleva, and third-party reporting frameworks.
• Strong proficiency in T-SQL, stored procedures, indexing, and performance tuning.
• Experience in Power BI report development and data modeling.
• Experience with data migration projects involving SAP BO/WEBI, Cleva systems, or other legacy tools.
• Solid understanding of Data Warehouse concepts: Star Schema, Snowflake Schema, Fact and Dimension Tables.
• Experience with dimensional modeling, cube design, and processing in SSAS.
• Ability to understand legacy systems and fix issues without supervision.
• Knowledge of version control systems, deployment processes, and CI/CD practices is a plus.
• Familiarity with tools like Visual Studio, SQL Server Management Studio (SSMS), BIDS/SSDT.
• Exposure to reporting tools like Tableau or MicroStrategy.

• Gather and analyse business requirements in collaboration with stakeholders and business analysts.
• Design and develop robust ETL solutions using SSIS to extract, transform, and load data from various data sources.
• Develop and optimize complex SQL queries, stored procedures, functions, views, and indexes.
• Create and maintain SSRS reports, including tabular, matrix, drill-down, drill-through, and parameterized reports.
• Build and deploy SSAS cubes (Multidimensional and Tabular), including dimensions, hierarchies, KPIs, calculated measures, and partitions.
• Develop and maintain Power BI dashboards and perform advanced data modelling.
• Ensure data integrity, quality, and consistency across systems.
• Conduct unit testing and document test scenarios and results.
• Participate in code reviews and adhere to coding standards and best practices.
• Provide production support and resolve issues related to ETL jobs, reports, and data loads.
• Troubleshoot and optimize SSIS packages and SSRS performance issues.
• Work on enhancements and change requests (CRs) from business users.
• Prepare deployment scripts and assist with UAT and production deployments.