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 ...
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 ...
SQL Server Data Modeler
Jacksonville, FL ยท On-site
$50.75 - $65.75/hr
Develops database and warehousing designs across multiple platforms and computing environments ... Experience with: - SQL Server Integration Services (SSIS) - SQL Server Reporting Services (SSRS ...
SQL Server Data Modeler
Jacksonville, FL ยท On-site
$50.75 - $65.75/hr
Develops database and warehousing designs across multiple platforms and computing environments ... Experience with: - SQL Server Integration Services (SSIS) - SQL Server Reporting Services (SSRS ...
SQL Server Data Modeler
Jacksonville, FL ยท On-site
$50.75 - $65.75/hr
Develops database and warehousing designs across multiple platforms and computing environments ... Experience with: - SQL Server Integration Services (SSIS) - SQL Server Reporting Services (SSRS ...
SQL Server Data Modeler
Jacksonville, FL ยท On-site
$50.75 - $65.75/hr
Develops database and warehousing designs across multiple platforms and computing environments ... Experience with: - SQL Server Integration Services (SSIS) - SQL Server Reporting Services (SSRS ...
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 ...
Quick apply
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 ...
... data to enterprise-level data warehouses and data mart databases. โข Use various containers, tasks, transformations, connection managers, script task to develop SSIS packages. โข Gather ...
... data to enterprise-level data warehouses and data mart databases. โข Use various containers, tasks, transformations, connection managers, script task to develop SSIS packages. โข Gather ...
SQL Server Data Modeler
Jacksonville, FL ยท On-site
$50.75 - $65.75/hr
Develops database and warehousing designs across multiple platforms and computing environments ... Experience with: - SQL Server Integration Services (SSIS) - SQL Server Reporting Services (SSRS ...
SQL Server Data Modeler
Jacksonville, FL ยท On-site
$50.75 - $65.75/hr
Develops database and warehousing designs across multiple platforms and computing environments ... Experience with: - SQL Server Integration Services (SSIS) - SQL Server Reporting Services (SSRS ...
SQL Server Data Modeler
Jacksonville, FL ยท On-site
$50.75 - $65.75/hr
Develops database and warehousing designs across multiple platforms and computing environments ... Experience with: - SQL Server Integration Services (SSIS) - SQL Server Reporting Services (SSRS ...
SQL Server Data Modeler
Jacksonville, FL ยท On-site
$50.75 - $65.75/hr
Develops database and warehousing designs across multiple platforms and computing environments ... Experience with: - SQL Server Integration Services (SSIS) - SQL Server Reporting Services (SSRS ...
SIRITECH SOLUTIONS CORP is seeking an experienced Senior SSIS/SSAS Data Warehouse Developer to support enterprise data warehouse and business intelligence initiatives. The role involves maintaining ...
SIRITECH SOLUTIONS CORP is seeking an experienced Senior SSIS/SSAS Data Warehouse Developer to support enterprise data warehouse and business intelligence initiatives. The role involves maintaining ...
SQL Server DBA
Redwood City, CA ยท On-site
$50 - $62/hr
The position is also responsible for the ongoing development and support of the SQL Server data warehouse, including operational readiness, data loads, and data modeling to support multiple ...
SQL Server DBA
Redwood City, CA ยท On-site
$50 - $62/hr
The position is also responsible for the ongoing development and support of the SQL Server data warehouse, including operational readiness, data loads, and data modeling to support multiple ...
SQL Server DBA
Redwood City, CA ยท On-site
$50 - $62/hr
The position is also responsible for the ongoing development and support of the SQL Server data warehouse, including operational readiness, data loads, and data modeling to support multiple ...
SQL Server DBA
Redwood City, CA ยท On-site
$50 - $62/hr
The position is also responsible for the ongoing development and support of the SQL Server data warehouse, including operational readiness, data loads, and data modeling to support multiple ...
... data dictionaries and warehousing requirements. This position optimizes database access and ... SCDMV SUPPORTS IN THE NEIGHBORHOOD OF 100 PLUS SQL SERVER DATABASES AND ARE IN THE PROCESS OF ...
... data dictionaries and warehousing requirements. This position optimizes database access and ... SCDMV SUPPORTS IN THE NEIGHBORHOOD OF 100 PLUS SQL SERVER DATABASES AND ARE IN THE PROCESS OF ...
Azure Data Lead
Clearwater, FL ยท On-site
SQL Server Data Warehouse - 8 years * Data Modeling - 5 years Responsibilities * You are an expert in Azure Data Analytics having a thorough understanding of Azure Data Platform tools. * Expertise ...
Azure Data Lead
Clearwater, FL ยท On-site
SQL Server Data Warehouse - 8 years * Data Modeling - 5 years Responsibilities * You are an expert in Azure Data Analytics having a thorough understanding of Azure Data Platform tools. * Expertise ...
Data Warehouse/BI Developer 3 (805681)
Richmond, VA ยท On-site
$48.25 - $66/hr
HCL Global Systems Inc is seeking a Data Warehouse/BI Developer to enhance their data capabilities ... SQL Server data mart development -- Build and optimize tables, views, stored procedures, and ...
Data Warehouse/BI Developer 3 (805681)
Richmond, VA ยท On-site
$48.25 - $66/hr
HCL Global Systems Inc is seeking a Data Warehouse/BI Developer to enhance their data capabilities ... SQL Server data mart development -- Build and optimize tables, views, stored procedures, and ...
Principal-Data Architect
Charlotte, NC ยท On-site
Charlotte, NC (Hybrid role 3 days/week from day1) A SQL Server Data Warehouse Architect designs and optimizes enterprise level data storage solutions mapping business needs to technical architectures ...
Principal-Data Architect
Charlotte, NC ยท On-site
Charlotte, NC (Hybrid role 3 days/week from day1) A SQL Server Data Warehouse Architect designs and optimizes enterprise level data storage solutions mapping business needs to technical architectures ...
Principal-Data Architect
Charlotte, NC ยท On-site
Charlotte, NC (Hybrid role 3 days/week from day1) A SQL Server Data Warehouse Architect designs and optimizes enterprise level data storage solutions mapping business needs to technical architectures ...
Principal-Data Architect
Charlotte, NC ยท On-site
Charlotte, NC (Hybrid role 3 days/week from day1) A SQL Server Data Warehouse Architect designs and optimizes enterprise level data storage solutions mapping business needs to technical architectures ...
Senior Data Engineer - Remote
Westmont, IL ยท Remote
$106K - $144K/yr
Experience with Snowflake, Azure SQL Server, Data Warehouse, Power App and Data Factory a plus * Knowledge and experience implementing ETL design patterns for data warehousing including Kimball ...
Senior Data Engineer - Remote
Westmont, IL ยท Remote
$106K - $144K/yr
Experience with Snowflake, Azure SQL Server, Data Warehouse, Power App and Data Factory a plus * Knowledge and experience implementing ETL design patterns for data warehousing including Kimball ...
SENIOR SQL SERVER DATABASE DEVELOPER / DATA ENGINEER
Norco, CA ยท On-site
$130K - $175K/yr
Design, develop, and maintain SQL Server databases, tables, views, stored procedures, functions ... Develop and maintain Data Warehouse and Data Mart solutions utilizing dimensional modeling and star ...
Quick apply
SENIOR SQL SERVER DATABASE DEVELOPER / DATA ENGINEER
Norco, CA ยท On-site
$130K - $175K/yr
Design, develop, and maintain SQL Server databases, tables, views, stored procedures, functions ... Develop and maintain Data Warehouse and Data Mart solutions utilizing dimensional modeling and star ...
SSIS Developer
Florham Park, NJ ยท On-site
NYC; Charlotte, NC ROLE SUMMARY AND RESPONSIBILITIES The ETL Developer will be primarily responsible for developing and supporting ETL code in SSIS for an enterprise data warehouse. ROLE ...
SSIS Developer
Florham Park, NJ ยท On-site
NYC; Charlotte, NC ROLE SUMMARY AND RESPONSIBILITIES The ETL Developer will be primarily responsible for developing and supporting ETL code in SSIS for an enterprise data warehouse. ROLE ...
Senior Data Engineer
Tulsa, OK ยท On-site +1
$96K - $131K/yr
In this role, you will build new data pipelines and warehouse models in Snowflake while partnering with our existing SQL Server Data Engineering team to migrate legacy systems to the cloud. You will ...
Senior Data Engineer
Tulsa, OK ยท On-site +1
$96K - $131K/yr
In this role, you will build new data pipelines and warehouse models in Snowflake while partnering with our existing SQL Server Data Engineering team to migrate legacy systems to the cloud. You will ...
Creates database coding requirements for data warehouse data migrations and business unit and SQL server projects via programming and the various SQL languages. * Identifies and resolves data ...
Quick apply
Creates database coding requirements for data warehouse data migrations and business unit and SQL server projects via programming and the various SQL languages. * Identifies and resolves data ...
Sql Server Data Warehouse information
See salary details
$10.34 - $16.26
1% of jobs
$16.26 - $22.18
0% of jobs
$22.18 - $28.10
0% of jobs
$28.10 - $34.03
2% of jobs
$34.03 - $39.95
2% of jobs
$39.95 - $45.87
4% of jobs
$45.87 - $51.79
13% of jobs
$52.24 is the 25th percentile. Wages below this are outliers.
$51.79 - $57.71
38% of jobs
$61.93 is the 75th percentile. Wages above this are outliers.
$57.71 - $63.64
21% of jobs
$63.64 - $69.56
8% of jobs
$69.56 - $75.48
11% of jobs
$10
$57
$75
How much do sql server data warehouse jobs pay per hour?
What are some typical challenges faced by SQL Server Data Warehouse professionals when working with large data sets?
What is a SQL Server Data Warehouse?
What is the difference between Sql Server Data Warehouse vs Data Analyst?
| Aspect | Sql Server Data Warehouse | Data Analyst |
|---|---|---|
| Primary Role | Designing, developing, and managing data storage solutions for reporting and analysis | Interpreting data, creating reports, and providing insights for decision-making |
| Required Skills | SQL, ETL processes, data modeling, database management | SQL, data visualization, statistical analysis, reporting tools |
| Work Environment | Data warehouses, database servers, enterprise data systems | Business units, analytics teams, reporting platforms |
| Certifications | Microsoft Certified: Data Engineer, SQL Server certifications | Microsoft Certified: Data Analyst Associate, relevant analytics certifications |
While a Sql Server Data Warehouse focuses on building and maintaining data storage systems, a Data Analyst interprets and analyzes data to generate insights. Both roles require SQL skills and often collaborate, but their core responsibilities differ significantly.
What are the key skills and qualifications needed to thrive as a SQL Server Data Warehouse professional, and why are they important?

Full-time
Posted 25 days ago
Job description
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.
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.
About Nationwide IT Services
Sourced by ZipRecruiter
Industry
It services
Company size
51 - 200 Employees
Headquarters location
Alexandria, VA, US
Year founded
2006