Back to Jobs search

Data Warehouse Subject Matter Expert

General Dynamics Information Technology • Fairfax, VA • 1h ago

Req ID: RQ223948

Type of Requisition: Regular

Clearance Level Must Be Able to Obtain: Secret

Public Trust/Other Required: None

Job Family: Data Science and Data Engineering

Skills:

Data Warehouse Architecture,Data Warehouse Management,Microsoft SQL Server Administration

Experience:

15 + years of related experience

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

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.

Our benefits package for all US-based employees includes a variety of medical plan options, some with Health Savings Accounts, dental plan options, a vision plan, and a 401(k) plan offering the ability to contribute both pre and post-tax dollars up to the IRS annual limits and receive a company match. To encourage work/life balance, GDIT offers employees full flex work weeks where possible and a variety of paid time off plans, including vacation, sick and personal time, holidays, paid parental, military, bereavement and jury duty leave. To ensure our employees are able to protect their income, other offerings such as short and long-term disability benefits, life, accidental death and dismemberment, personal accident, critical illness and business travel and accident insurance are provided or available. We regularly review our Total Rewards package to ensure our offerings are competitive and reflect what our employees have told us they value most.

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 https://gdit.com/tc.

Equal Opportunity Employer / Individuals with Disabilities / Protected Veterans

Similar Jobs

Web Application Developer (Magento/Adobe Commerce Experience Required)

Latitude Inc • Montgomery Village, MD • 1h ago

IT & Engineering

The organization operates a high-volume online marketplace focused on providing collectors and investors with a wide selection of items at competitive prices. As the company continues to scale, they are investing heavily...

1h ago

Go to Apply

Test & Evaluation Engineer

Latitude Inc • Manassas, VA • 1h ago

IT & Engineering

\n \n $30 - $35 an hour Latitude Inc. is on the lookout for an enthusiastic and driven Test & Evaluation Engineer Support Specialist. Key Responsibilities: As a Test & Evaluation Engineer, you'll play a pivotal...

1h ago

Go to Apply

Senior Endpoint Engineer

CACI International • Arlington, VA • 1h ago

IT & Engineering

Job Title: Senior Endpoint Engineer Job Category: Information Technology Time Type: Full time Minimum Clearance Required to Start: None Employee Type: Regular Percentage of Travel Required: None Type of Travel: None The...

1h ago

Go to Apply

Senior Security Engineer

NVR • Reston, VA • 1h ago

IT & Engineering

Senior Security Engineer Job Category Information Technology Market Location VA - Northern Virginia Location VA - Reston Apply Now ( https://phg.tbe.taleo.net/phg01/ats/careers/v2/applyRequisition?org=NVRINC&cws=52&a...

1h ago

Go to Apply

Oracle Applications Senior Principal Systems Analyst

General Dynamics Information Technology • Fairfax, VA • 1h ago

IT & Engineering

Req ID: RQ223868 Type of Requisition: Regular Clearance Level Must Be Able to Obtain: None Public Trust/Other Required: None Job Family: IT Infrastructure and Operations Skills: Business,Change Management,Data Migrations...

1h ago

Go to Apply

Systems Technician - TS/SCI W/ POLY (Open)

General Dynamics Information Technology • Washington, DC • 1h ago

IT & Engineering

Req ID: RQ223704 Type of Requisition: Regular Clearance Level Must Be Able to Obtain: Top Secret SCI + Polygraph Public Trust/Other Required: None Job Family: Technical Support Services Skills: Computer Systems,Informati...

1h ago

Go to Apply

Associate Quality Engineer

Marriott • Bethesda, MD • 1h ago

IT & Engineering

Additional Information Bethesda, MD Pay Range: $73,000-$115,000 annually Remote Pay Range: $66,000-$104,000 annually Job Number 26081036 Job Category Information Technology Location 7750 Wisconsin Ave, Bethesda, Maryland...

1h ago

Go to Apply

Cyber Security Engineer

ASRC Federal Holding Company • Alexandria, VA • 1h ago

IT & Engineering

ASRC Federal NetCentric Technology is seeking a Cyber Security Engineer to design, implement, and maintain advanced cybersecurity solutions that protect enterprise systems and networks from evolving cyber threats. This r...

1h ago

Go to Apply

Network Administrator

SAIC • Adelphi, MD • 1h ago

IT & Engineering

Description SAIC is seeking a Network Administrator with an understanding of enterprise network architecture, Layer 2/3 switching, routing protocols, and network security standards. You will be responsible for the instal...

1h ago

Go to Apply

Systems Administrator, Junior

COLSA Corporation • Quantico, VA • 1h ago

IT & Engineering

COLSA Corporation is seeking a Junior System Administrator in support of Marine Corps Information Operations Center (MCIOC) in Quantico, VA. This work supports USMC Operational Forces. General duties for the System Admin...

1h ago

Go to Apply

Subscribe to get new jobs sent directly to you
(no charge, cancel anytime)