Data Engineer - Cognos - MS SSIS Developer and Admin

Who We Are

At Kyndryl, we run and reimagine the mission-critical technology systems that drive advantage for the world’s leading businesses. We are at the heart of progress; with proven expertise and a continuous flow of AI-powered insight, enabling smarter decisions, faster innovation, and a lasting competitive edge. For our people—Kyndryls—that means doing purposeful work that powers human progress. Join us and experience a flexible, supportive environment where your well-being is prioritized and your potential can thrive.

The Role

Required Skills and Experience

Expertise in data mining, data storage and Extract-Transform-Load (ETL) processes

Experience in data pipelines development and tooling, e.g., Glue, Databricks, Synapse, or Dataproc

Experience with both relational and NoSQL databases, PostgreSQL, DB2, MongoDB

Excellent problem-solving, analytical, and critical thinking skills

Ability to manage multiple projects simultaneously, while maintaining a high level of attention to detail

Communication Skills: Must be able to communicate with both technical and non-technical colleagues, to derive technical requirements from business needs and problems

Preferred Skills and Experience

Experience working as a Data Engineer and/or in cloud modernization

Experience in Data Modelling, to create conceptual model of how data is connected and how it will be used in business processes

Professional certification, e.g., Open Certified Technical Specialist with Data Engineering Specialization

Cloud platform certification, e.g., AWS Certified Data Analytics – Specialty, Elastic Certified Engineer, Google Cloud Professional Data Engineer, or Microsoft Certified: Azure Data Engineer Associate

Understanding of social coding and Integrated Development Environments, e.g., GitHub and Visual Studio

Degree in a scientific discipline, such as Computer Science, Software Engineering, or Information Technology

Your future at Kyndryl

Every position at Kyndryl offers a way forward to grow your career, from Junior System Administrator to Architect. We have opportunities for Cloud Hyperscale's that you won’t find anywhere else, including hands-on experience, learning opportunities, and the chance to certify in all four major platforms. One of the benefits of Kyndryl is that we work with clients in a variety of industries, from banking to retail. Whether you want to broaden your knowledge base or narrow your scope and specialize in a specific sector, you can find your opportunity here.

Who You Are

Who You Are

You’re good at what you do and possess the required experience to prove it. However, equally as important – you have a growth mindset; keen to drive your own personal and professional development. You are customer-focused – someone who prioritizes customer success in their work. And finally, you’re open and borderless – naturally inclusive in how you work with others.

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.

Key Responsibilities

SSIS Development

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

Develop reusable SSIS components and frameworks

Database & Data Engineering

Write optimized T-SQL queries, stored procedures, views, and functions

Design and support data warehouse and dimensional models (Star/Snowflake schemas)

Work closely with BI teams (Power BI / SSRS)

SSIS Administration

Deploy, configure, and manage SSIS packages using SSIS Catalog (SSISDB)

Monitor package execution and troubleshoot failures

Manage SQL Server Agent jobs and scheduling

Perform environment migrations (Dev QA Prod)

Performance & Optimization

Tune SSIS packages for performance (parallelism, memory, buffering)

Identify bottlenecks in ETL pipelines and implement improvements

Optimize SQL queries and data loads

Data Governance & Quality

Ensure data quality, integrity, and consistency across systems

Implement logging, auditing, and error-handling frameworks

Support data validation and reconciliation processes

Support & Maintenance

Provide L2/L3 production support for ETL processes

Troubleshoot data issues and performance degradation

Maintain documentation for ETL processes and pipelines

Required Skills & Experience

Technical Skills

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

Additional Skills (Preferred)

Experience with Azure Data Factory (ADF) / Azure Data Integration tools

Knowledge of Power BI / SSRS reporting

Exposure to DevOps / CI-CD pipelines for SSIS deployments

Experience using Git or version control systems

Familiarity with Python / scripting for automation

Soft Skills

Strong analytical and problem-solving skills

Ability to work independently and lead ETL initiatives

Excellent communication and stakeholder management

Ability to mentor junior developers

Qualifications

Bachelor’s degree in Computer Science / IT or related field

Microsoft certifications (preferred):

Azure Data Engineer / SQL Server certifications

Nice to Have

Experience in large-scale enterprise data environments

Exposure to cloud migration projects

Knowledge of data governance tools

Key Deliverables

Reliable, high-performance ETL pipelines

Optimized SSIS packages and workflows

Well-documented data integration solutions

Stable production ETL environment

Being You

The “Kyn” in Kyndryl means kinship, which represents the strong bonds we have with each other, our customers and our communities. We focus on ensuring all Kyndryls feel included and we welcome people of all cultures, backgrounds, and experiences. Even if you don’t meet every requirement, we encourage you to apply. We believe in growth, and we’re excited to see what you can bring. At Kyndryl, employee feedback has told us that our number one driver of employee engagement is belonging. That sense of belonging — being a valued, respected, trusted member of the team — is fundamental to our culture and fueling great experiences for our customers. This dedication to welcoming everyone into our company means that Kyndryl gives you the ability to thrive and contribute to our culture of empathy and shared success. That’s The Kyndryl Way.

What You Can Expect

Your career with us isn’t just a job—it’s an adventure with purpose. We offer a dynamic, hybrid-friendly culture that supports your well-being and empowers you to grow. Our Be Well programs are thoughtfully designed to support your financial, mental, physical, and social health—because we know that when you feel your best, you do your best.

From your very first day, you’ll dive into impactful work that powers the systems our customers rely on every day. You won’t just contribute—you’ll make a difference, tackling meaningful projects that sharpen your skills and fuel your growth.

We’re here to champion your journey. With powerful tools to chart your career path, personalized development goals aligned with your ambitions, and continuous feedback to keep you inspired and on track, you’ll have everything you need to thrive and evolve. You’ll develop in-demand skills to grow your career and achieve your ambitions with access to cutting-edge learning opportunities—from certifications with Microsoft, Google, and Amazon to coaching and hands-on experiences. And through it all, you’ll be part of a culture that values empathy, restless learning, and a devotion to shared success.

We want you to thrive here—and we’re committed to helping you do just that. Ready to make an impact? Join us and help shape what’s next.

Get Referred!

If you know someone that works at Kyndryl, when asked ‘How Did You Hear About Us’ during the application process, select ‘Employee Referral’ and enter your contact's Kyndryl email address.