JobCubby JobCubby
Sign up
Stralynn Consulting Services, Inc.

Data Engineer / Systems Architect

Stralynn Consulting Services, Inc. Tacoma, Washington, United States

IT Services and IT Consulting · 11-50 employees

Yesterday
data-engineer Mid (2-5 yrs) Contractor United States
Create a free account to apply — email only, no card. You can also save this posting or score it against your profile with AI.

About the role

The Data Engineer / Systems Architect is responsible for building and maintaining secure ETL pipelines and relational data foundations within the DoD IL5 environment. They will also enforce data governance, security protocols, and documentation standards to support downstream application development.

What they look for

Data Engineering Systems Architecture ETL Pipelines Microsoft Dataverse Palantir Foundry Databricks SQL Power Platform Master Data Management Role-Based Access Control DoD IL5 Compliance API Integration Data Modeling Git DevOps Cybersecurity

Requirements

Candidates must have at least three years of experience in enterprise data engineering, cloud architecture, and DoD systems integration. Proficiency in Army Vantage, Advana, and Microsoft Dataverse is required, along with eligibility for a Tier 1 background investigation.

Full description

Position Overview The Data Engineer / Systems Architect serves as the primary technical Lead responsible for transforming enterprise datasets within DoD Impact Level 5 (IL5) environments, extracting them securely, and establishing a highly structured, relational data foundation within the Army 365 (A365) Microsoft Dataverse environment. This position focuses on backend pipeline development, data curation, schema linkage, and access control enforcement to support downstream Power Apps and dashboard developers.

Work Location: Camp Murray, WA (Hybrid: ~25% Onsite / 75% Telework) Work Hours: Monday – Friday, 0600 – 1430 Pacific Time Security Clearance / Suitability: Eligible for adjudicated Tier 1 (T1) / NACI background investigation or higher.

Key Responsibilities• Data Discovery & Assessment: Conduct comprehensive data discovery across Army Vantage and Advana systems to map architectures, evaluate data quality, and produce assessment reports.

  • Native Pipeline Engineering: Build automated, fault-tolerant Extract, Transform, and Load (ETL) pipelines natively within Army Vantage (Palantir Foundry) and Advana (Databricks/SQL).
  • Dataverse Architecture: Design localized data ontologies, star schemas, primary/foreign key linkages, and Entity-Relationship Diagrams (ERDs) optimized for Microsoft Power Platform performance.
  • Secure Data Egress: Deploy secure REST API, OData, or approved connector feeds linking source platforms to the target A365 Dataverse tenant using Non-Person Entity (NPE) / Service Principal authentication.
  • Data Quality & Reconciliation: Apply Master Data Management (MDM) best practices, maintain dynamic Data Quality Logs, and deploy automated reconciliation scripts to verify source-to-target record counts.
  • Security & Governance Enforcement: Enforce Role-Based Access Control (RBAC), Row-Level Security (RLS), Field-Level Security, and automated PII/PHI masking/de-identification to ensure 100% DoD IL5 compliance.
  • Lineage & Documentation: Document full transformation lineage in version-controlled repositories (Git/DevOps), maintain technical Data Dictionaries, and participate in stakeholder synchronization working groups.

Qualifications & Requirements• Experience: Minimum of three (3) years of comprehensive experience in enterprise data engineering, cloud architecture, and DoD systems integration.

  • Technical Expertise: Demonstrated technical proficiency operating natively across:• Army Vantage (Palantir Foundry)
  • Advana (Databricks / SQL)
  • Microsoft Dataverse (A365) backend architecture
  • Cyber Workforce Alignment: Compliant with DoD Cyber Workforce Framework (DCWF) work roles (e.g., Data Analyst 421 or Database Administrator 451) under DoDM 8140.03 standards.
  • Remote Access Capabilities: Able to perform remote duties via Army Enterprise Azure Virtual Desktop (AVD) utilizing CAC credentials.

Similar roles