Data Engineer / Systems Architect (Hybrid)

Praescient Analytics; Lakewood (WA); Hybrid; USD 90,000 - 160,000; Full time

Benefits offered by this job

Competitive salary

Company-paid healthcare

401(k) match

Travel incentives

Paid time off

Training allowance

Job summary

Praescient Analytics is seeking a Data Engineer / Systems Architect to support the Washington National Guard’s enterprise data integration efforts. The role focuses on backend pipelines, data models, and secure data foundations within Army 365 and Microsoft Dataverse, with a hybrid work arrangement.

You will build and sustain transformation pipelines using Palantir Foundry, Databricks, and SQL, implement RBAC and IL5 security, coordinate with government stakeholders, and deliver clear

Qualifications

• 3+ years in enterprise data engineering, cloud architecture, and DoD integration.
• Secret security clearance required.
• Experience with backend data transformation and API pipelines in DoD IL5 environments.
• Proficient with Palantir Foundry, Advana, Databricks, SQL, and Microsoft Dataverse.

Responsibilities

• Assess datasets in Army Vantage and Advana and document structures, data quality, and gaps.
• Develop native data transformation pipelines using Palantir Foundry, Databricks, and SQL.
• Engineer secure API and ETL connections to Dataverse (A365).
• Design Dataverse tables with keys and relationships for downstream Power Apps/Power BI.
• Configure DoD-approved authentication and scheduled synchronization; monitor pipelines.

Skills

Backend data pipelines

API development

Relational DB modeling

Data quality & validation

Security controls

Documentation

Data engineering

Tools

Palantir Foundry

Databricks

SQL

Microsoft Dataverse

Army Vantage

A365

Job description

Location: Camp Murray, Washington State (Hybrid)
Job Type: Full-Time
Clearance Requirement: Secret Clearance
U.S.Citizenship is Required.

Praescient Analytics is seeking a Data Engineer / Systems Architect to support the Washington National Guard’s enterprise data integration efforts. This position will transform data within Army Vantage and Advana and establish a secure, relational data foundation within Army 365 (A365) Microsoft Dataverse.

You will develop and sustain backend pipelines, architect data models, enforce access controls, and validate data integrity to support Government teams developing Power Apps and Power BI solutions. This is a hands‑on engineering and architecture role focused on backend integration; frontend dashboard development is outside the position’s scope.

This employeeshall provide services between the hours of 0600 - 1430 (Pacific Time) on Monday through Friday except on recognized US holidaysor when the Government facility/installation is closed.Work under this contract shall be performed on a hybrid basis, split between the designated Government facility and approved telework locations (approximately 25% in-person and 75% telework).

Responsibilities

• Assess available datasets within Army Vantage and Advana, documenting source structures, data quality, integration dependencies, and gaps.
• Develop native data transformation pipelines using Palantir Foundry, Databricks, and SQL to cleanse, join, aggregate, and harmonize enterprise data.
• Engineer and sustain secure, automated API and ETL connections that transfer curated data into A365 Microsoft Dataverse.
• Design Dataverse tables, primary and foreign keys, and one-to-many and many-to-many relationships optimized for downstream Power Apps and Power BI use.
• Configure Army-approved system-to-system authentication and scheduled synchronization; monitor pipeline performance and troubleshoot integration failures.
• Implement role-based access controls, row-level and field-level security, and appropriate protection of sensitive data within DoD Impact Level 5 (IL5) environments.
• Develop automated validation and reconciliation routines to detect missing records, schema discrepancies, failed jobs, and transformation errors.
• Maintain version-controlled code, transformation logs, data dictionaries, entity-relationship diagrams, and technical documentation.
• Coordinate with Government stakeholders and National Guard Bureau working groups to align data models and integration activities with enterprise requirements.
• Provide technical guidance and issue resolution to downstream application developers and document progress, risks, and pipeline health.

Required Qualifications

• A minimum ofthree (3)years of comprehensive experience in enterprise data engineering, cloud architecture, and DoD systems integration.
• Aminimum of aSecret security clearance
• Demonstrated proficiency in backend data transformation, API pipeline development, and relational database modeling withinDoD IL5 environments.
• Deep, demonstrable hands‑on expertise operating natively withinall threeof the following environments:
  • Army Vantage / Palantir Foundry: Building data pipelines, performing transformations, and working with platform data structures.
  • Advana / Databricks and SQL: Developing queries, transformation logic, joins, aggregations, and data-processing workflows.
  • Microsoft Dataverse / A365: Designing relational schemas, integrating data, configuring access controls, and supporting secure data egress and schema linkage.
• Ability to troubleshoot complex data integration issues and implement repeatable data‑quality and validation controls.
• Ability to produce clear technical documentation and communicate effectively with Government stakeholders and application developers.
• Ability to meet Government credentialing, platform‑access, and applicable cybersecurity workforce qualification requirements.

The projected compensation range for this position is $90,000.00 to $160,000.00 (annualized USD).

What You Can Expect From Us

• Real opportunity for career growth in an environment where your achievements will be celebrated
• Constant collaboration with numerous teams to ensure client success
• A team that respects and embraces your ideas and expertise
• Coworkers that are motivated by pursuing excellence, rather than the prospect of personal gain
• A workplace dedicated to supporting and bettering public safety and government agencies

Benefits

• Very competitive salary based on qualifications and experience
• Comprehensive, Company paid healthcare for you (We pay your premiums and deductibles)
• 401(k) with company match
• Travel & performance incentives
• 3 weeks paid time off (plus Federal Holidays)
• $5K annual training allowance

Praescient Analytics is a Certified Woman-Owned Small Business (WOSB) with over a decade of expertise in advanced analytics, engineering, and DevOps, specializing in transforming complex data into actionable intelligence for informed decision‑making. Since 2011, we have supported over 40 organizations across diverse domains, including military intelligence operations, financial and fraud investigations, and insider threat detection.

Our team of experts—skilled in cloud computing, artificial intelligence, machine learning, data science, DevOps, and engineering—brings deep experience in solving complex challenges. With a proven track record in federal contracting, we deliver tailored, high‑impact solutions designed to enhance operational efficiency, ensure mission success, and address the evolving needs of our clients. Praescient's innovative and adaptive approach makes us a trusted partner in delivering data‑driven insights and technological excellence for critical missions.