Designs and refines Microsoft Fabric architectures, builds metadata-driven ingestion frameworks, migrates Azure Synapse workloads, and develops PySpark and Spark SQL pipelines. The role includes data validation, reconciliation, CDC strategies, medallion architecture, Git-based CI/CD, governance and lineage assessment, and AI-assisted development with Claude Code. The consultant collaborates directly with client engineers through paired development, code reviews, architecture decisions, and knowledge sharing.