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 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 ResponsibilitiesLead 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 QualificationsActive 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 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 RangeThe 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**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 https://www.thinktekllc.com/careers/.