BI Engineer-SQL Server/SSIS/SSAS Expert

Summary

Join our team as a highly skilled Data Engineer with deep expertise in Microsoft SQL Server, SSIS, and SSAS. You will play a key role in designing, developing, and optimizing SQL Server-based data solutions, including complex ETL workflows and analytical data models. This position requires hands-on expertise with SQL Server, SSIS, and SSAS, strong proficiency in T-SQL, and a solid understanding of data warehousing concepts and dimensional modeling. You will be responsible for designing, developing, and maintaining advanced SSIS packages, building and optimizing SSAS cubes, and working extensively with SQL Server to create and manage complex queries. Collaboration with analysts and stakeholders is crucial to understanding requirements and delivering scalable data solutions. Ensuring data quality, integrity, and performance is a key aspect of this role.

Requirements

• Deep hands-on expertise with SQL Server, SSIS, and SSAS
• Strong proficiency in T-SQL and performance optimization techniques
• Solid understanding of data warehousing concepts and dimensional modeling
• Experience working independently on data projects from design through deployment

Responsibilities

• Design, develop, and maintain advanced SSIS packages for robust ETL processes
• Build, deploy, and optimize SSAS cubes
• Work extensively with SQL Server to create, tune, and manage complex queries, stored procedures, and views
• Collaborate with analysts and stakeholders to understand requirements and deliver scalable data solutions
• Ensure data quality, integrity, and performance across all stages of the pipeline