MSBI Developer

Core Responsibilities:

• Design, develop, and sustain ETL workflows utilizing SQL Server Integration Services (SSIS)
• Create and enhance intricate SQL queries, stored procedures, views, and functions
• Generate and manage reports and dashboards with SQL Server Reporting Services (SSRS)
• Develop multidimensional and tabular data models through SQL Server Analysis Services (SSAS)
• Architect and execute data warehouse solutions employing Star and Snowflake schemas
• Conduct data extraction, transformation, and loading tasks from various source systems
• Oversee ETL operations and resolve issues related to data quality and performance
• Collaborate with business stakeholders to collect analytics and reporting requirements
• Guarantee data integrity, security, and compliance across business intelligence solutions
• Enhance SQL Server databases and BI applications for optimal performance and scalability
• Facilitate production deployments, enhancements, and maintenance tasks
• Essential Skills
• Proficient experience with Microsoft SQL Server
• Practical knowledge of
• 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
• Familiarity with data warehousing principles and ETL development
• Knowledge of OLAP cubes, tabular models, and data modeling
• Comprehension of database performance tuning and indexing strategies
• Experience with SQL Server Agent jobs and deployment methodologies
• Strong analytical and problem-solving capabilities

Technical Qualifications:

• Key competencies in Business Intelligence Integration using MSBI SSIS and Business Intelligence Visualization with MSBI Power BI

Desirable Skills:

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