> Markdown version of [/jobs/ext/3388305-data-engineer-systems-architect-army-vantage-advana-dataverse](https://www.wearedevelopers.com/jobs/ext/3388305-data-engineer-systems-architect-army-vantage-advana-dataverse). 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 - Army Vantage, Advana & Dataverse - **Company:** Loyola Enterprises Incorporated - **Location:** Camp Murray, WA, United States (Remote available) - **Experience:** Experienced - **Salary:** $140,000.0 - **Contract:** Temporary contract - **Skills:** Microsoft Azure, Cloud Engineering, Information Systems, Data Cleansing, Data Deduplication, Information Engineering, Data Integration, Extract Transform Load (ETL), Data Transformation, Data Security, Relational Databases, Database Schema, Java Database Connectivity, Virtual Desktops, Open Data Protocol, Software Architecture, Role-Based Access Control, Power BI, Azure Active Directory, Standard Sql, SQL Databases, Systems Integration, Azure Data Factory, Backend, Git, Information Technology, Data Lineage, Performance Monitor, Data Management, Front End Software Development, Restful APIs, Data Pipelines, Powerapps, Databricks - **Published:** September 7, 2026 - **Apply:** https://www.indeed.com/viewjob?jk=1e5241646ec84437 ## About the Role Clearance: U.S. Citizenship required. Favorably adjudicated Tier 1 (T1)/NACI or equivalent/higher federal investigation required at contract award; must be eligible for a DoD CAC and Government system access. Requirement: Immediate hire, Full time, Full benefits Work week: 8 hrs/day, Monday-Friday, 0600-1430 Pacific Time; approximately 25% onsite / 75% telework. Temporary increased or 100% onsite support may be required. Work Location: Camp Murray / Tacoma, Washington Education: Bachelor's degree in Computer Science, Information Technology, Data Science, Engineering, Information Systems, Mathematics, or related technical discipline preferred. Applicable professional certification, military/federal training, or academic credentials may satisfy DoD workforce qualification requirements., * Minimum three (3) years of comprehensive experience in enterprise data engineering, cloud architecture, and DoD systems integration. * Demonstrated hands-on experience with Army Vantage / Palantir Foundry, Advana / Databricks / SQL, and Microsoft Dataverse / Army 365 (A365). * Experience designing, developing, testing, and sustaining automated ETL/data pipelines and secure system-to-system data integrations. * Strong SQL and relational data-modeling experience, including primary/foreign keys, one-to-many and many-to-many relationships, fact/dimension tables, star schemas, and ERDs. * Experience with REST APIs, OData, JDBC, Azure-native integration methods, or similar secure connectors. * Experience with data cleansing, harmonization, Master Data Management, automated validation, source-to-target reconciliation, and data-quality controls. * Knowledge of RBAC, Row-Level Security, Field-Level Security, and security requirements applicable to DoD IL5/CUI environments. * Experience with Git, Azure DevOps, or similar version-controlled repositories and ability to produce clear technical documentation., * Direct experience supporting Army Vantage and OSD Advana in a DoD environment. * Microsoft Dataverse / Power Platform backend architecture and Azure data-integration experience. * Experience configuring Non-Person Entity (NPE) or Service Principal authentication and Microsoft Entra ID security roles. * Experience handling PII/PHI and implementing masking, hashing, de-identification, and other data-protection controls. * Experience with automated pipeline monitoring, alerting, performance reporting, and production incident resolution. * Current CAC and familiarity with Army 365, Army Virtual Desktop (AVD), and DoD 8140 / DCWF requirements., * Do you have demonstrated hands-on experience with Army Vantage / Palantir Foundry, Advana / Databricks / SQL, and Microsoft Dataverse / Army 365 (A365) * Do you have experience with REST APIs, OData, JDBC, Azure-native integration methods, or similar secure connectors. * Do you have experience with RBAC, Row-Level Security, Field-Level Security, and security requirements applicable to DoD IL5/CUI environments. * Do you have experience with Git, Azure DevOps, or similar version-controlled repositories. ## Description Loyola Enterprises, Inc. is seeking a Data Engineer / Systems Architect to support a Department of Defense data engineering and systems integration program. The successful candidate will design, build, integrate, secure, and sustain enterprise data pipelines within DoD Impact Level 5 (IL5) environments. The position focuses on backend data engineering and architecture supporting Army Vantage, Advana, and Microsoft Dataverse/A365; it is not primarily a frontend Power Apps or Power BI dashboard-development position. Primary duties include: * Conduct discovery and assessment of Army Vantage and Advana datasets, schemas, table structures, data quality, update frequency, and technical dependencies. * Perform native data transformations, joins, calculations, aggregations, cleansing, deduplication, and harmonization in Vantage and Advana. * Design and sustain automated ETL and secure data-egress pipelines between Army Vantage/Advana and the Army Power Platform / Dataverse environment. * Architect relational Dataverse structures optimized for downstream Power Apps and Power BI consumption, including keys, relationships, star-schema models, and ERDs. * Maintain end-to-end data lineage and document transformations, rules, queries, code, and mappings in Government-accessible version-controlled repositories. * Implement RBAC, Row-Level Security, Field-Level Security, Entra ID-based controls, and applicable IL5 data-protection requirements. * Develop automated validation and reconciliation scripts that identify schema issues, unmatched records, failed jobs, data-integrity faults, and pipeline interruptions. * Monitor scheduled pipeline execution and troubleshoot production issues to meet required reliability, data-quality, and service-level standards. * Develop and maintain Data Dictionaries, ERDs, security matrices, transformation logs, validation/test plans, and required technical reports. * Participate in Government data-governance and synchronization working groups and provide technical support to Government and third-party developers consuming the Dataverse data environment. The selected candidate must complete and maintain all required Government cybersecurity, system-access, privacy, OPSEC, antiterrorism, and DoD 8140/DCWF training and qualification requirements. ## Related Videos - [Remote Driving on Plant Grounds with State-of-the-Art Cloud Technologies](https://www.wearedevelopers.com/videos/251-remote-driving-on-plant-grounds-with-state-of-the-art-cloud-technologies) - [How a Small Team Shrank a Microsoft Monorepo by 94%](https://www.wearedevelopers.com/videos/1236-how-a-small-team-shrank-a-microsoft-monorepo-by-94) - [Developing the Backend with Stefan Lingler, CTO at Shpock](https://www.wearedevelopers.com/videos/100360-developing-the-backend-with-stefan-lingler-cto-at-shpock) - [Beyond Dashboards: Fixing Text-to-SQL with Semantic RAG](https://www.wearedevelopers.com/videos/2036-beyond-dashboards-fixing-text-to-sql-with-semantic-rag) - [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) - [From Messy Queries to Scalable Systems - How Data Engineering actually works](https://www.wearedevelopers.com/videos/100203-from-messy-queries-to-scalable-systems-how-data-engineering-actually-works) ## Related Articles - [Highest Paying Tech Companies for Developers](https://www.wearedevelopers.com/magazine/220-highest-paying-tech-companies-for-developers) - [What Are The Top Skills Required For Azure Developers?](https://www.wearedevelopers.com/magazine/77-what-are-the-top-skills-required-for-azure-developers) - [Making Data Warehouses Fast: A Developer’s Story](https://www.wearedevelopers.com/magazine/107-making-data-warehouses-fast-a-developer-s-story) - [Best Coding Boot Camps in Germany](https://www.wearedevelopers.com/magazine/237-best-coding-boot-camps-in-germany) - [Dev Digest 121 - AI goes offline](https://www.wearedevelopers.com/magazine/456-dev-digest-121-ai-goes-offline) - [Data Engineer Salary UK](https://www.wearedevelopers.com/magazine/253-data-engineer-salary-uk)