Dan Piechowski

I’m a data architect and senior data engineer with 6+ years building Microsoft data platforms for complex manufacturing and distributed-service environments. My work centers on SQL Server, Microsoft Fabric lakehouses, and practical data products that serve executives and operations with confidence.

At Cadrex Manufacturing Solutions, I independently built and delivered a corporate data warehouse consolidating 10 ERP platforms and Dynamics 365 CRM across 15 manufacturing sites and 650+ source tables into SQL Server and Kimball reporting layers. I standardized heterogeneous ERP data, implemented conformed dimensions and facts, and designed Bronze/Silver/Gold medallion infrastructure in Fabric—landing extracts as Parquet, materializing Delta tables, and publishing Direct Lake semantic models. I also developed time-zone-aware dimensional modeling that maps UTC-captured facts to location-specific date/time dimensions for embedded analytics.

I build end-to-end pipelines with PySpark notebooks, Fabric pipeline orchestration, idempotent incremental sync, and SQL stored procedures for audit logging, SCD patterns, and self-healing reporting continuity during outages. I’ve also integrated SQL replicas, REST APIs, GraphQL, Epicor BAQ-over-REST, Azure Data Factory, and Power BI/Fabric semantic models, and I’ve used AI-assisted approaches to generate ERP data dictionaries and source-system knowledge bases to speed up stakeholder discovery.