Data Engineer​/Systems Architect

Location: Hybrid - approximately 25% onsite at Building 32, Camp Murray, WA / 75% telework (Army Virtual Desktop)

Clearance: Must possess a favorably adjudicated Tier 1 (or higher) investigation at time of award; U.S. Citizenship required; CAC eligibility

Job Type: Full-time

Contract Type: Government Contract (Base Year + 1 Option Year)

We are seeking an experienced Data Engineer / Systems Architect to support the Washington National Guard's Advana and Army Vantage Data Engineering and A365 Dataverse Foundation effort. This role is responsible for designing, building, and sustaining secure data transformation pipelines within Army Vantage (Palantir Foundry) and Advana (Databricks/SQL), egressing curated data into Microsoft Dataverse (Army 365), and establishing a robust relational data foundation for downstream Power Apps and dashboards.

The ideal candidate has deep, hands‑on experience operating natively in DoD IL5 environments, strong relational data modeling skills, and the ability to deliver high‑quality technical documentation and operational support. This is a non-personal services contract position. The contractor employee reports directly to the Prime Contractor for all human resources, disciplinary, and administrative matters, while receiving technical direction and prioritization from the Government COR.

• Conduct comprehensive data discovery and assessment of existing datasets in Army Vantage and Advana; deliver the Data Discovery and Assessment Report.
• Design and implement automated, high‑availability ETL pipelines using native tools (Palantir Foundry Pipeline Builder, Databricks, SQL).
• Cleanse, deduplicate, harmonize, and apply Master Data Management best practices to source data.
• Develop and maintain a localized data ontology / star‑schema model optimized for Microsoft Power Platform consumption.
• Engineer, test, and sustain secure automated egress connections (REST API, OData, or approved connectors) into the Army 365 Dataverse environment.
• Implement and enforce Role‑Based Access Control (RBAC), Row‑Level Security (RLS), and Object‑Level Security (OLS) in compliance with IL5 requirements.
• Build automated validation and reconciliation scripts; maintain Data Quality Logs and transformation lineage documentation.
• Produce and maintain the Data Dictionary, Entity‑Relationship Diagrams (ERDs), Security & Access Control Plan, and Data Validation/Test Plan.
• Provide ongoing operational support for pipelines (99.5% uptime target; 4‑hour resolution SLA for critical interruptions during service hours).
• Participate in National Guard Bureau (NGB) data governance and synchronization working groups; prepare after‑action reports.
• Deliver technical support and knowledge transfer to Government and third‑party teams developing Power Apps and dashboards.
• Prepare monthly status reports and all required contractual deliverables on schedule.

Requirement Details Education Bachelor 's degree in Computer Science, Information Systems, Data Engineering, or related field preferred; equivalent experience accepted

Experience

Minimum three (3) years of comprehensive experience in enterprise data engineering, cloud architecture, and DoD systems integration

CitizenshipU.S. Citizenship required

Security

Favorably adjudicated Tier 1 (or higher) investigation required at time of contract award; must be eligible for Common Access Card (CAC)
Technical Skills Demonstrated hands‑on expertise in Army Vantage (Palantir Foundry), Advana (Databricks/SQL), and Microsoft Dataverse (A365) backend; strong skills in ETL pipeline development, relational/star‑schema modeling, API development, and data lineage tracking

Cyber Workforce Must meet DoD 8140 / DCWF foundational…