Piotr Kasprzyk

Senior Data Systems Engineer | SQL Server, ETL & Reporting Systems | Data Reliability, Troubleshooting & Root Cause Analysis

Poland

About

I work with enterprise data systems focused on MS SQL Server, ETL pipelines and reporting platforms. My main area of expertise is diagnosing and resolving data inconsistencies across production systems — from source data and ETL layers to reporting and business-facing outputs. I specialize in root cause analysis of data issues, troubleshooting of data warehouse processes and ensuring the correctness and reliability of reporting pipelines. My background combines software engineering (.NET/C#), database development and data-focused system work, which allows me to understand both application behavior and data flow end-to-end. In recent projects I have worked with MS SQL Server, SSIS, SSRS, SSAS, Power BI and Dataiku, including automation of reporting workflows and AI-assisted scripting for diagnostic and validation tasks. I value direct communication, collaborative work and shared ownership of complex systems.

Experience

  • Future Processing (14 yrs 9 mos)
    • Senior Data & Software Engineer (SQL Server / Data Platforms / ETL Systems)
      Oct 2011 - Present · 14 yrs 9 mos

      Software engineer with over 14 years of experience in enterprise systems, progressively specializing in SQL Server-based data platforms, ETL processing and reporting solutions. Over time, my role evolved from general .NET application development towards data engineering and enterprise data systems, including ETL workflows, reporting pipelines and data warehouse-related solutions. My work combines development of new functionality with long-term evolution of existing systems. I design and implement SQL Server-based processing logic, develop and extend ETL pipelines, support reporting and analytical solutions, and work on integration between multiple enterprise systems. A significant part of my work involves analysing complex data flows and resolving inconsistencies across system layers. I am particularly effective in rapid root cause analysis of production issues related to ETL processes, reporting discrepancies and data pipeline failures. Key areas of work include: SQL Server development (T-SQL, stored procedures, data processing logic) ETL development and troubleshooting using SSIS Reporting and analytical solutions (SSAS / SSRS / Power BI) Enterprise application and database integration Evolution and modernization of long-lived enterprise systems Analysis and resolution of data inconsistencies across production environments Background in .NET/C# enterprise application development and system integration.

    • Senior Data Engineer
      Jul 2023 - Present · 3 yrs

      Responsible for the development, maintenance and evolution of enterprise software and data systems supporting business-critical processes. Worked across multiple layers of the system landscape, including application logic, database design and data processing pipelines, ensuring consistency and reliability of delivered solutions. Key responsibilities and contributions: Took ownership of key enterprise applications and data-driven systems, ensuring their long-term stability and maintainability in a production environment Designed, developed and maintained SQL Server-based data models, stored procedures and ETL logic supporting business reporting and operational processes Investigated and resolved complex data inconsistencies across multiple system layers, performing root cause analysis and implementing corrective solutions Supported the evolution of legacy systems built in .NET (C#, ASP.NET MVC, WPF), gradually improving their structure and maintainability Worked closely with business stakeholders to clarify requirements, validate data definitions and translate them into technical implementations Contributed to the integration of different systems and data sources within the enterprise environment, ensuring data consistency across platforms Participated in long-term maintenance and improvement of systems developed over many years, with focus on reliability and predictable behaviour rather than short-term features

    • Senior Software Developer
      Mar 2023 - Jun 2023 · 4 mos

      Internal project for managing the data of the projects run by the company. Backend (Database + REST WebAPI) and frontend (React) tasks connected with the application development. Working Agile in Kanban-like framework with Refinements and Retrospective meetings.

  • IT Specialist at Intelix sp. z o.o.
    Oct 2003 - Sep 2011 · 8 yrs

    Application development (MS Visual Basic 6.0, MS Visual C# 2005 - Windows Forms and ASP.NET). Database Management (MS SQL Server 2000, 2005, T-SQL scripts). Local network management. Occasional work with php/mysql web pages.

  • Programmer at Kamsoft
    Nov 2001 - May 2002 · 7 mos

    Application development in Kylix/Delphi, Database management on Oracle, transferring existing source code from Windows to Unix/Linux platform, administration of local linux server

  • Programmer at Spin Sp. z o.o.
    Oct 1999 - Jun 2001 · 1 yr 9 mos

    Application development in MS Visual Basic, Work with databases on IBM AS/400 Software maintenance

  • Programmer/Developer at Hanslik Software Laboratory
    Feb 1997 - Sep 1997 · 8 mos

    Scripting in avenue (for Esri ArcView) Creating frontend in MS Access for GIS systems in ArcInfo