Data Integration Architect Full Time

Location: Washington, DC, US

Date Posted: 2026-04-20

Category: Information Technology

Subcategory: Cloud Comp Engr

Schedule: Full-Time

Shift: Day Job

Travel: No

Minimum Clearance Required: Secret

Clearance Level Must Be Able to Obtain: Top Secret

Potential for Remote Work: ORA_HYBRID

Description

The Vanguard 2025 program currently has an opening for a Data Integration Architect supporting the Department of State (DoS) Infrastructure Management (IM). This individual will be instrumental in engineering and leading the Data Center Infrastructure Management (DCIM) initiative for the Hosted Infrastructure (HI) division.

Vanguard 2025 deploys, maintains and integrates multiple enterprise systems for various IM organizations. These systems range from commercial-of-the-shelf to homegrown and are distributed throughout the wide area network.

The candidate must demonstrate experience with information and data architecture to include processing of structured and unstructured data. Familiarity with standard data models and the transformation of data between them is essential. The candidate will be responsible for identifying system requirements along with designing and implementing solutions.

This role is hybrid. 4 days onsite and 1 day remote.

Description of Duties:

• Prototype and implement data schemas.
• Create database tables, views, functions, stored procedures and jobs.
• Connect to various data sources to read, import and or export data.
• Create scripts to combine and or transform data.
• Evaluate and enforce data integrity.
• Visualize data.
• Integrate data into various frontend applications.
• Create flat files.
• Implement and secure applications.
• Support cybersecurity requirements (e.g. ATO process).

Qualifications

Required Education & Experience:

• 14 years of IT experience with a bachelor’s degree in engineering, CS, Information Management or related technical field; 12 years experience with a master’s degree; additional 5 years IT experience in lieu of degree.
• 5 or more years of experience in configuration management of IT network and server systems.
• 3 or more years of experience analyzing network management performance and capacity data.
• 5 or more years of experience as a software developer, at least 3 of which are supporting a Windows environment (e.g., .NET Framework, C#, Visual Basic, PowerShell, etc.).
• 5 or more years of experience with a relational database management system such as Microsoft SQL Server or Oracle Database.

Required Clearance:

• ship.
• Active secret clearance with ability to obtain a top secret clearance.

Target salary range: $160,001 – $200,000. The estimate displayed represents the typical salary range for this position based on experience and other factors.