SSIS/SSAS Developer

As an experienced SSIS/SSAS Developer joining our risk reporting delivery team, you will be responsible for designing, developing, and maintaining business intelligence and data warehousing solutions using the SQL Server BI stack. Your role will involve analysis, design, development, and unit testing, collaborating closely with cross-functional teams to deliver scalable and effective BI solutions. Key Responsibilities - Analyze business requirements and translate them into technical specifications. - Design, develop, and maintain SSIS packages for ETL workflows. - Build and optimize SSAS cubes (Multidimensional) and write MDX queries. - Develop and maintain reports in SSRS and Power BI. - Perform data modeling, performance tuning, and optimization for BI solutions. - Conduct unit testing, troubleshooting, and debugging to ensure high-quality delivery. - Ensure accuracy, quality, and completeness of BI deliverables. - Work closely with cross-functional teams to support risk reporting requirements. - Manage version control and deployments using Git and DevOps tools. - Follow SDLC best practices, documentation standards, and coding guidelines. Qualification Required - 7+ years of experience as a BI Developer with SQL Server stack. - Strong expertise in SSIS (ETL development) and SSAS (Multidimensional, MDX). - Hands-on experience with SQL Server, T-SQL, SSRS & Power BI. - Proficiency in data modeling, cube design, and OLAP concepts. - Strong understanding of SDLC and Agile methodologies. - Experience using Git and Azure DevOps for version control and deployments. - Strong problem-solving, analytical, and debugging skills. - Excellent written & verbal communication skills. - Ability to work independently and in a collaborative environment. Good To Have - Experience in financial/risk reporting domain. - Cloud BI exposure (Azure / AWS). - Knowledge of DAX.,