Data Warehouse Subject Matter Expert (SME)

{
  "content_hash": "334fb26b4e497756bd6c3cf33d127660b804ad6fc1752aa36e6ccb66f7b056a3",
  "source_hash": "a951079a439db5d911fa14b8116873721db401e346068619120190673771958f",
  "last_changed_at": "2026-05-30T06:12:32.185Z",
  "active_status": "active"
}

{
  "language": "en",
  "location": {
    "raw": "Arlington, VA",
    "city": "Arlington",
    "region": "VA",
    "country": "United States",
    "is_remote": false,
    "confidence": 0.9
  },
  "salary_max": null,
  "salary_min": null,
  "inferred_at": "2026-06-06T10:52:19.991Z",
  "launch_scope": {
    "reason": "jazzhr_production_catalog",
    "included": true,
    "location": {
      "raw": "Arlington, VA",
      "city": "Arlington",
      "region": "VA",
      "country": "United States",
      "is_remote": false,
      "confidence": 0.9
    },
    "countries": [
      "United States"
    ]
  },
  "remote_policy": null,
  "salary_period": null,
  "workplace_type": "on_site",
  "salary_currency": null
}

{}

{
  "detail": {
    "url": "https://nationwideitservices.applytojob.com/apply/jobs/details/KgypdyJsnk?&",
    "heading": "Data Warehouse Subject Matter Expert (SME)",
    "html_title": "JazzHR » Job Listings",
    "canonical_url": "https://nationwideitservices.applytojob.com/apply/KgypdyJsnk/Data-Warehouse-Subject-Matter-Expert-SME",
    "description_html": "<p><span style=\"font-size:16px;\"><span style=\"font-family:Arial, Helvetica, sans-serif;\"><strong>Data Warehouse Subject Matter Expert (SME)</strong></span></span></p><p><span style=\"font-size:14px;\"><span style=\"font-family:Arial, Helvetica, sans-serif;\"><strong>Position Summary</strong><br>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.<br><br><strong>100% on-site<br>Secret Clearance required.</strong></span></span></p><p><span style=\"font-size:14px;\"><span style=\"font-family:Arial, Helvetica, sans-serif;\"><strong>Key Responsibilities</strong></span></span></p><ul><li><span style=\"font-size:14px;\"><span style=\"font-family:Arial, Helvetica, sans-serif;\">Serve as the SME for enterprise data warehouse architecture, design, implementation, and performance optimization.</span></span></li><li><span style=\"font-size:14px;\"><span style=\"font-family:Arial, Helvetica, sans-serif;\">Provide deep technical expertise in large-scale SQL Server database environments, including systems with multi-terabyte data volumes and billion-row datasets.</span></span></li><li><span style=\"font-size:14px;\"><span style=\"font-family:Arial, Helvetica, sans-serif;\">Design, support, and optimize enterprise data warehouse solutions using Kimball-style dimensional modeling and dimensional analysis methodologies.</span></span></li><li><span style=\"font-size:14px;\"><span style=\"font-family:Arial, Helvetica, sans-serif;\">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.</span></span></li><li><span style=\"font-size:14px;\"><span style=\"font-family:Arial, Helvetica, sans-serif;\">Develop, maintain, and enhance ETL/ELT pipelines, reporting solutions, analytical models, and dashboard capabilities using Microsoft data tools and modern data management technologies.</span></span></li><li><span style=\"font-size:14px;\"><span style=\"font-family:Arial, Helvetica, sans-serif;\">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.</span></span></li><li><span style=\"font-size:14px;\"><span style=\"font-family:Arial, Helvetica, sans-serif;\">Apply modern tools and technologies, including Python, R, and cloud services, to improve data processing, analytics, and data platform capabilities.</span></span></li><li><span style=\"font-size:14px;\"><span style=\"font-family:Arial, Helvetica, sans-serif;\">Collaborate with cross-functional teams in Agile environments to support iterative development, testing, deployment, and continuous improvement of data warehouse solutions.</span></span></li><li><span style=\"font-size:14px;\"><span style=\"font-family:Arial, Helvetica, sans-serif;\">Analyze data requirements, troubleshoot complex database and warehouse issues, and recommend improvements to architecture, processes, and tools.</span></span></li><li><span style=\"font-size:14px;\"><span style=\"font-family:Arial, Helvetica, sans-serif;\">Ensure that enterprise data warehouse solutions are scalable, maintainable, and aligned with mission and business objectives.</span></span></li></ul><p><span style=\"font-size:14px;\"><span style=\"font-family:Arial, Helvetica, sans-serif;\"><strong>Minimum Qualifications</strong></span></span></p><ul><li><span style=\"font-size:14px;\"><span style=\"font-family:Arial, Helvetica, sans-serif;\"><strong>15+ years of total database experience.</strong></span></span></li><li><span style=\"font-size:14px;\"><span style=\"font-family:Arial, Helvetica, sans-serif;\"><strong>12+ years of SQL Server experience</strong> within the overall 15 years of database experience.</span></span></li><li><span style=\"font-size:14px;\"><span style=\"font-family:Arial, Helvetica, sans-serif;\">Experience working with <strong>SQL Server databases of at least 5 TB</strong> and <strong>a billion total rows of data</strong>.</span></span></li><li><span style=\"font-size:14px;\"><span style=\"font-family:Arial, Helvetica, sans-serif;\"><strong>5+ years of experience</strong> working with <strong>Agile development methodologies</strong>.</span></span></li><li><span style=\"font-size:14px;\"><span style=\"font-family:Arial, Helvetica, sans-serif;\"><strong>3+ years of experience</strong> with Microsoft tools such as <strong>SSIS, SSRS, SSAS, Power BI, and ADO</strong>, as well as modern data management tools and technologies such as <strong>Python, R, and cloud services</strong>.</span></span></li><li><span style=\"font-size:14px;\"><span style=\"font-family:Arial, Helvetica, sans-serif;\"><strong>3+ years of experience</strong> performing <strong>dimensional analysis</strong> in a <strong>Kimball-style Enterprise Data Warehouse</strong> with <strong>not less than 500 total tables</strong> and <strong>a billion rows of data</strong>.</span></span></li><li><span style=\"font-size:14px;\"><span style=\"font-family:Arial, Helvetica, sans-serif;\">Secret Clearance required.</span></span></li></ul><p><span style=\"font-size:14px;\"><span style=\"font-family:Arial, Helvetica, sans-serif;\"><strong>Work Location</strong><br>Work will be performed at <strong>DEA offices in Merrifield, VA; DEA Headquarters in Arlington, VA; and other offices deemed appropriate by the Government</strong>.</span></span><br> </p><h2 style=\"text-align:justify;margin-top:13px;\"><strong><span style=\"font-size:14px;\"><span style=\"font-family:Arial, Helvetica, sans-serif;\"><span style=\"line-height:115%;\"><span style=\"color:#4f81bd;\">Why Join Nationwide IT Services?</span></span></span></span></strong></h2><p><span style=\"font-size:14px;\"><span style=\"font-family:Arial, Helvetica, sans-serif;\"><span style=\"line-height:115%;\">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.</span></span></span></p>",
    "description_text": "Data Warehouse Subject Matter Expert (SME)\n Position Summary\nThe 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.\n 100% on-site\nSecret Clearance required.\n Key Responsibilities\n Serve as the SME for enterprise data warehouse architecture, design, implementation, and performance optimization.\n Provide deep technical expertise in large-scale SQL Server database environments, including systems with multi-terabyte data volumes and billion-row datasets.\n Design, support, and optimize enterprise data warehouse solutions using Kimball-style dimensional modeling and dimensional analysis methodologies.\n 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.\n Develop, maintain, and enhance ETL/ELT pipelines, reporting solutions, analytical models, and dashboard capabilities using Microsoft data tools and modern data management technologies.\n 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.\n Apply modern tools and technologies, including Python, R, and cloud services, to improve data processing, analytics, and data platform capabilities.\n Collaborate with cross-functional teams in Agile environments to support iterative development, testing, deployment, and continuous improvement of data warehouse solutions.\n Analyze data requirements, troubleshoot complex database and warehouse issues, and recommend improvements to architecture, processes, and tools.\n Ensure that enterprise data warehouse solutions are scalable, maintainable, and aligned with mission and business objectives.\n Minimum Qualifications\n 15+ years of total database experience.\n 12+ years of SQL Server experience within the overall 15 years of database experience.\n Experience working with SQL Server databases of at least 5 TB and a billion total rows of data .\n 5+ years of experience working with Agile development methodologies .\n 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 .\n 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 .\n Secret Clearance required.\n Work Location\nWork will be performed at DEA offices in Merrifield, VA; DEA Headquarters in Arlington, VA; and other offices deemed appropriate by the Government .\n Why Join Nationwide IT Services?\n 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.",
    "jsonld_jobposting": {
      "url": "https://nationwideitservices.applytojob.com/apply/KgypdyJsnk/Data-Warehouse-Subject-Matter-Expert-SME",
      "@type": "JobPosting",
      "title": "Data Warehouse Subject Matter Expert (SME)",
      "@context": "http://schema.org/",
      "datePosted": "2026-04-21",
      "description": "<p><span style=\"font-size:16px;\"><span style=\"font-family:Arial, Helvetica, sans-serif;\"><strong>Data Warehouse Subject Matter Expert (SME)</strong></span></span></p><p><span style=\"font-size:14px;\"><span style=\"font-family:Arial, Helvetica, sans-serif;\"><strong>Position Summary</strong><br>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.<br><br><strong>100% on-site<br>Secret Clearance required.</strong></span></span></p><p><span style=\"font-size:14px;\"><span style=\"font-family:Arial, Helvetica, sans-serif;\"><strong>Key Responsibilities</strong></span></span></p><ul><li><span style=\"font-size:14px;\"><span style=\"font-family:Arial, Helvetica, sans-serif;\">Serve as the SME for enterprise data warehouse architecture, design, implementation, and performance optimization.</span></span></li><li><span style=\"font-size:14px;\"><span style=\"font-family:Arial, Helvetica, sans-serif;\">Provide deep technical expertise in large-scale SQL Server database environments, including systems with multi-terabyte data volumes and billion-row datasets.</span></span></li><li><span style=\"font-size:14px;\"><span style=\"font-family:Arial, Helvetica, sans-serif;\">Design, support, and optimize enterprise data warehouse solutions using Kimball-style dimensional modeling and dimensional analysis methodologies.</span></span></li><li><span style=\"font-size:14px;\"><span style=\"font-family:Arial, Helvetica, sans-serif;\">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.</span></span></li><li><span style=\"font-size:14px;\"><span style=\"font-family:Arial, Helvetica, sans-serif;\">Develop, maintain, and enhance ETL/ELT pipelines, reporting solutions, analytical models, and dashboard capabilities using Microsoft data tools and modern data management technologies.</span></span></li><li><span style=\"font-size:14px;\"><span style=\"font-family:Arial, Helvetica, sans-serif;\">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.</span></span></li><li><span style=\"font-size:14px;\"><span style=\"font-family:Arial, Helvetica, sans-serif;\">Apply modern tools and technologies, including Python, R, and cloud services, to improve data processing, analytics, and data platform capabilities.</span></span></li><li><span style=\"font-size:14px;\"><span style=\"font-family:Arial, Helvetica, sans-serif;\">Collaborate with cross-functional teams in Agile environments to support iterative development, testing, deployment, and continuous improvement of data warehouse solutions.</span></span></li><li><span style=\"font-size:14px;\"><span style=\"font-family:Arial, Helvetica, sans-serif;\">Analyze data requirements, troubleshoot complex database and warehouse issues, and recommend improvements to architecture, processes, and tools.</span></span></li><li><span style=\"font-size:14px;\"><span style=\"font-family:Arial, Helvetica, sans-serif;\">Ensure that enterprise data warehouse solutions are scalable, maintainable, and aligned with mission and business objectives.</span></span></li></ul><p><span style=\"font-size:14px;\"><span style=\"font-family:Arial, Helvetica, sans-serif;\"><strong>Minimum Qualifications</strong></span></span></p><ul><li><span style=\"font-size:14px;\"><span style=\"font-family:Arial, Helvetica, sans-serif;\"><strong>15+ years of total database experience.</strong></span></span></li><li><span style=\"font-size:14px;\"><span style=\"font-family:Arial, Helvetica, sans-serif;\"><strong>12+ years of SQL Server experience</strong> within the overall 15 years of database experience.</span></span></li><li><span style=\"font-size:14px;\"><span style=\"font-family:Arial, Helvetica, sans-serif;\">Experience working with <strong>SQL Server databases of at least 5 TB</strong> and <strong>a billion total rows of data</strong>.</span></span></li><li><span style=\"font-size:14px;\"><span style=\"font-family:Arial, Helvetica, sans-serif;\"><strong>5+ years of experience</strong> working with <strong>Agile development methodologies</strong>.</span></span></li><li><span style=\"font-size:14px;\"><span style=\"font-family:Arial, Helvetica, sans-serif;\"><strong>3+ years of experience</strong> with Microsoft tools such as <strong>SSIS, SSRS, SSAS, Power BI, and ADO</strong>, as well as modern data management tools and technologies such as <strong>Python, R, and cloud services</strong>.</span></span></li><li><span style=\"font-size:14px;\"><span style=\"font-family:Arial, Helvetica, sans-serif;\"><strong>3+ years of experience</strong> performing <strong>dimensional analysis</strong> in a <strong>Kimball-style Enterprise Data Warehouse</strong> with <strong>not less than 500 total tables</strong> and <strong>a billion rows of data</strong>.</span></span></li><li><span style=\"font-size:14px;\"><span style=\"font-family:Arial, Helvetica, sans-serif;\">Secret Clearance required.</span></span></li></ul><p><span style=\"font-size:14px;\"><span style=\"font-family:Arial, Helvetica, sans-serif;\"><strong>Work Location</strong><br>Work will be performed at <strong>DEA offices in Merrifield, VA; DEA Headquarters in Arlington, VA; and other offices deemed appropriate by the Government</strong>.</span></span><br> </p><h2 style=\"text-align:justify;margin-top:13px;\"><strong><span style=\"font-size:14px;\"><span style=\"font-family:Arial, Helvetica, sans-serif;\"><span style=\"line-height:115%;\"><span style=\"color:#4f81bd;\">Why Join Nationwide IT Services?</span></span></span></span></strong></h2><p><span style=\"font-size:14px;\"><span style=\"font-family:Arial, Helvetica, sans-serif;\"><span style=\"line-height:115%;\">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.</span></span></span></p>",
      "jobLocation": {
        "@type": "Place",
        "address": {
          "@type": "PostalAddress",
          "postalCode": "",
          "addressRegion": "VA",
          "addressLocality": "Arlington"
        }
      },
      "validThrough": "2026-07-20",
      "uniqueJobCode": "job_20260420203044_IKOIF3YYMALSH5DP",
      "employmentType": "FULL_TIME",
      "hiringOrganization": {
        "logo": "https://s3.amazonaws.com/resumator/customer_20240412171514_NEYRQE15QC7M68W5/logos/20250626143202_merged_logo.png",
        "name": "Nationwide IT Services",
        "@type": "Organization",
        "sameAs": "https://www.nw-its.com/"
      },
      "experienceRequirements": "Experienced"
    }
  },
  "list_job": {
    "id": "KgypdyJsnk",
    "title": "Data Warehouse Subject Matter Expert (SME)",
    "detailUrl": "https://nationwideitservices.applytojob.com/apply/jobs/details/KgypdyJsnk?&"
  },
  "detail_errors": []
}