Find Jobs
Find Jobs Near You – Available Work in Your Location
Skip to job details
GD
General Dynamics Information Technology
Data Warehouse Subject Matter Expert
Career Insights for Data Architect
See where this job fits in the broader career landscape. Knowing your career path helps you see what's possible from here.
Scorecard
Based on Virginia data
Review key factors to help you decide if this role fits your goals. How is this calculated?
What they do
A Data Architect develops computer databases for a company or organization. Designs, builds and implements databases and database systems that meet business requirements. Supports database administration, develops database security policies and works to prevent cyber attacks.
$152,527 / year median in Virginia
-6% projected decline
Job Description
Location:
USA VA Fairfax Full Part/Time:
Full timeJob Req:
RQ223948
Type of Requisition:
Regular Clearance Level Must Currently Possess:
Secret Clearance Level Must Be Able toObtain:
Secret Public Trust/Other Required:
None Job Family:
Data Science and Data Engineering Job Qualifications:
Skills:
Data Warehouse Architecture, Data Warehouse Management, Microsoft SQL Server Administration Certifications:
None Experience:
15 + years of related experienceUS Citizenship Required:
Yes Job Description:
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.
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