Data Warehouse Subject Matter Expert (SME)

Job description

Data Warehouse Subject Matter Expert (SME) Position Summary: The Data Warehouse Subject Matter Expert (SME) provides senior-level technical leadership in the design, development, optimization, and support of enterprise data warehouse environments. This role serves as the primary expert for large-scale SQL Server data warehouse platforms, dimensional modeling, reporting and analytics solutions, and modern data management tools. The SME supports enterprise data initiatives by applying best practices in database architecture, ETL/ELT processes, analytics, and Agile delivery to ensure scalable, high-performing, and reliable data solutions. 100% on-site Secret Clearance required. Key Responsibilities: - Serve as the SME for enterprise data warehouse architecture, design, implementation, and performance optimization. - Provide deep technical expertise in large-scale SQL Server database environments, including systems with multi-terabyte data volumes and billion-row datasets. - Design, support, and optimize enterprise data warehouse solutions using Kimball-style dimensional modeling and dimensional analysis methodologies. - Lead and support the development of fact and dimension structures...