Data Warehouse Subject Matter Expert (SME)
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