Data Engineer / Systems Architect

E Logic•Washington D.C., DC

4d•Hybrid

About The Position

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.

Requirements

Bachelor's degree in Computer Science, Information Systems, Data Engineering, or related field preferred; equivalent experience accepted
Minimum three (3) years of comprehensive experience in enterprise data engineering, cloud architecture, and DoD systems integration
U.S. Citizenship required
Favorably adjudicated Tier 1 (or higher) investigation required at time of contract award; must be eligible for Common Access Card (CAC)
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
Must meet DoD 8140 / DCWF foundational qualification for the assigned work role (e.g., Data Analyst 421 or Database Administrator 451) at commencement of work or within the allowed compliance window
Excellent technical writing, documentation, and communication skills; ability to work independently and collaboratively in a hybrid environment
Ability to obtain and maintain access to IL5 environments; willingness to work the required hybrid schedule
Must complete all mandatory DoD cybersecurity training (Cyber Awareness Challenge, etc.) prior to network access
Must comply with all IL5, CUI, Privacy Act, and PII/PHI handling requirements
Must wear contractor identification badge at all times while onsite
All work performed within the DoD Information Network (DoDIN) IL5 boundary

Responsibilities

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.