MSBI Developer

Key Responsibilities:

• Design develop and maintain ETL processes using SQL Server Integration Services SSIS
• Develop and optimize complex SQL queries stored procedures views and functions
• Create and maintain reports and dashboards using SQL Server Reporting Services SSRS
• Develop multidimensional and tabular data models using SQL Server Analysis Services SSAS
• Design and implement data warehouse solutions using Star and Snowflake schemas
• Perform data extraction transformation and loading activities from multiple source systems
• Monitor ETL jobs and troubleshoot data quality and performance issues
• Work closely with business stakeholders to gather reporting and analytics requirements
• Ensure data integrity security and compliance across BI solutions
• Optimize SQL Server databases and BI applications for performance and scalability
• Support production deployments enhancements and maintenance activities
• Required Skills
• Strong experience in Microsoft SQL Server
• Hands on experience with
• SSIS SQL Server Integration Services
• SSRS SQL Server Reporting Services
• SSAS SQL Server Analysis Services
• Expertise in T SQL Stored Procedures Triggers Views and Query Optimization
• Experience in Data Warehousing concepts and ETL development
• Knowledge of OLAP Cubes Tabular Models and Data Modeling
• Understanding of database performance tuning and indexing strategies
• Experience with SQL Server Agent jobs and deployment processes
• Strong analytical and problem solving skills

Technical Requirements:

• Primary skills Technology Business Intelligence Integration MSBI SSIS Technology Business Intelligence Visualization MSBI Power BI

Preferred Skills:

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