Data Warehouse Subject Matter Expert (SME)

Arlington, VA

Open 5 months, first seen by us 161 days ago

Pay: Pay not listedSimilar roles state $127K–$190K
Work setting: Not stated
Employment: Not stated

Before you apply

Work authorization: Citizens onlySecret Clearance required

What you’ll work on

Full posting

Design and optimize enterprise data warehouse architecture and performance
Develop fact and dimension structures using Kimball-style dimensional modeling
Build and maintain ETL/ELT pipelines, reports, and dashboards
Troubleshoot complex database and warehouse issues and recommend improvements

From the employer’s posting

Serve as the SME for enterprise data warehouse architecture, design, implementation, and performance optimization.

Design, support, and optimize enterprise data warehouse solutions using Kimball-style dimensional modeling and dimensional analysis methodologies.

Develop, maintain, and enhance ETL/ELT pipelines, reporting solutions, analytical models, and dashboard capabilities

Analyze data requirements, troubleshoot complex database and warehouse issues, and recommend improvements to architecture, processes, and tools.

What you’ll bring

All qualifications

Core experience

15+ years of total database experience.
12+ years of SQL Server experience within the overall 15 years of database experience.
Experience working with SQL Server databases of at least 5 TB and a billion total rows of data.
5+ years of experience working with Agile development methodologies.
3+ years of experience with Microsoft tools such as SSIS, SSRS, SSAS, Power BI, and ADO, as well as modern data management tools and technologies such as Python, R, and cloud services.
3+ years of experience performing dimensional analysis in a Kimball-style Enterprise Data Warehouse with not less than 500 total tables and a billion rows of data.

Qualification wording

15+ years of total database experience.

12+ years of SQL Server experience within the overall 15 years of database experience.

Experience working with SQL Server databases of at least 5 TB and a billion total rows of data.

5+ years of experience working with Agile development methodologies.

3+ years of experience with Microsoft tools such as SSIS, SSRS, SSAS, Power BI, and ADO, as well as modern data management tools and technologies such as Python, R, and cloud services.

3+ years of experience performing dimensional analysis in a Kimball-style Enterprise Data Warehouse with not less than 500 total tables and a billion rows of data.

Apply at Nationwide IT Services

Posting record

Report an error

Open 5 monthsWe first saw this posting 161 days ago and it is still up. Roles open this long are often slow to fill or kept open to collect applications.

Status in our records: Live
First seen by us: Jun 2, 2026161 days ago
Recorded sightings: 128
Last seen by us: Nov 11, 2026

These dates show when we found the posting. Check the employer’s website to confirm it is still accepting applications.

How this job compares

Pay

$127K–$190K is typical

The middle half of what similar US postings state. This one doesn’t list pay.

From 2,229 postings in the last year. Stated ranges, not salaries paid.

Time since we first saw it

Day 161

Up longer than most. Similar jobs usually come down between day 6 and day 55.

Well past Nationwide IT Services’s usual: its jobs come down by about day 19.

From 13,018 similar postings that came down, and 12 of Nationwide IT Services’s. Coming down is not always a hire.

Nationwide IT Services is hiring

5 open jobs

Open jobs by the week we first saw them, last 12 weeks.

Hiring has slowed
Takes jobs down at a usual pace

Hiring record

See how this role fits your experience

Add your resume and we’ll mark which of these tools you already use, and point out anything in the posting that could rule you out.

Python
R
SQL
Power BI
SQL Server
SSRS

Where the posting names them

- Utilize tools such as SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), SQL Server Analysis Services (SSAS), Power BI, and ADO to deliver data integration, reporting, and analytics solutions. - Apply modern tools and technologies, including Python, R, and cloud services, to improve data processing, analytics, and data platform capabilities. - Collaborate with cross-functional teams in Agile environments to support iterative development, testing, deployment, and continuous improvement of data warehouse solutions.

- 5+ years of experience working with Agile development methodologies. - 3+ years of experience with Microsoft tools such as SSIS, SSRS, SSAS, Power BI, and ADO, as well as modern data management tools and technologies such as Python, R, and cloud services. - 3+ years of experience performing dimensional analysis in a Kimball-style Enterprise Data Warehouse with not less than 500 total tables and a billion rows of data.

