Data Engineer - Cognos - MS SSIS Developer and Admin
Core
Design, develop, deploy, and manage enterprise-grade ETL solutions using Microsoft SQL Server Integration Services (SSIS) to ensure data integration reliability across systems.
Role type
Senior SSIS Developer & Administrator
Builds
Scalable data integration workflows, optimized SSIS packages, and stable production ETL environments
Domain
Enterprise Data Engineering / Microsoft SQL Server
Deliverable
production ML models | product features | dashboards & analysis | infrastructure
Required skills
SSIS development and administration, T-SQL programming, Data Warehousing concepts, SSIS performance tuning, SQL Server Agent management, ETL pipeline design
Preferred skills
Azure Data Factory, Power BI, DevOps/CI-CD pipelines, Git, Python scripting
Technologies
SSIS, SQL Server, SSMS, SSISDB, Azure Data Factory, Power BI, SSRS, Git
Responsibilities
Design and maintain SSIS packages for ETL, write optimized T-SQL queries and stored procedures, deploy and manage SSIS packages using SSIS Catalog, monitor package execution and troubleshoot failures, tune SSIS packages for performance, provide L2/L3 production support for ETL processes
Seniority
Senior, hands-on IC