Sign up to access all features of our service.
  • Job search
  • Favorites
  • Create a CV
    New
  • Salaries
  • Subscriptions

Data Warehouse Subject Matter Expert (SME)

Nationwide IT Services

Data Warehouse Subject Matter Expert (SME)

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.
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.

Vacancy posted 4 days ago
Similar jobs that could be interesting for youBased on the Data Warehouse Subject Matter Expert (SME) in Arlington, VA vacancy
  • Big Data Subject Matter Expert Bethesda, MD McLean, VA Chantilly, VA Top Secret/SCI Polygraph Mid Level Career (5+ yrs experience) Salary not specified Join a mission that matters. We're seeking a skilled Big Data Subject Matter Expert to support critical government and... 
    Suggested

    ClearanceJobs

    Mc Lean, VA
    3 days ago
  • $160k - $170k

     ...proactively protecting DOE information systems. The Cybersecurity Subject Matter Expert (SME) plays a critical role in supporting this mission by...  ...to solve highly complex problems, interpret technical data, and develop actionable security recommendations. ~ Demonstrated... 
    Suggested
    Full time
    Contract work
    Part time
    For contractors
    Work at office
    Remote work

    Akima, LLC

    Washington DC
    20 days ago
  •  ...ProSidian Consulting at DescriptionProSidian Seeks a Subject Matter Expert | Nuclear Energy Subject Matter Expert (SME) [DNE007] Engagement Team | Subject Matter Expert...  ...perform, including business processes, data, systems, and peopleCommunication - ability to effectively... 
    Suggested
    Full time
    Contract work
    For contractors
    H1b
    Work at office
    Remote work
    Flexible hours

    Prosidian Consultng

    Washington DC
    5 days ago
  •  ...accomplish this support a recognized expert(s) in a specified field or...  ...expertise in the designated subject matter and provide expert level...  ...a specific task requirement. SME cost will be proposed and negotiated...  ...in research methods, data analysis techniques, and relevant... 
    Suggested
    Full time
    Temporary work
    For contractors
    Flexible hours

    Prosidian Consultng

    Washington DC
    5 days ago
  •  ...Business Process Technology Subject Matter Expert (SME) / Reporting Team Lead Position Summary Nationwide IT Services, NIS, is seeking a Business...  ...and functional leadership for enterprise reporting, data visualization, and business process technology initiatives.... 
    Suggested
    For contractors
    Work at office

    Nationwide IT Services

    Arlington, VA
    3 days ago
  • $75k - $95k

    Overview SENIOR MARITIME DATA AND INFRASTRUCTURE SUBJECT MATTER EXPERT (DOT): Bowhead seeks a Senior Maritime Data & Infrastructure SME to join our team in Washington, DC. This position reports directly to the Executive Director and serves as the primary and senior staff... 
    Full time
    Contract work
    Temporary work
    Part time
    For contractors
    Work experience placement
    Work at office
    Remote work

    UIC Government Services and the Bowhead Family of Companies

    Washington DC
    3 days ago
  • $119k - $172k

    Nuclear Stockpile Stewardship Subject Matter Expert Company Overview: ANSER enhances national and homeland...  ...Stewardship Subject Matter Expert (SME) to support the Air Force Deputy Chief...  ...and interpret nuclear weapons effects data, test results, and scientific assessments... 
    Full time
    Work at office
    Local area

    ClearanceJobs

    Washington DC
    3 days ago
  • $157.99k - $252.79k

     ...Groundswell is seeking an experienced Army Financial Management (FM) Subject Matter Expert (SME) to support the design, enhancement, and deployment of an...  ...and feeder systems, business processes and underlying data sources. Identify audit pain points and bottlenecks that... 
    Contract work
    Work at office
    Local area
    Immediate start
    Flexible hours

    Clearance Jobs

    Mc Lean, VA
    1 day ago
  • $165k - $175k

    OM&S-R Subject Matter Expert (SME) Location: Alexandria, VA or Washington Navy Yard, DC (Onsite - minimum 2 days a week) Level: Senior Manager...  ...revolutionize consulting and advisory services through innovative, data-driven solutions. The Montcure team recognize the unique... 
    Full time
    Immediate start
    2 days per week

    Montcure LLC

    Washington DC
    3 days ago
  •  ...defense agencies, is seeking to hire a Contract Database Support Subject Matter Expert (SME) to support our potential client. The position is fully...  ...Provide comprehensive day-to-day support for the contract data environment, including SharePoint Online lists, Power BI... 
    Contract work
    Work at office
    Remote work

    Grey Street Consulting LLC

    Washington DC
    3 days ago
  • $150k - $190k

     ...Cost Accounting & Compliance SME Harnessing Technology to Improve...  ...(BWG) unites deep domain experts with technologists who...  ...oversight activities. Serve as a subject matter expert on accounting, cost...  ...including financial reporting and data visualization. At Blake... 
    For contractors
    Remote work

    Blake Wilson Group

    Washington DC
    4 days ago
  •  ...Job Description Job Description SUBJECT MATTER EXPERT (SME) ISO Position Purpose: Serves as an authoritative technical and strategic advisor...  ...Six Sigma Business Process Re-engineering, or Enterprise Data Analytics/Power BI. Work Location & Remote Stance: Primarily... 
    Remote work

    ResolveSoft Inc

    Washington DC
    23 days ago
  • $100k - $140k

    Job Description Description SAIC's Identity and Data Sciences Laboratory (IDSL) is seeking a Biometric Subject Matter Expert (SME) to lead and support applied research, development, test, and evaluation (RDT&E) of advanced biometric and identity solutions for national... 
    Work at office
    Remote work

    Science Applications International Corporation

    Washington DC
    3 days ago
  •  ...Job Description Job Description AI/ML Subject Matter Expert (SME) / Analytics Team Lead Active Secret clearance required. 100% on-site...  ...analytical, and AI/ML techniques to structured and unstructured data. The AI/ML SME works closely with stakeholders, developers,... 
    For contractors
    Work at office

    Nationwide IT Services

    Arlington, VA
    5 days ago
  • $130k - $140k

     ...worldwide. With more than 1,700+ team members, 1,500+ AI & data experts, and 100+ prime contracts, we deliver at scale and with...  ...Credence has an upcoming need for a Ab Initio Architect and Subject Matter Expert (SME) to join our team supporting the modernization of an... 
    Temporary work
    Worldwide

    Credence

    McLean, VA
    12 days ago
  • $92.3k - $166.85k

     ..., hands-on Microsoft Endpoint Configuration Manager (MECM) Subject Matter Expert (SME) and Team Lead to support DISA J-6/J-9 operations in the National...  ..., as well as internal equity, alignment with market data, applicable bargaining agreement (if any), or other law.SummaryLocation... 
    Full time

    Leidos

    Arlington, VA
    2 days ago
  • $97.2k - $165.6k

     ...highly experienced Supply Chain Subject Matter Expert to support an anticipated...  ...teams, the Supply Chain SME will design and implement methodologies...  ..., inventory controls, warehouse operations, transportation...  ...methodologies, quality assurance, and data interpretation. Collaborate... 
    Full time
    Temporary work
    Work at office

    Dexis Consulting Group

    Washington DC
    2 days ago
  •  ...Job Description Job Description Agile Business Concepts, LLC is seeking an experienced Subject Matter Expert (SME) to provide specialized technical, operational, and advisory support to the U.S. Department of State's Passport Services Directorate. Key Responsibilities... 

    Agile Business Concepts, LLC

    Washington DC
    28 days ago
  • $120k - $190k

     ...partners, we all achieve greater success.   Credence has an upcoming need for a EDI/XML Subject Matter Expert (SME) at Intermediate level to support our Enterprise leveled Data AI/ML project supporting critical Department of Defense (DoD) supply chain operations by... 
    Full time
    Contract work
    Temporary work

    Credence

    Tysons, VA
    3 days ago
  •  ...intelligence projects. Join GDIT as a Artificial Intelligence (AI) Subject Matter Expert Support (SME) for a career where your growth is just as important as...  ...ML development, to include GPU/TPU compute ecosystems, data center architecture, semiconductor supply chains,... 
    Part time
    Work experience placement

    General Dynamics Information Technology

    Fort Belvoir, VA
    a month ago
  •  ...FOIA (Freedom of Information Act) Technical Subject Matter Expert/Consultant We are actively searching for a FOIA Subject Matter Expert (SME) in the Washington D.C. area with...  ...and leads surveys to collect and analyze data to provide advice and recommend solutions... 
    Full time

    Armedia LLC

    Vienna, VA
    5 days ago
  •  ...that specializes in Logistics, Warehouse Services, Distance Learning/...  ...& Threat Assessment, and Data Analytics/Operations Research...  ...'s requirements. Title: Subject Matter Expert - International Operations...  ...enforcement activities. The SME will support foreign-nexus intelligence... 
    Permanent employment
    Full time
    Contract work
    Temporary work
    For contractors
    Overseas

    Knowledge Management

    Washington DC
    3 days ago
  • Title: Subject Matter Expert (SME) Location: Washington, DC Job Description: The Senior Subject Matter Expert (SME) provides expert-level support, analysis, and research on exceptionally complex technical problems and processes. This role serves as a trusted technical... 

    Apex Informatics

    Washington DC
    3 days ago
  • $108k - $132k

    Subject Matter Expert (SME) Location: Washington, DC (Onsite) Clearance Required: Active Secret Clearance Employment Type: Full-Time Position Status: Contingent Upon Contract Award The salary range for this position is $108,000 to $132,000 annually. Actual compensation... 
    Full time
    Contract work
    Work at office

    Summit Technologies

    Washington DC
    3 days ago
  • Subject Matter Expert (SME) ADHCA Journeyman R&K Enterprise Solutions, Inc. (R&K) is a certified Service-Disabled Veteran Owned Small Business (SDVOSB) with core capabilities in Mission Support, Engineering and Logistics, Cybersecurity and Intelligence, Environmental and... 
    Permanent employment
    Full time
    Contract work
    Shift work

    ClearanceJobs

    Falls Church, VA
    3 days ago
  • EPDS Subject Matter Expert (SME) TechSur Solutions is a digital services company whose mission is to enable digital transformation for our customers...  ...and applications, leveraging Agile development, and Data Analytics. Since we were formed in August of 2016, we have... 

    TechSur Solutions

    Reston, VA
    3 days ago
  • SME I Primary Location: Washington, DC Clearance: Active TS/SCI Obsidian Solutions Group is seeking a SME I to serve as a subject matter expert supporting DHS missions in the Greater Washington, D.C. area, providing expert guidance, consultation, facilitation, training,... 
    Work at office

    Obsidian Solutions Group

    Washington DC
    3 days ago
  •  ...Job Description Job Description Subject Matter Expert (SME) Cybersecurity  ????  Bethesda, MD | McLean, VA | Chantilly, VA ???? Full-Time...  ...Maximize the use of tools to correlate information and synthesize data into actionable events. Identify and apply an agile... 
    Full time

    Synertex LLC

    Bethesda, MD
    16 days ago
  • $86k - $120k

     ...seeking a highly qualified Collective Training Subject Matter Expert (SM:E) to support an opportunity with the Department of War. The SME will provide expert collective training...  ...internal equity mapping and alignment with market data, or other applicable laws. Veterans are... 
    Temporary work
    Flexible hours

    PingWind

    Fort Belvoir, VA
    25 days ago
  • DescriptionJob Title: Subject Matter Expert (SME) Enterprise ArchitectLocation: Hybrid - 2 days a week on-site - Suitland, MDSalary: 190-260KSummaryPosition...  ...owns enterprise architecture direction across business, data, application, security, and technology domains. You will be... 
    Full time
    2 days per week

    ActioNet

    Suitland, MD
    3 days ago

Do you want to receive more vacancies?

Subscribe and receive similar vacancies to Data Warehouse Subject Matter Expert (SME). Be the first to apply!