MSBI and Power BI Developer

Job Summary

The MSBI and Power BI Developer internship offers the opportunity to design, develop, and deploy comprehensive Business Intelligence (BI) solutions tailored for the retail industry. You will utilize the Microsoft Business Intelligence (MSBI) suite—including SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), and SQL Server Analysis Services (SSAS)—to provide critical data insights and support business units such as sales, inventory, and supply chain. The role will require collaboration with cross-functional teams to gather requirements, ensure data accuracy, and optimize solutions for performance and scalability.

Responsibilities

• Design, develop, and deploy end-to-end BI solutions using the MSBI suite (SSIS, SSRS, SSAS).
• Create complex ETL packages in SSIS to extract, transform, and load data from various retail systems.
• Develop operational and analytical reports and dashboards in SSRS to support business units such as sales, inventory, and supply chain.
• Build and maintain SSAS cubes for multidimensional analysis and reporting.
• Collaborate with business analysts, data analysts, and stakeholders to gather BI requirements and convert them into technical specifications.
• Optimize data models and queries for performance and scalability.
• Ensure data accuracy, integrity, and consistency across all BI solutions.
• Monitor and troubleshoot BI processes and data issues.
• Stay updated with retail industry trends and BI best practices.

Qualifications

• Strong experience with MSBI tools: SSIS, SSRS, and SSAS.
• Solid understanding of data warehousing concepts and ETL frameworks.
• Proficient in T-SQL, stored procedures, functions, and query optimization.
• Hands-on experience with dimensional modeling (star/snowflake schemas).
• Experience working with large volumes of retail transactional data.
• Familiarity with POS, inventory, CRM, ERP, or loyalty systems in retail.
• Strong problem-solving and communication skills.
• Bachelor’s degree in Computer Science, Information Systems, or a related field (preferred for full-time, may be in progress for interns).

Preferred Skills

• Experience with Power BI or other modern data visualization tools.
• Knowledge of Azure Data Factory, SQL Server on Azure, or other cloud BI solutions.
• Experience with Agile/Scrum methodologies.

Experience

• Minimum Experience: 0 years (open to freshers and students; internship position).
• Relevant experience in BI, data warehousing, or retail data systems is a plus.

Environment

• Location: Not specified (please inquire during the interview process).
• Type: Contractual.
• Start Date: Immediately.
• Deadline for Applications: 2025-06-26.
• Work setting is remote.

Note: Salary, company overview, growth opportunities, and specific benefits are not provided in the current job description.