> Markdown version of [/jobs/ext/3292808-data-engineer-systems-architect-camp-murray-wa](https://www.wearedevelopers.com/jobs/ext/3292808-data-engineer-systems-architect-camp-murray-wa). Every page supports `.md` or `Accept: text/markdown`. Links point to the HTML versions so they work for humans too. Agent guide: [/agents.md](https://www.wearedevelopers.com/agents.md). --- # Data Engineer / Systems Architect (Camp Murray, WA) - **Company:** Praescient Analytics - **Location:** Camp Murray, WA, United States (Remote available) - **Experience:** Experienced - **Salary:** $90,000.0 - $160,000.0 - **Contract:** Permanent contract - **Skills:** Application Programming Interfaces (APIs), Data Analysis, Cloud Engineering, System Configuration, Data Dictionary, Data Integration, Data Integrity, Extract Transform Load (ETL), Data Transformation, Data Security, Data Structures, Relational Databases, Entity Relationship Models, Power BI, SQL Databases, Systems Integration, Data Processing, Backend, Front End Software Development, Data Pipelines, Powerapps, Databricks - **Published:** September 9, 2026 - **Apply:** https://www.clearancejobs.com/jobs/9151195/data-engineer-systems-architect-camp-murray-wa ## About the Role * A minimum of three (3) years of comprehensive experience in enterprise data engineering, cloud architecture, and DoD systems integration. ## Description 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 employee shall provide services between the hours of 0600 - 1430 (Pacific Time) on Monday through Friday except on recognized US holidays or 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)., * 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., * 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. 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 ## Related Videos - [DB UX Design System – How we’ve open sourced our largest inner source project](https://www.wearedevelopers.com/videos/819-db-ux-design-system-how-we-ve-open-sourced-our-largest-inner-source-project) - [Beyond Dashboards: Fixing Text-to-SQL with Semantic RAG](https://www.wearedevelopers.com/videos/2036-beyond-dashboards-fixing-text-to-sql-with-semantic-rag) - [Developing the Backend with Stefan Lingler, CTO at Shpock](https://www.wearedevelopers.com/videos/100360-developing-the-backend-with-stefan-lingler-cto-at-shpock) - [Modern Data Architectures need Software Engineering](https://www.wearedevelopers.com/videos/1030-modern-data-architectures-need-software-engineering) - [Data Analytics with Microsoft Fabric: End-to-End Use Case with Data Agents](https://www.wearedevelopers.com/videos/1547-data-analytics-with-microsoft-fabric-end-to-end-use-case-with-data-agents) - [REST, GraphQL, gRPC, and more: A comparison of modern API styles](https://www.wearedevelopers.com/videos/100247-rest-graphql-grpc-and-more-a-comparison-of-modern-api-styles) ## Related Articles - [Highest Paying Tech Companies for Developers](https://www.wearedevelopers.com/magazine/220-highest-paying-tech-companies-for-developers) - [Making Data Warehouses Fast: A Developer’s Story](https://www.wearedevelopers.com/magazine/107-making-data-warehouses-fast-a-developer-s-story) - [Data Engineer Salary UK](https://www.wearedevelopers.com/magazine/253-data-engineer-salary-uk) - [Dev Digest 162: AI careers, MCP, AWS best practices & floppy sweaters](https://www.wearedevelopers.com/magazine/571-dev-digest-162-ai-careers-mcp-aws-best-practices-floppy-sweaters) - [Top Big Data Technologies That You Need to Know](https://www.wearedevelopers.com/magazine/108-top-big-data-technologies-that-you-need-to-know) - [Best Coding Boot Camps in Germany](https://www.wearedevelopers.com/magazine/237-best-coding-boot-camps-in-germany)