CareerPlan

Data Warehouse Subject Matter Expert (SME)

Arlington, VAFull-time2026-11-16
On-siteSecurity clearance required

Core

Senior technical leadership in designing, developing, optimizing, and supporting enterprise SQL Server data warehouse environments for large-scale government data initiatives.

Role type

Senior IC data warehouse architect and SME

Builds

Enterprise data warehouse solutions, ETL/ELT pipelines, reporting solutions, and analytical models

Domain

Government / Enterprise Data Warehousing

Required skills

SQL Server, dimensional modeling (Kimball), ETL/ELT, SSIS, SSRS, SSAS, Power BI, Python, R, cloud services, Agile

Preferred skills

None stated

Technologies

SQL Server, SSIS, SSRS, SSAS, Power BI, ADO, Python, R

Responsibilities

Design and optimize enterprise data warehouse architecture; Lead development of fact and dimension structures; Develop and maintain ETL/ELT pipelines; Troubleshoot complex database and warehouse issues; Collaborate in Agile environments for iterative development

Seniority

Senior, hands-on IC