Senior Data Architect & ETL Engineer (IL5)

Stralynn Consulting Services, Inc.; Tacoma (WA); Hybrid; USD 120,000 - 150,000; Full time

Job summary

Stralynn Consulting Services, Inc. seeks a Data Engineer / Systems Architect to lead secure data transformation within DoD IL5 environments, building a structured Dataverse foundation to support Power Apps and dashboard developers.

You will implement natively engineered ETL pipelines and enforce governance across source systems and target tenants. The role requires experience with Army Vantage, Advana, Dataverse, and secure data egress, plus DoD DCWF alignment.

Qualifications

• 3+ years in enterprise data engineering and cloud architecture.
• Experience with DoD systems integration.
• Familiarity with Army Vantage, Advana, and Microsoft Dataverse.
• DCWF alignment under DoDM 8140.03 standards.

Responsibilities

• Data discovery across Army Vantage and Advana to map architectures and assess quality.
• Build automated, fault-tolerant ETL pipelines within Army Vantage/Advana environments.
• Design Dataverse ontologies, star schemas, and ERDs for Power Platform performance.
• Enforce secure data egress via REST API, OData, or approved connectors with CAC-authenticated access.
• Maintain data quality logs, MDM practices, and automated reconciliation scripts.
• Enforce RBAC, RLS, and field-level security to ensure DoD IL5 compliance.
• Document transformation lineage in Git/DevOps and maintain data dictionaries.

Skills

Data engineering

Cloud architecture

DoD integration

RBAC & security

MDM & data quality

ETL pipelines

Tools

Palantir Foundry

Databricks

SQL

Dataverse

Git/DevOps

Job description

Stralynn Consulting Services, Inc. seeks a Data Engineer / Systems Architect to lead secure data transformation within DoD IL5 environments, building a structured Dataverse foundation to support Power Apps and dashboard developers.

You will implement natively engineered ETL pipelines and enforce governance across source systems and target tenants. The role requires experience with Army Vantage, Advana, Dataverse, and secure data egress, plus DoD DCWF alignment.