Data Warehouse SME
Listed on 2026-07-19
-
IT/Tech
Data Warehousing, Data Engineering, Database Administrator
Data Warehouse SME (Secret Clearance)
Think Tek LLC is a fast-growing Certified SBA 8(a) and Service-Disabled Veteran-Owned Small Business (SDVOSB) company. We specialize in providing management and technology consulting services to support the business and technology modernization efforts of the Federal Government. Think Tek was formed with the specific purpose of providing its clients a tailored solution around Program & Project Management, Strategic Planning, and IT Operations.
Position OverviewThe Data Warehouse SME serves as the Enterprise Data Warehouse (EDW) Team Lead responsible for the design, development, optimization, and operational support of large-scale SQL Server data warehouse environments supporting Concorde. This role provides technical leadership for enterprise reporting, business intelligence, and data integration efforts while ensuring scalability, reliability, and performance of mission-critical databases.
Key Responsibilities- Lead the Enterprise Data Warehouse development team.
- Design, maintain, and optimize enterprise-scale SQL Server data warehouse solutions.
- Develop dimensional models and enterprise reporting structures following Kimball methodology.
- Oversee ETL development, data integration, and data quality processes.
- Support Operations & Maintenance activities for production data warehouse environments.
- Optimize database performance, indexing strategies, partitioning, and query execution.
- Collaborate with application developers, analysts, and business stakeholders.
- Implement Agile development practices and participate in sprint planning and backlog refinement.
- Support cloud modernization and enterprise reporting initiatives.
- Mentor technical staff and establish database development best practices.
- Active Secret Clearance.
- Bachelor's degree in Computer Science, Information Systems, or related discipline (or equivalent experience).
- 15+ years of database experience.
- 12+ years of Microsoft SQL Server experience.
- Experience supporting SQL Server databases exceeding 5 TB and one billion rows of data.
- 5+ years working within Agile development environments.
- 3+ years experience with SSIS, SSRS, SSAS, Power BI, ADO, Python, R, and cloud-based data technologies.
- 3+ years designing Kimball-style Enterprise Data Warehouses consisting of 500+ tables and enterprise-scale datasets.
- Strong database performance tuning and optimization experience.
Pay Range
The anticipated annual salary range for this position is $180,846 – $220,798. This range is a good‑faith estimate and not a guarantee of compensation. Final compensation will be based on factors including experience, education, skills, geographic location, internal equity, market data, and applicable contract requirements, and may fall outside the posted range.
THIS POSITION IS CONTINGENT UPON CONTRACT AWARD
Think Tek LLC is proud to be an Equal Opportunity Employer (EOE), making decisions without regard to race, color, religion, creed, sex, sexual orientation, gender identity, marital status, national origin, age, veteran status, disability, or any other protected class. Think Tek offers medical, dental, and vision insurance to all full‑time employees; PTO and a variety of other paid leave options are also available.
You can read more about Think Tek benefits at
(If this job is in fact in your jurisdiction, then you may be using a Proxy or VPN to access this site, and to progress further, you should change your connectivity to another mobile device or PC).