ETL Developer
Iqra SaleemQASENIORPosted 2h ago
SQL ServerSSISSSAST-SQLData WarehousingPower BI
About the Role
We are seeking an experienced ETL Developer / Data Engineer for a long-term contract to design, develop, and optimize data pipelines and data warehouse solutions using SSIS and SSAS multi-dimensional cubes.
Key Responsibilities
• Build, maintain, and optimize end-to-end ETL workflows using SSIS
• Develop, deploy, and tune SSAS multi-dimensional cubes for reporting
• Write complex T-SQL queries, stored procedures, and functions
• Design dimensional data models (Star & Snowflake schemas)
• Manage job scheduling, data validation, and pipeline troubleshooting
• Document ETL workflows and collaborate with BI/business teams
Requirements
• 7–8 years of hands-on experience in ETL / Data Engineering
• Strong expertise in SQL Server, SSIS, and SSAS (Multi-dimensional cubes)
• Advanced SQL query writing, stored procedures, and performance tuning
• Solid grasp of Data Warehousing, Star/Snowflake schema, and job scheduling
• Basic knowledge of Power BI and Banking domain experience (preferred)
• Bachelor’s degree in Computer Science, IT, or related field