Data Warehouse Subject Matter Expert

About the role

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.

Responsibilities

• 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
• 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
• Modernize 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

Requirements

• An Active U.S. Government Secret Clearance or higher is required to be considered for this position.
• A 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.

Qualifications

• 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