Data Warehouse Architecture
Data Warehouse Management
Microsoft SQL Server Administration
Own your opportunity to work alongside federal civilian agencies. Make an impact by providing services that help the government ensure the well being and support of U.S. citizens.
Advance how our customers operate while you advance your career. Join GDIT as a Data Warehouse Subject Matter Expert (SME) and build an impactful career in enterprise IT, collaborating with people who are driven and resourceful like you. Our federal customer relies on this program to operate and modernize a nationwide case‑management and intelligence‑analysis platform supporting complex investigative and operational workflows. The team sustains a mission‑critical system that integrates data, analytics, and organizational processes across multiple regions to ensure a secure, scalable, and efficient platform for case management, trend analysis, and coordinated activities.
Meaningful Work and Personal Impact
• Lead the Enterprise Data Warehouse (EDW) team in modernization efforts
• Provide technical and management leadership on major tasks or technology assignments
• Establish goals and plans that meet project objectives and supervise others as required
• Apply expert domain and technical knowledge to influence project implementation
• Develop and deliver high‑quality data systems, reports, analytical products, and features
• Provide O&M support for existing data systems including the Enterprise Data Warehouse with multi‑source integrations and established extracts
• Support, update, and deliver enterprise reporting using PowerBI dashboards
• Design, develop, support, maintain, and enhance the Enterprise Search application integrating multiple sources, API capabilities, BI capabilities, and OpenSearch features
• Contribute to AI/ML module development, enhancement, research, and deployment for entity extraction and relationship mapping from unstructured datasets
• Support modernization of the agency’s data ecosystem using evolving Cloud and non‑Cloud technology stacks
• Adhere to Agile Scrum, Kanban, or other methodologies as directed by the customer
What You’ll Need to Succeed
An Active U.S. Government Secret Clearance or higher is required to be considered for this position.
REQUIRED SKILLS
• BA/BS degree or 4 additional years of equivalent work experience
• 15+ years of total database experience, including 12+ years of SQL Server experience
• Experience with SQL Server databases of at least 5 TB and one billion total rows
• 5+ years of experience with Agile development methodologies
• 3+ years of experience with MS tools such as SSIS, SSRS, SSAS, PowerBI, and ADO, as well as modern data management tools including Python, R, and Cloud services
• 3+ years of experience in Dimensional Analysis in a Kimball‑style Enterprise Data Warehouse with at least 500 total tables and one billion rows of data
GDIT IS YOUR PLACE: At GDIT, the mission is our purpose, and our people are at the center of everything we do.
• Growth: AI‑powered career tool that identifies career steps and learning opportunities
• Support: An internal mobility team focused on helping you achieve your career goals
• Rewards: Comprehensive benefits and wellness packages, 401K with company match, and competitive pay and paid time off
• Community: Award‑winning culture of innovation and a military‑friendly workplace
OWN YOUR OPPORTUNITY
Explore an enterprise IT career at GDIT and you’ll find endless opportunities to grow alongside colleagues who share your desire to drive operations forward.
15 + years of related experience
* may vary based on technical training, certification(s), or degree
Less than 10%
U.S. Citizenship Required
The likely salary range for this position is $142,792 - $189,750. This is not, however, a guarantee of compensation or salary. Rather, salary will be set based on experience, geographic location and possibly contractual requirements and could fall outside of this range.
View information about benefits and our total rewards program.
As part of the hiring process, we will ask you to complete an identity verification process that leverages advanced biometrics and artificial intelligence to ensure authenticity and protect against identity fraud. You are expected to be on camera during virtual interviews. We reserve the right to take your picture to verify your identity and prevent fraud. By proceeding, you authorize the collection, processing, and use of your biometric data for identity verification and security purposes.
We are GDIT. A global technology and professional services company that delivers technology solutions and mission services to every major agency across the U.S. government, defense and intelligence community. Our 26,000 experts extract the power of technology to create immediate value and deliver solutions at the edge of innovation. We operate across 50+ countries worldwide, offering leading mission-ready capabilities in AI, cloud, cyber and software development.
Join our Talent Community to stay up to date on our career opportunities and events at gdit.com/tc.
Equal Opportunity Employer / Individuals with Disabilities / Protected Veterans