Data Warehouse SME

Data Warehouse SME (Secret Clearance)

Who We Are:
ThinkTek 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. ThinkTek was formed with the specific purpose of providing its clients a tailored solution around Program & Project Management Strategic Planning and IT Operations.

Position Overview

The 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.

Required Qualifications

• Active Secret Clearance.
• Bachelors 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 of 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 $180846 $220798. 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**

ThinkTek 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. ThinkTek 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 ThinkTek benefits at