Data Engineer/Systems Architect - Army Vantage, Advana & Dataverse

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.

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.

Loyola is a certified Service Disabled Veteran and Minority Owned Small Disadvantaged Business

SDVOSB, VOSB, MOSB and SDB

Pay: From $140,000.00 per year, * 401(k) matching

• Dental insurance
• Flexible schedule
• Health insurance
• Health savings account
• Life insurance
• Paid time off
• Professional development assistance
• Referral program
• Relocation assistance
• Tuition reimbursement
• Vision insurance