United States
I write Engineer of Data to share practical, battle-tested insights for data engineers who run real production workloads - not theory, but what actually works in complex enterprise environments. Through DILM Suite, I build the tools that solve the exact governance and lifecycle challenges I write about. Many organizations are still running mission-critical workloads on SSIS - not as a hobby, but because it works, it's paid for, and it delivers at scale. The real problems aren't the packages themselves. They're the friction in lifecycle management: manual environment comparisons, fragile deployments, limited change visibility, and the growing difficulty of operating orchestration reliably. That's why I created DILM Suite - practical tools for Data Integration Lifecycle Management (DILM). SSIS Catalog Compare gives teams instant, accurate visibility into differences between SSIS Catalog environments. SSIS Framework Manager brings structure, restartability, configuration control, and enterprise-grade governance to SSIS Applications. Supporting utilities turn DILM elements into governed, deployable assets. We address a clear gap: orchestration is getting easier, but lifecycle management is getting harder. Whether your team maintains a large SSIS estate, is preparing for thoughtful modernization to Fabric, ADF, or beyond, or simply wants to reduce deployment risk and operational surprises, DILM Suite delivers visibility, confidence, and control - without forcing a rip-and-replace approach. I've spent years helping data engineering teams manage SSIS the right way - from framework design through production support and safe modernization planning. The patterns I kept seeing led directly to these tools. If your SSIS environments feel fragile, your deployments carry more risk than they should, or you're tired of manual processes, feel free to connect or reach out. I'm happy to talk through your situation. You can also find more stories and hard-earned advice in my newsletter Engineer of Data.
DILM Suite helps enterprises make mission-critical SSIS workloads reliable to operate, easy to govern, and safe to modernize. Many organizations still run production data engineering on SQL Server Integration Services (SSIS) — not as a hobby, but because it works, it’s paid for, and it delivers at scale. The real challenges aren’t the packages. They’re the friction in lifecycle management: manual environment comparisons, fragile deployments, limited change visibility, and the growing difficulty of operating orchestration reliably. That’s why I built the DILM Suite — practical tools for Data Integration Lifecycle Management (DILM). Our Core Tools • SSIS Catalog Compare — Instantly and accurately compare SSIS Catalog environments with confidence. • SSIS Framework Manager — Structured management of SSIS Applications for DevOps, restartability, configuration control, and governance. • Supporting tools that turn DILM elements into governed, deployable assets. We address a common gap: orchestration is getting easier, but lifecycle management is getting harder. Whether your team maintains large SSIS estates or is preparing for modernization, DILM Suite delivers visibility, confidence, and control — without forcing a rip-and-replace approach. I’ve spent years helping data engineering teams manage SSIS the right way — from framework design through production support and safe modernization planning. The DILM Suite exists because I kept seeing the same patterns: inherited “modern or bust” narratives that ignore real production realities, and the need for tools that respect both the power of SSIS and today’s governance and DevOps demands. We keep it focused, practical, and built by practitioners for practitioners. Learn more at dilmsuite.com or ssisframework.com. Explore the free Community Edition of the SSIS Framework or discover how DILM Suite can bring predictability to your environments.
I lead teams that design and deliver enterprise data platforms, integration solutions, and analytics systems across hybrid on-premises and cloud environments. My focus is building production-grade solutions that reduce risk, accelerate delivery, and improve confidence in decision-making. I specialize in modern data engineering practices across SSIS, Azure Data Factory, and Microsoft Fabric, incorporating DevOps, governance, and AI-assisted workflows to help teams deliver faster without sacrificing reliability.
Present discussions and interview leaders in Data.
Present discussions and interview leaders in Quantum Computing.
Author and co-author of several books on SQL Server Integration Services (SSIS), Azure Data Factory (ADF), Technical Team Management, Design Patterns, and Frameworks. Amazon Author page: https://amazon.com/author/andyleonard
ALT rocks Business Intelligence training and consulting! We specialize in Microsoft SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), and SQL Server relational data warehouses design and implementation.