Data Engineer / Systems Architect (Camp Murray, WA)
About The Position
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.
Requirements
- A minimum of three (3) years of comprehensive experience in enterprise data engineering, cloud architecture, and DoD systems integration.
- A minimum of a Secret security clearance
- Demonstrated proficiency in backend data transformation, API pipeline development, and relational database modeling within DoD IL5 environments.
- Deep, demonstrable hands-on expertise operating natively within all three of 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.
- U.S. Citizenship is Required.
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.
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
Stand Out From the Crowd
Upload your resume and get instant feedback on how well it matches this job.
What This Job Offers
Job Type
Full-time
Career Level
Senior
Education Level
No Education Listed
