MSBI

Job Description:

• 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

Key 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

Technical 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

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

Preferred Skills:

Technology->Business Intelligence - Integration->MSBI (SSIS),Technology->Business Intelligence - Visualization->MSBI (Power BI)