Data Warehouse Subject Matter Expert (SME)

Nationwide IT Services, Inc • $120K — $150K *
Arlington, VA 22204In-Person
Enterprise Technology
11 - 15 years of experience
2 months ago
Job Overview by Ladders

Qualifications

  • 15+ years total database experience
  • 12+ years SQL Server experience
  • Experience with SQL Server databases of at least 5 TB
  • 5+ years in Agile development methodologies
  • 3+ years with Microsoft tools (SSIS, SSRS, SSAS, Power BI, ADO)
  • 3+ years performing dimensional analysis in a Kimball-style Enterprise Data Warehouse
  • Secret Clearance required

Responsibilities

  • Serve as the SME for enterprise data warehouse architecture and design
  • Provide expertise in large-scale SQL Server environments
  • Design and optimize enterprise data warehouse solutions using dimensional modeling
  • Lead development of fact and dimension structures within large data environments
  • Enhance ETL/ELT pipelines and reporting solutions using Microsoft data tools
  • Utilize modern technologies to improve analytics and data processing
  • Collaborate with teams using Agile methodologies for data solutions
  • Analyze requirements and troubleshoot complex database issues
  • Ensure scalable and maintainable data warehouse solutions

Benefits

  • 100% on-site work arrangement
  • Engage in high-profile enterprise data projects
  • Opportunity to work with advanced data management technologies
  • Collaborative environment in Agile settings
  • Exposure to complex, high-volume data challenges
Full Job Description
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.

100% on-site
Secret Clearance required.

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.

About Nationwide IT Services, Inc

Nationwide IT Services, Inc Careers

There has never been a better time to join the dynamic team at Nationwide IT Services, Inc—the leading provider of innovative IT solutions.

Work You’ll Do

Join Nationwide IT Services, Inc's top-tier team to assist some of the most prestigious companies in navigating their digital transformation journeys. This is where innovation meets real-world application, enabling businesses across various sectors to achieve groundbreaking success. Nationwide IT Services, Inc stands at the forefront of technology, industry expertise, and digital innovation, offering a unique position in the marketplace. Collaborate with a team of business and technology advisors who are dedicated to guiding clients through their IT challenges and transformations. Engage with a diverse group of professionals in a culture that champions leadership, diversity training, and professional growth.

Introducing the Nationwide IT Services, Inc Professional Growth and Innovation Hub

The hub is dedicated to fostering a market-leading environment where the most well-known companies receive guidance on mastering their digital transformation challenges with cutting-edge solutions.

Do Innovative Work

Be part of the largest network of technology experts, where 20,000+ dedicated professionals work at the intersection of technology and practical industry application.

Drive Innovation and Leadership

Deliver targeted IT solutions through a depth and breadth of consulting experience that is unmatched in the industry.

Be Part of a Great Team

Join a team that leverages extensive technology to provide unparalleled capabilities and comprehensive solutions.

Future-Proof Your Career

Nationwide IT Services, Inc offers limitless opportunities to advance your career, supported by unmatched training, development, and certification programs.

Explore Job Opportunities

Nationwide IT Services, Inc is moving towards more predictive and proactive IT management solutions, enhancing client systems and operational capabilities.

The Nationwide IT Services, Inc Commitment to Excellence

With a focus on overcoming industry disruptions and leading transformation projects, Nationwide IT Services, Inc helps clients innovate and grow in the digital age. The combined service capabilities and global scale foster an environment ripe for innovation and leadership.

Stay Connected

Join the Team

Search open positions that match your skills and interests. Nationwide IT Services, Inc looks for passionate, curious, creative, and solution-driven team players. SEARCH NATIONWIDE IT SERVICES JOBS

Keep Up to Date

Stay informed with career tips, insider perspectives, and industry-leading insights you can put to use today—all from the professionals who work at Nationwide IT Services, Inc.

READ CAREERS BLOG

Job Alert Emails

Customize your subscription to receive job alerts, the latest news, and insider tips tailored to your preferences. Discover the exciting and rewarding career opportunities that await at Nationwide IT Services, Inc.
Learn more about Nationwide IT Services, Inc
Industry
Information Technology
* Ladders Estimates

Similar Jobs

Ad banner background

Get Ready For Your
Next Interview

More Jobs at Nationwide IT Services, Inc

More Enterprise Technology Jobs

Find similar Data Warehouse Subject Matter Expert (SME) jobs:

NationwideArlington, VA