Data Warehouse Subject Matter Expert

Description

Diaconia is seeking a Data Warehouse Subject Matter Expert to support the Client's Enterprise Data Modernization Program (Vortex). This is a proposal-critical Key Personnel role responsible for leading Enterprise Data Warehouse execution across a large, mission-critical SQL Server-based data environment supporting Client reporting, Search Plus, APIs, AI/ML enrichment, and mission-user data access.

The successful candidate must be more than a traditional SQL Server DBA. This role requires a senior EDW leader who can guide data warehouse development, ETL sustainment, dimensional modeling, production support, performance tuning, data quality, release execution, modernization planning, and technical coordination across a complex federal data ecosystem.

• Lead the EDW team responsible for development, sustainment, modernization, troubleshooting, and production support of Client's enterprise data warehouse environment.
• Provide hands-on technical leadership for SQL Server EDW design, dimensional modeling, ETL development, data ingestion, data validation, performance tuning, release support, and operational reliability.
• Maintain and enhance Kimball-style dimensional structures, including fact tables, dimension tables, star schemas, conformed dimensions, surrogate keys, slowly changing dimensions, and reporting-ready data models.
• Design, develop, review, troubleshoot, optimize, and maintain SSIS packages, T-SQL scripts, stored procedures, functions, triggers, indexes, jobs, views, and other EDW database objects.
• Support recurring production releases, including release planning, deployment coordination, regression testing, data validation, rollback planning, documentation, and post-release verification.
• Lead root-cause analysis for EDW defects, data quality issues, ETL failures, report discrepancies, performance degradation, job failures, and production incidents.
• Coordinate EDW work with downstream consumers, including Power BI, SSRS, enterprise reporting, Search Plus/Open Search, APIs, AI/ML models, dashboards, and mission-user applications.
• Support modernization planning for EDW architecture, cloud readiness, metadata, lineage, ELT, data quality, data observability, automation, and API-enabled data access.
• Develop and maintain source-to-target mappings, ETL documentation, data dictionaries, data lineage artifacts, data validation procedures, operational runbooks, and technical design documentation.
• Support performance optimization across large SQL Server databases, including indexing, partitioning, query tuning, statistics maintenance, execution plan analysis, storage optimization, and workload monitoring.
• Support high availability, disaster recovery, backup/recovery, failover testing, security patching, access controls, STIG/security compliance, and production database reliability.
• Support Agile or Kanban delivery, including backlog refinement, sprint planning, daily standups, technical estimation, demonstrations, retrospectives, and status reporting.

Mentor data engineers, ETL developers, DBAs, reporting developers, and analysts on EDW standards, development patterns, data quality practices, and production support expectations

Requirements

• Active U.S. government Secret clearance or higher required at proposal submission.
• U.S. Citizenship required.
• SME labor-category compliant education and experience:
  Bachelor's degree with 10+ years of relevant experience; less than a Bachelor's degree requires 14+ years of relevant experience;
  Master's degree or higher may qualify with 8+ years of relevant experience.
• For this role, Diaconia is seeking 15+ years of total database, data warehouse, data engineering, or related data management experience due to the scale and complexity of the Client's Vortex environment.
• 12+ years of hands-on SQL Server experience.
• Experience supporting large SQL Server databases or enterprise data warehouse environments, preferably 5 TB or larger, billion-row scale, or hundreds of tables.
• Experience leading or serving as a senior technical SME for an enterprise data warehouse team, data engineering team, ETL team, or production database/data platform team.
• Hands-on experience with SQL Server EDW development, administration, performance tuning, data modeling, ETL, production support, and release execution.
• Experience with Kimball-style dimensional modeling, including fact/dimension design, star schemas, conformed dimensions, surrogate keys, slowly changing dimensions, and reporting-ready data marts.
• Experience with SSIS, SSRS, SSAS, Power BI, T-SQL, SQL Agent jobs, stored procedures, indexes, views, triggers, functions, and SQL Server performance tools.
• Experience developing, maintaining, or troubleshooting ETL pipelines and data transformation workflows across multiple source systems.
• Experience creating or maintaining source-to-target mappings, data dictionaries, ETL specifications, lineage documentation, data validation rules, and technical design…