MSBI Professional

Infosys; Bengaluru; On-site; INR 900,000 - 1,500,000; Full time

Job summary

Infosys in Bengaluru seeks an MSBI Developer to design, develop, and maintain enterprise data warehousing, ETL, reporting, and BI solutions using SQL Server, SSIS, SSAS, and Power BI. The role emphasizes translating business requirements into scalable data solutions while ensuring data quality and performance.

The candidate will design data models, build ETL pipelines, create dashboards, optimize performance, and collaborate with stakeholders to deliver actionable reports and insights.

Qualifications

• Strong hands-on experience with Microsoft SQL Server.
• ETL development and data integration using SSIS.
• Experience with SSAS multidimensional and/or tabular models.
• Power BI report/dashboard development experience.
• Understanding of Data Warehouse concepts, star schema, and data modeling.
• Expertise in SQL query tuning and performance optimization.
• Excellent analytical, problem-solving, and communication skills.
• Exposure to Azure Data Services (Azure SQL, Azure Data Factory, Synapse Analytics).
• Experience with Power BI DAX and Power Query.
• Knowledge of data governance and reporting best practices.

Responsibilities

• Develop and maintain database objects, including stored procedures, functions, views, and triggers in SQL Server.
• Design, build, and support ETL packages using SSIS.
• Develop and manage multidimensional/tabular models using SSAS.
• Create interactive dashboards, reports, and visualizations using Power BI.
• Perform data analysis, validation, and troubleshooting to ensure data quality and integrity.
• Optimize database performance and ETL processes.
• Collaborate with business users and stakeholders to gather and understand reporting requirements.
• Support data warehousing and business intelligence initiatives.

Skills

Analytical skills

Problem-solving

Communication skills

Data modeling

SQL query tuning

Education

Bachelor of Engineering

Tools

SQL Server

SSIS

SSAS

Power BI

Azure Data Factory

Synapse Analytics

Job description

Job Summary

We are seeking a skilled MSBI Developer with experience in SQL Server, SSIS, SSAS, and Power BI to design, develop, and maintain enterprise data warehousing, ETL, reporting, and business intelligence solutions. The ideal candidate should have strong analytical skills and the ability to transform business requirements into scalable data solutions.

Responsibilities

• Develop and maintain database objects, including stored procedures, functions, views, and triggers in SQL Server.
• Design, build, and support ETL packages using SSIS.
• Develop and manage multidimensional/tabular models using SSAS.
• Create interactive dashboards, reports, and visualizations using Power BI.
• Perform data analysis, validation, and troubleshooting to ensure data quality and integrity.
• Optimize database performance and ETL processes.
• Collaborate with business users and stakeholders to gather and understand reporting requirements.
• Support data warehousing and business intelligence initiatives.

Requirements

• Strong hands-on experience with Microsoft SQL Server.
• Experience in SSIS for ETL development and data integration.
• Knowledge of SSAS (Multidimensional and/or Tabular Models).
• Proficiency in Power BI report and dashboard development.
• Good understanding of Data Warehouse concepts, Star Schema, and Data Modeling.
• Expertise in SQL query tuning and performance optimization.
• Strong analytical, problem-solving, and communication skills.
• Exposure to Azure Data Services (Azure SQL, Azure Data Factory, Synapse Analytics).
• Experience with Power BI DAX and Power Query.
• Knowledge of data governance and reporting best practices.

Qualifications

• Bachelor of Engineering