Worked on the communitiesuk/epb-data-warehouse and epb-aws-infrastructure repositories to deliver five new features focused on data architecture, performance, and operational scalability. Enhanced assessment data governance by introducing schema versioning and supporting versioned queries, using Ruby on Rails and SQL migrations. Improved document retrieval efficiency and data integrity through partition pruning and stricter validation. Optimized authentication throughput by refactoring bearer token checks and implemented a DynamoDB Global Secondary Index for faster token lookups, leveraging AWS and Terraform. Standardized CSV export formatting to align with downstream data processing requirements, ensuring reliable data accessibility and supporting robust, scalable backend and infrastructure workflows.