Data Engineer - Cognos - MS SSIS Developer and Admin

Job description

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.