Senior Data Warehouse Architect - EDW & Modernization Lead

Diaconia; Merrifield (VA); On-site; USD 150,000 - 220,000; Full time

Job summary

Diaconia is seeking a senior Data Warehouse Subject Matter Expert to lead the Client's Enterprise Data Modernization Program (Vortex) in a large SQL Server environment. This role guides data warehouse development, ETL sustainment, modeling, and production support across a federal-scale data ecosystem.

The candidate will coordinate with Power BI, SSRS, APIs, AI/ML enrichment, and reporting apps, while driving modernization planning, data quality, security, and release execution.

Qualifications

• Experience leading enterprise data warehouse teams with SQL Server.
• Strong dimensional modeling and ETL development skills.
• Experience in production support, data quality, and release execution.
• Familiarity with reporting tools like Power BI/SSRS/SSAS.

Responsibilities

• Lead EDW development, sustainment, modernization, and production support.
• Provide hands-on technical leadership for EDW design, ETL, ingestion, validation, and performance tuning.
• Maintain Kimball-style dimensional structures and data models.
• Design and maintain SSIS packages, T-SQL scripts, stored procedures, and indexes.
• Coordinate releases, data validation, rollback planning, and documentation.
• Mentor engineers, DBAs, and analysts on EDW standards and best practices.

Skills

SQL Server EDW leadership

Dimensional modeling

ETL development

Data quality

Production support

Education

Bachelor's degree + 10+ years relevant experience

Tools

SSIS

SSRS

SSAS

Power BI

T-SQL

SQL Server

Job description

Diaconia is seeking a senior Data Warehouse Subject Matter Expert to lead the Client's Enterprise Data Modernization Program (Vortex) in a large SQL Server environment. This role guides data warehouse development, ETL sustainment, modeling, and production support across a federal-scale data ecosystem.

The candidate will coordinate with Power BI, SSRS, APIs, AI/ML enrichment, and reporting apps, while driving modernization planning, data quality, security, and release execution.