MSBI Developer

Educational Requirements

Bachelor of Engineering

Service Line

Information Systems

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.

Additional Responsibilities

• 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.

Technical and Professional 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.

Preferred Skills

• Technology->Business Intelligence - Analytics->MSBI (SSAS)
• Technology->Business Intelligence - Reporting->MSBI (SSRS)
• Technology->Business Intelligence - Integration->MSBI (SSIS)
• Technology->SQL SSIS->SQL Server
• Technology->Cloud Platform->Power Platform->Power BI