Data Engineer / Systems Architect t

Agile Business Concepts; Tacoma (WA); Hybrid; USD 120,000 - 190,000; Full time

Job summary

Agile Business Concepts, a federal contracting partner, seeks a highly technical Data Engineer / Systems Architect to lead architecture, development, and delivery of secure enterprise data solutions for Army Vantage/Palantir Foundry, Advana, Databricks, SQL, and Microsoft A365 Dataverse.

The role combines design and hands-on implementation, building ETL/ELT pipelines, data transformations, API integrations, and dataverse data models while ensuring data quality, security, lineage, and reliable

Qualifications

• Bachelor's degree in Computer Science, Information Systems, Data Engineering, or related field.
• U.S. Citizenship required with ability to obtain Tier 1/NACI clearance.
• 3+ years enterprise data engineering; 5+ years strongly preferred.
• Experience in secure data integration within Federal/DoD environments.

Responsibilities

• Lead data discovery, architecture, engineering, integration, and data modeling activities.
• Design, develop, test, and maintain scalable ETL/ELT pipelines and automated data workflows.
• Perform data transformation, cleansing, normalization, mapping, validation, and reconciliation.
• Develop and optimize complex SQL queries, relational data models, schemas, and database structures.
• Integrate data through REST APIs, services, connectors, and other enterprise integration methods.
• Support data integration across Army Vantage/Palantir Foundry, Advana, Databricks/SQL, and Dataverse.
• Design and implement Microsoft Dataverse data models and integrations.
• Establish data-quality controls, lineage, monitoring, exception handling, reconciliation, and automated validation.
• Implement secure data-access and egress using RBAC and least-privilege principles.

Skills

SQL

Databricks

ETL/ELT

APIs

Dataverse

Data modelling

Security

Education

Bachelor's degree

Tools

Palantir Foundry

Advana

Databricks

REST APIs

Dataverse

RBAC

Job description

Location:Camp Murray, Washington / Hybrid
Work Arrangement:Approximately 25% Onsite / 75% Telework

Position Overview

Agile Business Concepts is seeking a highly technical, hands‑onData Engineer / Systems Architectto serve as Key Personnel supporting a Federal/DoD data integration environment. The successful candidate will lead the architecture, development, integration, and delivery of secure enterprise data solutions acrossArmy Vantage/Palantir Foundry, Advana, Databricks, SQL, and Microsoft A365 Dataverseenvironments.

This position requires an engineer who can bothdesign the technical architecture and perform hands‑on implementation, including building ETL/ELT pipelines, developing data transformations, integrating APIs, designing relational and Dataverse data models, and ensuring data quality, security, lineage, reconciliation, and reliable delivery to downstream applications.

Key Responsibilities

• Lead enterprisedata discovery, architecture, engineering, integration, and data modelingactivities.
• Design, develop, test, and maintain scalableETL/ELT pipelinesand automated data workflows.
• Perform data transformation, cleansing, normalization, mapping, validation, and reconciliation.
• Develop and optimize complexSQL queries, relational data models, schemas, and database structures.
• Integrate data throughREST APIs, services, connectors, and other enterprise integration methods.
• Support data integration acrossArmy Vantage/Palantir Foundry, Advana, Databricks/SQL, and Microsoft A365 Dataverse.
• Design and implementMicrosoft Dataverse data modelsand integrations supporting downstream applications.
• Establish data-quality controls, lineage, monitoring, exception handling, reconciliation, and automated validation.
• Implement secure data‑access and egress processes utilizingRBAC, service identities, least‑privilege principles, and appropriate PII/PHI protections.
• Troubleshoot complex data pipeline, integration, performance, and data‑quality issues.
• Produce technical architecture, data‑flow, interface, mapping, and system documentation.
• Collaborate with application developers, cloud engineers, cybersecurity teams, architects, and Government stakeholders.

Required Qualifications

• 3+ years of enterprise data engineering experience; 5+ years strongly preferred.
• Strong hands‑on expertise withSQL, Databricks, ETL/ELT, APIs, relational databases, and data modeling.
• Demonstrated experience designing and implementing automated enterprise data pipelines.
• Experience withdata transformation, cleansing, reconciliation, lineage, monitoring, and data‑quality validation.
• Knowledge of secure data integration, includingRBAC, service identities, PII/PHI protection, and controlled data egress.
• Experience operating within secureFederal or DoD environments.
• Bachelor's degree in Computer Science, Information Systems, Data Engineering, Engineering, or a related discipline, or equivalent relevant professional experience.
• U.S. Citizenship required.
• Ability to obtain and maintain aTier 1/NACI or equivalent Federal suitability determination.
• Ability to support approximately25% onsite work at Camp Murray, Washington.

Highly Preferred Qualifications

Direct hands‑on experience withArmy Vantage/Palantir Foundry and Advanais strongly preferred. Experience withMicrosoft Azure, A365/Microsoft Dataverse, Databricks, DoD IL5 environments, and applicable cloud/data certifications will be highly valued.

Ideal Candidate

The ideal candidate is not solely an architect or advisor. We are seeking ahands‑on technical leader who can architect, build, integrate, troubleshoot, and validate the solution. The individual should be comfortable working directly with data, SQL, pipelines, APIs, Dataverse, security controls, and enterprise integrations while providing technical leadership to the broader project team.

Place of Performance:Approximately25% onsite / 75% telework, with the primary onsite location atCamp Murray, Washington.