Sr Data Warehouse MSBI Engineer

TITLE: Senior Data Warehouse MSBI Engineer

Location - Pune

Experience - 8 to 12 Years

Key Skills Responsibilities

• Strong hands-on experience with SSIS, SSAS, SSRS, SQL/T-SQL, and Data Modelling.
• Design, develop, and maintain enterprise Data Warehouse and ETL solutions, including complex SSIS packages and large-volume data processing.
• Strong expertise in SQL Server/T-SQL, Stored Procedures, Functions, Views, Triggers, query optimization, and performance tuning.
• Experience with SSAS/SSRS, including cubes, dimensions, measures, hierarchies, analytical models, datasets, and enterprise reporting.
• Strong understanding of Data Modelling, Kimball methodology, Fact/Dimension tables, and Star/Snowflake schemas.
• Experience in production support, troubleshooting, data quality, ETL issues, and performance optimization.
• Good understanding of SDLC, deployment processes, source control, JIRA/TFS, and CI/CD.
• Experience working with business stakeholders and distributed onshore/offshore teams.
• Ability to work independently and provide technical guidance/mentoring to team members.
• Exposure to GCP, BigQuery, Google Cloud Storage, Azure Data Factory, or AWS data services is desirable.
• Knowledge of cloud migration, modernization, and cloud-based data integration is an advantage.
• Exposure to AI/ML, GenAI, LLMs, Agentic AI, RAG, and AI-assisted development tools such as GitHub Copilot is desirable.
• Strong communication, analytical, troubleshooting, and stakeholder-management skills.

Preferred: Candidates with experience modernizing traditional ADW/Data Warehouse environments to Cloud and AI-enabled data platforms.

Disclaimer: This job posting has been aggregated from external source. Role details, content, and availability are subject to change. Applicants are advised to confirm the latest information directly on the company website before applying.