Senior Data Warehouse MSBI Engineer

SWITS DIGITAL Private Limited; Pune District; Vor Ort; INR 1.500.000 - 2.500.000; Vollzeit

Zusammenfassung

SWITS DIGITAL Private Limited in Pune seeks a Senior Data Warehouse MSBI Engineer with 8 to 12 years of experience to design, develop, and optimize enterprise data landscapes.

You will lead ETL processes using SSIS/SSAS/SSRS, implement data modelling best practices (Kimball), and collaborate with onshore/offshore teams to deliver scalable solutions and reliable reporting.

Qualifikationen

• Strong hands-on experience with SSIS, SSAS, SSRS, SQL/T-SQL and Data Modelling.
• Design, develop, and maintain enterprise Data Warehouse and ETL solutions.
• Expertise in SQL Server/T-SQL, stored procedures, functions, views, triggers, and optimization.
• Experience with SSAS/SSRS, including cubes, dimensions, measures, hierarchies, datasets and enterprise reporting.
• Strong Data Modelling with Kimball methodologies and star/snowflake schemas.
• Experience in production support, data quality, ETL issues, and performance tuning.
• Understanding of SDLC, deployment, source control, JIRA/TFS and CI/CD.
• Experience collaborating with business stakeholders and distributed teams.
• Exposure to cloud data services (GCP, BigQuery, Azure Data Factory, AWS) desirable.
• Knowledge of cloud migration, modernization and AI-enabled data platforms is a plus.

Aufgaben

• Design, develop, and maintain enterprise Data Warehouse and ETL solutions.
• Build and optimize SSIS packages for large-volume data processing.
• Develop cubes and dimensional models for enterprise reporting.
• Provide mentoring and guidance to team members.
• Support data quality, troubleshoot ETL issues and performance bottlenecks.
• Collaborate with stakeholders and distributed onshore/offshore teams.
• Contribute to SDLC activities, deployments, and CI/CD pipelines.

Jobbeschreibung

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.