Data Engineer – Cognos – MS SSIS Developer and Admin

Role Overview

We are seeking an experienced Senior SSIS Developer & Administrator to design, develop, deploy, and manage enterprise-grade ETL solutions using Microsoft SQL Server Integration Services (SSIS). The role will also be responsible for administration, performance optimization, and ensuring data integration reliability across systems.

What You Will Do

Design, develop, and maintain SSIS packages for data extraction, transformation, and loading (ETL). Build scalable data integration workflows across multiple sources (SQL Server, Oracle, flat files, APIs, etc.). Implement complex transformations, data cleansing, and business rules.

Why It Might Be a Fit

You will be working on reliable, high-performance ETL pipelines, optimized SSIS packages and workflows, and well-documented data integration solutions. You will be part of a dynamic, hybrid-friendly culture that supports your well-being and empowers you to grow.

Requirements

• 6–10+ years of experience in SSIS development and administration
• Strong expertise in Microsoft SQL Server (2012/2016/2019/2022)
• Proficiency in SSIS, SSMS, SQL Server Agent
• Advanced T-SQL programming skills
• Experience with Data Warehousing concepts (ETL, OLAP, dimensional modeling)
• Hands-on with SSIS performance tuning and troubleshooting
• Experience with Data Migration and Integration projects

Benefits

• Reliable, high-performance ETL pipelines
• Optimized SSIS packages and workflows
• Well-documented data integration solutions
• Stable production ETL environment