Data Warehouse Subject Matter Expert (SME) 100% on-site Secret Clearance required. 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. 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.

- Develop, maintain, and enhance ETL/ELT pipelines, reporting solutions, analytical models, and dashboard capabilities using Microsoft data tools and modern data management technologies. - Utilize tools such as SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), SQL Server Analysis Services (SSAS), Power BI, and ADO to deliver data integration, reporting, and analytics solutions. - Apply modern tools and technologies, including Python, R, and cloud services, to improve data processing, analytics, and data platform capabilities.

- 15+ years of total database experience. - 12+ years of SQL Server experience within the overall 15 years of database experience. - Experience working with SQL Server databases of at least 5 TB and a billion total rows of data.

- 12+ years of SQL Server experience within the overall 15 years of database experience. - Experience working with SQL Server databases of at least 5 TB and a billion total rows of data. - 5+ years of experience working with Agile development methodologies.

Upload resume Add LinkedIn

Your next step

Complete your application on nationwideitservices.applytojob.com. The employer’s form will show what is required.

Applying through JazzHR

No account needed: one application form on the employer’s applytojob.com page.

Already applied? Track this application

Demand for Data Engineer roles

New Data Engineer postings at the employers we follow are up 7% over the last 6 weeks compared with the 6 before.

August 17Last week

Each bar is one week of new postings. The darkest bars are the last 6 weeks.

Counted from the hiring pages we’ve followed for at least five weeks, so employers we add don’t look like growth. Updated weekly.

About the role

We file this job under Data Engineer, by the work the posting describes.

Data engineers build and run the pipelines that copy data out of apps and outside services into a warehouse or lake, and fix them when a source changes or a load fails.

Expect SQL, Python, a cloud platform, a scheduler such as Airflow, and often tools for large data such as Spark or Kafka.

An analytics engineer works one step later, turning the raw data a data engineer lands into clean tables people can query.

US government figures for database architects

Median yearly pay, May 2025: $139,500
Expected change, 2025 to 2035: 9.4% more jobsagainst 3.5% for all jobs

The government has no code for data engineers, so these figures are for the closest group, database architects, which includes data integration and data warehousing specialists.

Source: US Bureau of Labor Statistics, Occupational Employment and Wage Statistics (May 2025) and Employment Projections (2025 to 2035). Occupation code 15-1243.

Job description

View original posting ↗

Data Warehouse Subject Matter Expert (SME)
100% on-site
Secret Clearance required.

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.

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 within complex enterprise data warehouse environments consisting of large table counts and high-volume data.
Develop, maintain, and enhance ETL/ELT pipelines, reporting solutions, analytical models, and dashboard capabilities using Microsoft data tools and modern data management technologies.
Utilize tools such as SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), SQL Server Analysis Services (SSAS), Power BI, and ADO to deliver data integration, reporting, and analytics solutions.
Apply modern tools and technologies, including Python, R, and cloud services, to improve data processing, analytics, and data platform capabilities.
Collaborate with cross-functional teams in Agile environments to support iterative development, testing, deployment, and continuous improvement of data warehouse solutions.
Analyze data requirements, troubleshoot complex database and warehouse issues, and recommend improvements to architecture, processes, and tools.
Ensure that enterprise data warehouse solutions are scalable, maintainable, and aligned with mission and business objectives.

Minimum Qualifications

15+ years of total database experience.
12+ years of SQL Server experience within the overall 15 years of database experience.
Experience working with SQL Server databases of at least 5 TB and a billion total rows of data.
5+ years of experience working with Agile development methodologies.
3+ years of experience with Microsoft tools such as SSIS, SSRS, SSAS, Power BI, and ADO, as well as modern data management tools and technologies such as Python, R, and cloud services.
3+ years of experience performing dimensional analysis in a Kimball-style Enterprise Data Warehouse with not less than 500 total tables and a billion rows of data.
Secret Clearance required.

Work Location
Work will be performed at DEA offices in Merrifield, VA; DEA Headquarters in Arlington, VA; and other offices deemed appropriate by the Government.

Why Join Nationwide IT Services?

Nationwide IT Services is a trusted government contractor supporting Department of Defense customers. We offer the opportunity to work on high-impact cybersecurity missions alongside experienced professionals in a collaborative and growth-focused environment.

Source details