- 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:
- Solid 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