- Primary skills:Technology->Business Intelligence - Integration->MSBI (SSIS),Technology->Business Intelligence - Visualization->MSBI (Power BI)
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.
