- 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
- Robust 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