Data Engineer / Systems Architect t

Agile Business Concepts, LLC; Tacoma (WA); Hybrid; USD 140,000 - 160,000; Full time

Job summary

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

The role combines design with hands-on implementation, building ETL/ELT pipelines, data transformations, API integrations, and data models, while ensuring quality, security, and trusted downstream delivery.

Qualifications

• Experience designing and implementing automated enterprise data pipelines.
• Hands-on data integration across enterprise platforms and APIs.
• Ability to design technical architecture and implement it hands-on.
• Experience in secure data integration and data governance in Federal/DoD contexts.
• U.S. Citizenship and ability to obtain a Federal suitability determination.

Responsibilities

• Lead data discovery, architecture, engineering, integration, and modeling.
• Design, develop, test, and maintain scalable ETL/ELT pipelines and workflows.
• Develop SQL queries, relational models, and Dataverse data structures.
• Integrate data via REST APIs and enterprise connectors.
• Ensure data quality, lineage, monitoring, and secure data access.

Skills

SQL

Databricks

ETL/ELT

APIs

Data modeling

Data quality

RBAC

DoD environments

Education

Bachelor's degree in Computer Science, IS, Data Engineering, or related

Tools

Palantir Foundry

Army Vantage

Advana

Dataverse

Microsoft Azure

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.