MSBI Developer

Job Description

About The Opportunity A rapidly growing digital transformation and analytics consulting company within the Enterprise IT & Business Intelligence sector, we architect and deliver end-to-end Microsoft BI solutions that turn raw data into actionable insight for Fortune 500 and high-growth Indian enterprises. Leveraging the full Microsoft stack—SQL Server, SSIS/SSRS/SSAS, Power BI—we enable decision makers to visualise trends, optimise operations and achieve data-driven growth. Role & Responsibilities Design, develop and deploy enterprise-grade ETL workflows using SSIS to ingest, cleanse and transform large data sets. Create interactive dashboards and paginated reports with Power BI and SSRS that surface KPIs and support self-service analytics. Model multidimensional and tabular datasets in SSAS, implementing partitions, hierarchies and calculations for high-performance querying. Optimise complex T-SQL stored procedures, views and indexing strategies to ensure sub-second response times and data integrity. Collaborate with business analysts to translate requirements into technical specifications and deliver incremental value in Agile sprints. Establish best-practice guidelines for version control, CI/CD and automated testing across the BI codebase. Skills & Qualifications Must-Have 3-6 years hands-on with the Microsoft BI stack—SSIS, SSRS, SSAS. Expert T-SQL programming and query-tuning skills on SQL Server 2016+. Experience designing star/snowflake schemas and data marts. Knowledge of Power BI service, DAX and gateway configuration. Clear understanding of ETL best practices, error handling and scheduling. Strong Git-centric workflow and exposure to Agile delivery. Preferred Azure Synapse or Data Factory experience. Exposure to DevOps pipelines for database deployments. Familiarity with Python or C# for data manipulation. Prior experience in BFSI or Retail analytics domains. Benefits & Culture Highlights Hybrid work flexibility after onboarding and knowledge transfer. Certification sponsorship for Azure & Power BI credentials. Merit-based fast-track growth and onsite client opportunities. Skills: ssas,ssrs,sql,git,dax,etl best practices,t-sql,msbi,sql server 2016+,agile,ssis,etl,power bi