MSBI Developer

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

• SQL Server
• MSBI (SSRS)
• MSBI (SSAS)
• MSBI (SSIS)
• Power BI

Educational Requirements

Bachelor of Engineering