Worked on restructuring and enhancing the appeal documents ETL pipeline within the Planning-Inspectorate/odw-synapse-workspace repository, focusing on harmonised and curated notebooks to improve readability and maintain alignment with legacy behavior. Leveraged Python, Spark, and data engineering best practices to update primary key generation, refine RowID logic, and introduce safer hashing for data integration. Strengthened test coverage and reliability by implementing robust mocks and improving CI compatibility. Added new service bus fields and runtime helpers to streamline Delta Lake table creation, resulting in higher data quality, improved traceability, and easier onboarding of new data sources while increasing maintainability and testability.