SQL Server Data Warehouse Architect Needed for One-Time Architecture Review

I need a one-time review of a SQL Server data warehouse architecture. The system is already built and working. I do not need a rebuild, dashboard, generic SQL queries, or ongoing support. The warehouse is for SEO / market intelligence and uses: - Microsoft SQL Server - Bronze / Silver / Gold layers - API/source ingestion - SERP/ranking data - Google Search Console - Screaming Frog crawl data - GA4 / analytics data - competitor ranking data - URL identity joins - latest Gold views for downstream reporting/actions I need an experienced SQL Server data warehouse / data engineering person to review the architecture from a metadata-only export pack and produce a clear written improvement plan. What I will provide: - database object inventory - column dictionary - view definitions - table row counts - join/spine contract - Gold/Silver model maps - architecture diagrams - governance notes - known issues and next developer tasks No raw data is required initially. No database credentials are required initially. No production access is required for the review. What I need reviewed: 1. Overall SQL Server warehouse structure 2. Bronze / Silver / Gold layer design 3. Table grain and join keys 4. URL identity spine and market/keyword spine 5. Latest views and versioned Gold tables 6. Indexing and performance risks 7. Join anti-patterns 8. Data quality / validation gates 9. Automation strategy for future pulls and refreshes 10. How to make the Silver and Gold tables more useful for business decisions Deliverable: A written review and improvement plan covering: - whether the architecture is sound - what should be fixed first - indexing/performance recommendations - improvements to Silver and Gold table design - validation gates/tests to add - automation/pipeline recommendations - risks or bad joins to avoid - practical next steps for implementation Required experience: - Microsoft SQL Server - Data warehouse design - ETL / ELT pipelines - Bronze/Silver/Gold or medallion-style architecture - Indexing and query optimisation - Data modelling - Data quality checks / validation gates - Ability to review architecture from metadata documentation only What I do not need: - No dashboard build - No generic SQL query writing - No full rebuild - No ML model build yet - No ongoing retainer - No direct production changes This is a fixed-price architecture review only. If the review is useful, implementation work may be discussed later as a separate project. Before applying, please answer: Have you reviewed or designed a SQL Server data warehouse from schema/metadata documentation only, without direct database access or raw data? If yes, briefly explain how you would approach this review.