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 ResponsibilitiesServe 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 Qualifications15+ 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.
- ...Job Description Job Description Subject Matter Expert (SME) Big Data ???? Bethesda, MD | McLean, VA | Chantilly, VA ???? Full-Time | On-site Join a mission that matters. We're seeking a skilled Big Data Subject Matter Expert to support critical government...SuggestedFull time
- ...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,...SuggestedPart timeWork experience placement
$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...SuggestedContract workWork at officeLocal areaImmediate startFlexible hours$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...SuggestedFull time$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...SuggestedTemporary workWorldwide- ...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 contractorsWork at office
- ...Description Job Description Business Process Technology Subject Matter Expert (SME) / Reporting Team Lead Active Secret clearance required... ...technical and functional leadership for enterprise reporting, data visualization, and business process technology initiatives....For contractorsWork at office
- ...Redhorse Corporation. We are a solution-driven company delivering data insights and technology solutions to customers with... ...and technology. To support this mission, we are seeking a Subject Matter Expert (SME) for Software Systems Engineering. As a recognized expert within...Contract work
$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...Full timeContract workPart timeFor contractorsWork at officeRemote work- ...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...Full timeTemporary workFor contractorsFlexible hours
- ...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...Full timeContract workFor contractorsH1bWork at officeRemote workFlexible hours
- ...structures and applications, leveraging Agile development, and Data Analytics. Since we were formed in August of 2016, we have... ...Job Description TechSur is seeking a Senior EPDS Subject Matter Expert (SME) with demonstrated experience supporting the USDA Enterprise...
$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...Full timeTemporary workFlexible hours$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 timeContract workTemporary work$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 contractorsRemote work- Safety and Occupational Environmental Health (SOEH) Senior Analyst and Subject Matter Expert (SME)Concurrent Technologies CorporationArlington, VA Minimum Clearance Required: SecretClearance Level Must Be Able to Obtain: Secret“In a rapidly changing world, preparedness...Full timeFor contractorsWork at office
- ...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
$125k - $175k
...TekSynap is seeking a Cloud Computing SME to join our government project supporting... ...Architectural Concepts & Design Requirements Cloud Data Security Cloud Platform &... ...laws. All employees and candidates may be subject to drug screening if deemed necessary to ensure...Full timeContract workTemporary workWork at officeLocal areaMonday to FridayWeekend workDay shiftAfternoon shift$90k - $125k
...analysis services to the U.S. Government. Our National Security experts include technical and policy specialists in proliferation... ...the Advisory and Assistance Services (A&AS) Epidemiology Subject Matter Expert (SME) for the Defense Threat Reduction Agency (DTRA) Global...Contract workFor contractorsWork experience placementFor subcontractorWork at officeLocal area- ...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
- ...Description Job Description Overview Software Developer Subject Matter Expert (SME) Springfield, VA Are you ready to enhance your... ..., and maintainability. Support integrations and data exchanges between enterprise applications using APIs, web services...Contract workWork at office
$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 timeTemporary workWork at office- ...Financial Services Cyber Intelligence Subject Matter Expert to an already outstanding team.You Are:... ...The Work:As a Financial Services Sector SME within the IIA team, you will report to... ...more information on how we process your data during the Recruiting and Hiring...Temporary workWork experience placementLive inWork at officeLocal area
$89.6k - $194k
Position Description:CGI is seeking a high‑potential SAP Asset Accounting Subject Matter Expert (SME) with experience in asset accounting processes for the federal government. The successful candidate will work closely with clients to lead workshops, understand requirements...Contract workWork at officeLocal area2 days per week- ...and InterSystems IRIS for Health, the data platform created specifically for the development... ....This role resides in our broader “Subject Matter Expert” team. This team was formed as a result... ...Sector Subject Matter Expert (PS-SME) is responsible for influencing and accelerating...Permanent employmentWork experience placementWorldwide
- ...Redhorse Corporation. We are a solution-driven company delivering data insights and technology solutions to customers with... ...and technology. To support this mission, we are seeking a Subject Matter Expert (SME) for Software Systems Engineering. As a recognized expert within...Full time
$90k - $175k
...Job Description Job Description Joint Training & Doctrine Subject Matter Expert (SME) Location: Arlington VA (On-site) Employment Type: Full-Time Security Requirement: Active Secret Position Overview Nationwide IT Services (NIS) is seeking an experienced...Full timeWork at officeRemote work- ...Counter-Unmanned Systems Policy Subject Matter Expert The client is seeking a highly skilled Counter-Unmanned Systems (C-UXS) Policy Subject Matter Expert to support the Office of the Assistant Secretary of Defense for Special Operations/Low Intensity Conflict (ASD...Work at office
$135k - $155k
...Subject Matter Expert Suvi, an Akima Company, is looking for a Subject Matter Expert to support... ...Capital Region. The Subject Matter Expert (SME) provides senior-level technical,... ...Gather facts, research issues, analyze data, and develop expert-level conclusions,...Full timePart timeRelocation- ...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...
Do you want to receive more vacancies?
Subscribe and receive similar vacancies to Data Warehouse Subject Matter Expert (SME). Be the first to apply!
- data intern Falls Church, VA
- data collection researcher Falls Church, VA
- data visualization Falls Church, VA
- data analysis part time Falls Church, VA
- data collection Falls Church, VA
- data modeling Falls Church, VA
- data Falls Church, VA
- master data coordinator Falls Church, VA
- data labeling Falls Church, VA
- data capturer Falls Church, VA



